| | |
|
|
|
Querry Date |
|---|
| message from Robb on 10 May 2004 |
I understand how to do a date future date calculation on a
form what I need it to do is to do the date calculation in
the query so that I can see the data in the query lookup,
as of now it only shows the future date calculation on the
form. Please help
Robb
|
| Arvin Meyer replied to Robb on 11 May 2004 |
Most common VBA expresssions will run in a JET query (but not in a SQL View
or Stored Procedure) Remove the = sign and add a column alias name like:
FutureDate: DateAdd("m",1,Date())
which adds 1 month to today's date.
|
|
Archived message: Querry Date (MS Access Error Message)
