Re: Union query not working properly if no records exist

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 10:44:33 -0600

On Mon, 20 Sep 2004 03:56:31 -0700, "Tony"
<anonymous@discussions.microsoft.com> wrote:

>The cross tab pull
>together all records for all tables but if no records
>exist in a certain table then it doesn't show a column
>heading for that table.

List all the desired column headers in the Headers property of the
crosstab query (right mouseclick the table background in design mode).
This will force the existance of a column even if it has no data.

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps