Hi,
I have a report were I have to list the 'Products' along with the 'week' were there is no corresponding 'status' entry made for a given period. I want the report to display the week with blank cells for the status which I can replace with a string "Missing".
I tried using the 'is Null' operator but unable to bring up the records with no status entries.
Can anyone suggest how I can achieve this...
Thanks,
Willie
Crosstab or list?
When you say there is no corresponding status entry, do you mean there is no record for that product/week, or that a column is not populated with a status value in an existing record for that product/week?
If there is no record, you'll need an additional table or tables to select product/week combinations from. If there is a record, you need to find out what the status value is - if it's not null, then perhaps blank or some default value like zero.