H
harvestman
Andrew:
Based on the coding yiou gave me (for "TextToDate" in
answer to solving "Multiple date formats in a Table", I
have created a module and successfully run the tests, but
when I try to perform the query I get an alert stating:
"Data type mismatch in criteria expression".
I have gone thru my records and checked them for
consistency, noting a few glitches in the format of month
component and amended these to be consistent with all the
other "mmm" dates, but I still get this alert.
You suggest that I might need to do some tweaking... so
I'm not sure if you are referring to your coding or to my
original text formatted date setting records.
I have tried doing crosstab queries, but these are
ineffective because of this unresolved date sorting
problem.
See also my responses dated 13-April and 14 april under
original subject heading.
cheers,
harvestman.
Based on the coding yiou gave me (for "TextToDate" in
answer to solving "Multiple date formats in a Table", I
have created a module and successfully run the tests, but
when I try to perform the query I get an alert stating:
"Data type mismatch in criteria expression".
I have gone thru my records and checked them for
consistency, noting a few glitches in the format of month
component and amended these to be consistent with all the
other "mmm" dates, but I still get this alert.
You suggest that I might need to do some tweaking... so
I'm not sure if you are referring to your coding or to my
original text formatted date setting records.
I have tried doing crosstab queries, but these are
ineffective because of this unresolved date sorting
problem.
See also my responses dated 13-April and 14 april under
original subject heading.
cheers,
harvestman.