Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax for date parameter

Status
Not open for further replies.
skeelo

skeelo

Programmer
Aug 14, 2002
12
CA
I have a query that needs 2 dates entered to determine student absents between those dates.

>[Date to print from:]-1 And <[Date to print to:]+1

I am getting an error that says its too complex. Any suggestions would be appreciated.
 
Sort by date Sort by votes
You need to do eihter one of these:

Column > [parameter] and Column < [paramemter]

or

Column BETWEEN [parameter] and [parameter]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
291
OzFoxy
OzFoxy
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
788
dhookom
dhookom
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
872
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
602
mikrom
mikrom
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
525
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top