Access wildcard character reference (v2003)
Will answer most of your questions.
The date becomes tricky...
Say I have a table with shipping dates, and I want to return every instance where there was a shipment on the 10th day of the month for evey record then the sql would be:
- SELECT tbl_shipdate.ShippedDate
-
FROM tbl_shipdate
-
WHERE (((tbl_shipdate.ShippedDate) Like "*/10/*"));
-
However say I want between dates
- SELECT tbl_shipdate.ShippedDate
-
FROM tbl_shipdate
-
WHERE (((tbl_shipdate.ShippedDate)
-
Between #1/1/2010#
-
And #1/15/2010#));
What about every date past a given date:
- SELECT tbl_shipdate.ShippedDate
-
FROM tbl_shipdate
-
WHERE (((tbl_shipdate.ShippedDate)>=#1/1/2010#));
-
To make my life easier from a coding standpoint, I try to keep to the "#" type constructs and bracket the time frame using either the between or ">=" or "=<" types. However, that doesn't always work.
If you have a specfic filter issue post back and we can straighten that out.