Morning All,
I'm currently trying to get my head around MS Query Criteria....
I am looking to use the criteria to filter my results to show any items that have a despatch date between any date in the past and up to 10 days in front.
Criteria.jpg
This is an image of the field I need to code.... but for the life of me, I haven't a clue on how to write it.
Any help would be greatly appreciated.
Many Thanks
Ross
Have you tried
=Date()+10
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
This looks like an Access query. If so let me know and I'll move it to the Access sub forum.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I'm using EXCEL and am needing the same exact answer. The above looks to be taken from Excel, not Access.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks