R
rhoisy
I have a Cross Tab query. I have built a series of querys to get data into
the correct format. The cross tab builds Colums with the date as the header,
but I changed that to a Column name, but Access still know the column names
as the dates in the cross tab when it is linked into a new table, that
becomes the colum name. The cross tab uses the Now() and Addmonth routines to
be current. But when the next level of table trys to load it always looks for
the dates from the month that is droping off and not from the new month.
Any idea?
the correct format. The cross tab builds Colums with the date as the header,
but I changed that to a Column name, but Access still know the column names
as the dates in the cross tab when it is linked into a new table, that
becomes the colum name. The cross tab uses the Now() and Addmonth routines to
be current. But when the next level of table trys to load it always looks for
the dates from the month that is droping off and not from the new month.
Any idea?