Access 2000 "Between" query question:
I am relatively new to MS Access and everytime I think I have a basic
concept of the program it pokes me in the eye with something I think
would be simple to create.
I want to create 2 separate queries for a label. I would like to have
the query prompt me for the date I choose to start from until the
present date and the other to prompt me for the date I choose to start
from and 2 additional numbers of days.
I tried this express for the second of my queries for the Criteria but
it didn't work. Why?
Between [Table]![Field] And DateAdd("d",2,[Table]![Field])
I have absolutely no clue how to create the other query. If anyone out
here can help I would greatly appreciated it and so would what left of
my hairline!
Ja******@jumpy.it