Adding a Where to a Macro - Microsoft Access Forum

3 hours ago: Doing some maintenance on the server today. If you've placed an order and it hasn't processed yet, hang in there. Should be ready soon. I've got the car up on the jack and the tires are off... Dismiss

Free Lessons
Courses
Seminars

TechHelp
Fast Tips
Templates

Topic Index
Forum
ABCD

Home Courses TechHelp Help Contact Merch Join Order Logon Forums

Home > Forums > Access Forum > Adding a Where to a Macro by Tim Elbert


	Back to Access Forum Comments List

Adding a Where to a Macro

Tim Elbert

13 months ago

I have a button that selects orders for printing. I want it to select only those orders created after 6/1/2025. I tried the 'where' string in the picture but it returns an empty form. Any idea what I'm doing wrong? I am new to macros...

	Tim Elbert OP @Reply 13 months ago

	Donald Blackwell @Reply 13 months ago
Tim Where Condition = = "[Customerld]=" & [Customerld] & " AND [DateOrdered]>#6/1/2025#" This should give you all orders for the customer with that id after 6/1/2025. If you want to make it so you can change the date on the fly, you would need to have to modify the date part of the where string such as: [DateOrder]>#" & [FieldNameHoldingDate] & "#"

	Tim Elbert OP @Reply 13 months ago
Thank you Donald!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen