Make query print YES or NO for certain Criteria

[taimysho0]

Hello, I have a query that looks at a table showing what time a file comes in. if the file comes in today (Date()), then in a sperate column field, i want it to display YES for that row. if it did not come in today. then print NO on that column field for that particular row.

not sure if this is possible. thanks for any help

[pbaldy]

Should be easy, presuming the date the file came in is in a field:

IIf(FieldName = Date(), "Yes", "No")

[taimysho0]

thank you!

[pbaldy]

No problemo!