If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switch function in crosstab query.
I have created a switch function in a crosstab query to combine data into specific column headings. However, I need to have static column headings for the report that I will create from the query. So, if there is no data for that particular heading, I need to have it show a zero on the report. Currently, if there is no data for that column, when I run the report, I get an Jet error stating that it does not recognize " as a valid field name or expression.
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Function Key to switch back and forth between Switchboard and Edit | Amy | New Users | 2 | July 14th, 2004 01:49 PM |
Using Switch Function to Group Column Headings in a Crosstab Query | Karen | Running & Setting Up Queries | 5 | June 25th, 2004 05:52 PM |
Use of Last function in a query | Andy | Running & Setting Up Queries | 7 | June 24th, 2004 09:41 AM |
Dates in Crosstab Query | sbeiler | Running & Setting Up Queries | 1 | June 8th, 2004 02:03 PM |
Dates In a CrossTab query | Box 666 | New Users | 1 | May 21st, 2004 04:01 AM |