debbiecarvery
MIS
Hello,
I have a report that runs from a crosstab query the crosstab is built from a regular query. Here are my 2 problems.
1. There are 6 heading in my crosstab that I need to show on my report. As long is there is information in those fields I have no problems. If for any reason no data is entered in one of those fields my report will not run. I get an error that reads something like "Field name does not exist".The actual field is text but calculated as a number for example the report calculates how many customer cancelled on a particular day and puts a number under the heading "Cancel", problem is if no customers cancelled that day, my report can not be ran.
2. Date range. I can put a date range in my original query that promts a parameter. I would like for this parameter to promt directly from the report. I am not sure where to put this criteria in the original query ? My crosstab query ? or directly in the report. Not sure what to enter either.
This is my first time building a report based on query and a crosstab query so please be gentle with me.
Thanks a whole lot,
Debbie
I have a report that runs from a crosstab query the crosstab is built from a regular query. Here are my 2 problems.
1. There are 6 heading in my crosstab that I need to show on my report. As long is there is information in those fields I have no problems. If for any reason no data is entered in one of those fields my report will not run. I get an error that reads something like "Field name does not exist".The actual field is text but calculated as a number for example the report calculates how many customer cancelled on a particular day and puts a number under the heading "Cancel", problem is if no customers cancelled that day, my report can not be ran.
2. Date range. I can put a date range in my original query that promts a parameter. I would like for this parameter to promt directly from the report. I am not sure where to put this criteria in the original query ? My crosstab query ? or directly in the report. Not sure what to enter either.
This is my first time building a report based on query and a crosstab query so please be gentle with me.
Thanks a whole lot,
Debbie