Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Cross Tab Queries as Report Source

Cross Tab Queries as Report Source

Cross Tab Queries as Report Source

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

RE: Cross Tab Queries as Report Source

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

RE: Cross Tab Queries as Report Source


That is simple and sweet.  Works like a dream.

Thank you very much.

Larry De Laruelle

RE: Cross Tab Queries as Report Source

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close