Querry Date

  • Thread starter Thread starter Robb
  • Start date Start date
R

Robb

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
 
Robb said:
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
Click to expand...

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top