Solved Query Show records before a date on a form

Number11

Member
Local time
Today, 09:13
Joined
Jan 29, 2020
Messages
625
So i need to have a query being back all records added before a date on a form.

Tried this but didnt work
<[Requests].[Date]

get a prompt

1645617260413.png
 
Try:

< Forms!Requests.Date

Advise not to use reserved words as names. Date is a reserved word.
 
Try:

< Forms!Requests.Date

Advise not to use reserved words as names. Date is a reserved word.
Thanks changing this to

< [Forms]![Requests].[Date]

worked
 

Users who are viewing this thread

Back
Top Bottom