PDA

View Full Version : MS Access Help



Vbrah
04-24-2014, 05:57 PM
posted this in the regular misc but i think i shouldve posted in here. need help running a query. its a purchasing process and i have to run a query only showing purchases NOT received within 3 days of the order date. so i have the order date field and the receipt date field. wtf do i put as the criteria??

tdnick
04-24-2014, 07:01 PM
If you would have asked a year ago, I could have told you. Funny how I forgot all of that already


I'm not exactly sure how you would word it but would you use the date and then put "and" and the link it to order paid for? And then put yes?


Aw fuk nvm that won't work. Uh you're going to have to use some greater than or equal to 3 somehow