if null statement for an append query

[TMcD]

I've built this database that works just dandy if I have data in all categories. If I pull data (from huge warehouse database) and append to my main table, is there a way to make sure there's a value in all fields? Should I do something on the query? Or, make an adjustment to the table set-up?

 

[llkhoutx]

What do you want stored for Nulls? Put that in you iif in your append query columns.

 

[TMcD]

Perhaps I was unclear; or, I just don't understand the reply. Let me try again....the incoming data will fill a column. In order for the subsequent queries to work, I'll need at least one of each values (1-6) that would have a number count associated with it (ex: 1-25, 2-10, 3-115, etc). But, if for that day's data there's not a 3, how would I enter 3-0? Is there a way to have the program find empty cells and enter 0? Would that be better handled on the table, once the data gets there? Or in the query that puts the data in the table? Hopefully this is more clear. Thank you.

 

[llkhoutx]

"YourField_:iif(isnull([Yourfield]),"",[YourField])" (without the beginning and ending quotation marks) on the field row of your append query for field "YourFfield."

 

[Pat Hartman]

Once the data is all loaded, you would need to run queries that look for missing rows and append them if necessary. If the problem is related to cross-tab queries, you can "fix" the columns of a crosstab by listing all possible column values in the column heading property.