Crosstab query - how can I pull out blank or null fields?

  • Thread starter Thread starter chrisb
  • Start date Start date
C

chrisb

I am trying to produce a data dump from a table held in
access using a crosstab query. Unfortunately I need to
pull out data from a set field that is null, but at the
moment I cannot find a way of doing it - any help??

The reason I need the null data is so I can use a formula
in Excel without changing it each month with a new data
download
e.g. one month I could have the following:

White:8
Black:4
Red:2

and the following month I can have:

White:6
Black:3
Green:2

So how do I get a crosstab to pull out all 4 colours each
month?

Hope this makes sense!
 
You'll need to create a colors table, and populate it with All four colors.
Link the colors table to the other data table. Change it to be a Left Outer
Join, such that all color names are displayed.
Crosstab it.
If you want to specify the order of the columns, use the columnheadings
property.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top