Display all row headings in cross-tab query

  • Thread starter Thread starter smduello
  • Start date Start date
S

smduello

I am trying to do a crosstab query, and even though I have a table
with all the possible locations (as row headings) it won't display
them if they have no value. It only displays the row if it finds a
value in the column even though I have linked them and told it to
display all from the first table. Anyone know of a fix for this?
 
Make sure you use a Left join from first table to second table.
Post your SQL if you still have problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates not added in a Cross Tab Query 4
Cross Tab Query Total Formula 1
Ordering of Cross Tab Query 7
Crosstab Loosing shape 1
Cross tab query solution 4
Memo field in cross tab query 2
Crosstab Query Results 3
Crosstab query - MS Access 2000 2

Back
Top