doesnt recognize field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a crosstab query that i run, and here is the problem. I start with
data from another database and i am pulling it into access. I do this once a
week. The problem is the column heading field. One week it creates the query
say with 5 different column headings based on my data. Then the next week i
may not have that same data in my table and it then doesnt understand the
column field because it is no longer in the table how can i have it
always recreate this crosstab i hope this makes sense.
 
Dear db:

If you were to use a "make table" query this would solve the problem.

An alternative, but more complex, would be to have a query that determines
how many columns the crosstab will be creating. This will be a VBA process
to define the table.

A third alternative is to create a table with plenty of columns in it and
append that table.

There are considerable details in these latter two solutions.

Only the third solution above would allow you to place the crosstabs from
several weeks into one table The other solutions would generally require a
new table every week.

Tom Ellison
 
i dont think i was clear sorry, i have a make table with say column fields
of 1,2,3
and then the next week the data is 1,2,3,4,5 and the next week it is 1,2,3
again. I am creating a report based off of this crosstab. so the 2nd week
when i run the report it doesnt recognize fields 4,5 because they werent in
the original report. i thought about sending the data from the crosstab to
another query but you have to manually go in and add the new columns 4 and 5
then it works is there a way to add these new columns that the
crosstab created without manually doing it in the query
 
Dear db:

What I said about the query stands. As for the report, you can build it
with sufficient columns for the maximum to be handled. Then at run time,
remove the unneeded columns.

Tom Ellison
 
Do you ever know the complete list of possible columns generated? If so,
enter all of these values into the Column Headings property of your crosstab
query.
Column Headings: "1","2","3","4","5"
 
Back
Top