N Number11 Member Local time Today, 08:56 Joined Jan 29, 2020 Messages 625 Feb 23, 2022 #1 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
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
June7 AWF VIP Local time Yesterday, 23:56 Joined Mar 9, 2014 Messages 6,126 Feb 23, 2022 #2 Try: < Forms!Requests.Date Advise not to use reserved words as names. Date is a reserved word.
N Number11 Member Local time Today, 08:56 Joined Jan 29, 2020 Messages 625 Feb 23, 2022 #3 June7 said: Try: < Forms!Requests.Date Advise not to use reserved words as names. Date is a reserved word. Click to expand... Thanks changing this to < [Forms]![Requests].[Date] worked
June7 said: Try: < Forms!Requests.Date Advise not to use reserved words as names. Date is a reserved word. Click to expand... Thanks changing this to < [Forms]![Requests].[Date] worked