Cross Tab Queries as Report Source 1

[LarryDeLaruelle]

General question on how to handle changing results when using cross tab queries as the source for reports.

I encountered a problem with one of my reports which tracks residents receiving any of several medications by date prescribed. The queries' column setting is the field that contains the medication name; row is the resident name; the prescription date is returned as a value under the medication column.

When the report was first created at least one resident was receiving at least one of the seven tracked meds and each was included in the detail line.

The problem now is that one of the tracked meds is not being administered to any resident (but may be again at any time in the future) and the cross tab does not contain a column for that med even though the report still has the original seven. As a result I get a message that Access does not recognize the name of the report's control for that med. (Hope that wasn't too confusing.)

Is there a way to trap for this error in the On Open or On Format events? And, if so can anyone help me with the syntax?

Thanks much.

Larry De Laruelle
larry1de@yahoo.com

 

[maria28gr]

To display all the columns in a crosstab query, even if the columns contains no data: Use the ColumnHeadings property to specify all the columns you want to display, ie: "January", February, etc.
With this way you also specify the order of the columns.

Also, have a look to Access2000 Help "ColumnHeadings Property" for a more detailed description

 

[LarryDeLaruelle]

maria28gr:

That is simple and sweet. Works like a dream.

Thank you very much.

Larry De Laruelle
larry1de@yahoo.com

 

[Guest_imported]

where the fit RDBMS in following points are:
1. user
2. OS
3. Hardwere