Using a field in a quary

  • Thread starter Thread starter dm16s
  • Start date Start date
D

dm16s

I have two fields. A return date and a sold date.

I want to have the criteria for the return date to be "if the return
date is greater than the sold date field" (basically to check if
something had been returned before it was recorded as bought so I can
look into it)

Any help on how to do this with dates?
 
I think there were to opposite statements in the OP
"if the return date is greater than the sold date field"
"check if something had been returned before it was recorded as bought"

--
Duane Hookom
MS Access MVP


Van T. Dinh said:
I think the criteria should be: < [ReturnDate] ???

--
HTH
Van T. Dinh
MVP (Access)


Duane Hookom said:
How about
Field: SoldDate
Criteria: >[ReturnDate]
Click to expand...
Click to expand...
 
Back
Top