Cross tab IF statement

[nathan_savidge]

Hi

I have a database that imports 50 spread sheets each week. What i have is a
cross tab query based on a date criteria (IMPORT_DATE) being >=date()-7.

This works fine. I use this as a way of checking the import as each row
count should go up or plateau each week. Can i tag an if statement on the
end to check that this is the case i.e. iif(last week row count <=this week
row count, "OK", "CHECK")

TIA

Nathan.

 

[KARL DEWEY]

Post an example of what the crosstab output would look like using real numbers.