Exclusion

oklahoma84

Registered User.
Local time
Today, 04:53
Joined
Jun 5, 2007
Messages
15
I have several tables with different infomation in them. When i join them in a crosstab query, it leaves out data that is not available in all fields. How can i get it to leave blanks in these spots and include the rest of the information.

i.e

Dept subaccount MTD YTD Prior YTD
1234 001 $500 $1000 $750
2345 002 235 750 900
3455 004 345 800

Currently my sheet would leave out the last line because there is not data for the prior information. I instead would like the information to appear just having a blank where there is missing data. Hope I am making sense! Thank you for your help!!
 
Crosstabs intentionally omit blanks as "things not there."

Is it that the items are NULL or just empty strings?

If NULL, you have to include the NZ function to substitute something for nulls when you find them. Or there is the IsNull function that can be used with IIF to provide a reasonable substitution.

If EMPTY, the IsEmpty function could be used with an IIF to get a similar result.
 
The one field is just empty for this one set of records. Can you help me with the isempty expression? Where would I put this?
 

Users who are viewing this thread

Back
Top Bottom