CODEWITHSUNDEEP
sqlms-accessvba
antony samid
antony samid

Reputation: 1

SQL. Query for vba

I have a table that has more than one date fields (say six or seven) and I just want to retrieve only the dates that match today's date. Please help. Really appreciate it thanks

Upvotes: 0

Views: 47

Answers (1)

JCalcines
JCalcines

Reputation: 1286

This is a very specific problem, so the best way to get the result you want is to code some part as an script on access.

For getting those rows where at least one date is the same as today's date, you should use something like this.

SELECT * FROM Table t
WHERE Date() IN (t.field1, t.field2, ...)

You should add all the fields you want to check inside IN clause.

On the Access for you should be able to process the data.

Upvotes: 1

Related Questions