Query to only show when 1 field date is greater than another (1 Viewer)

Number11

Member
Local time
Today, 18:18
Joined
Jan 29, 2020
Messages
607
So is it possible for a query to only show records when the ordered date is greater than the requested date?

I have fields

Acc No
Request Date
Part Number
Ordered Date
Order Number
 

jdraw

Super Moderator
Staff member
Local time
Today, 13:18
Joined
Jan 23, 2006
Messages
15,379
Possible -- yes. But perhaps you could tell us more.
FYI -- field names in Access should not have embedded spaces.
 

Number11

Member
Local time
Today, 18:18
Joined
Jan 29, 2020
Messages
607
got it working using this :)

popped in the Order Date Criteria

>[Request Date]
 

Users who are viewing this thread

Top Bottom