append query doesn't work since can't recoqnize field

  • Thread starter Thread starter juan
  • Start date Start date
J

juan

Hi,
I have a crosstab query and then I used this to do an
append query. My append query was based on 2004 data, but
since i'm using 2005, there might not be data for that
field. so the append query doesn't work. Example, fields i
have on my append.
01 02 03 04 05 06 etc to 15 but let say in my crosstab
query I only get 01 02 04 06, so when I try to run the
append I get error saying Does not recoqnize 03 as a valid
field. So is there a way around this?

Hope I'm clear,

please advise any input. Appreciate the help.

Thanks,

Juan
 
Well, you can specify the column names in an in Clause at the end of the
crosstab query.

If you are building this in the query grid, then use the column headings
property of the query to enter
"01","02","03" etc.

In the SQL Statement it would be something like
TRANSFORM ...
SELECT ...
FROM ...
GROUP BY ...
PIVOT SomeField in ("01","02","03",...,"15")
 
Back
Top