Type mismatch in expression

[Liz C]

I have a query named PPA2Q, based on a pass-through query "VOLQ". The fields
in PPA2Q are meter, prod_date, and max_acct_period (to pull the max
accounting date for each production period). I am then trying to create a
third query, joining PPA2Q with the original VOLQ in order to get the other
fields (dth and mdq).

I put the PPA2Q in the query grid and selected meter, prod_date, and
max_acct_period and then I added VOLQ and joined just the meter to start
with. When I try to view it, I get the "Type mismatch in expression" error.
How can there be a type mismatch when I'm joining the same information that's
coming from the same source?

Thank you in advance for any help you can provide!

Liz

 

[MGFoster]

I have a query named PPA2Q, based on a pass-through query "VOLQ". The fields
in PPA2Q are meter, prod_date, and max_acct_period (to pull the max
accounting date for each production period). I am then trying to create a
third query, joining PPA2Q with the original VOLQ in order to get the other
fields (dth and mdq).

I put the PPA2Q in the query grid and selected meter, prod_date, and
max_acct_period and then I added VOLQ and joined just the meter to start
with. When I try to view it, I get the "Type mismatch in expression" error.
How can there be a type mismatch when I'm joining the same information that's
coming from the same source?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sometimes Access transforms column data, from multiply formed queries,
to strings. I've found that I have had to explicitly define the data
types for various columns. E.g.:

SELECT CDbl(Q.number_column) As NumberColumn, ...
FROM QueryName As Q
.... etc. ...

Where the query QueryName is the result of multiple queries.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSUshNoechKqOuFEgEQKuUACfbi3JuizFWfV3cFL2sq/2g/6vGQMAoMCJ
0TMm40e5L1FKz1Pgb2Y44Nac
=mfGP
-----END PGP SIGNATURE-----