have query show 0 value

[bassstuf via AccessMonster.com]

I am trying to create a query that will count the number of records per RMA
Number at a location, I just cannot get it to show the when the location has
"0".

The 3 columns I am using are
RMA number
Part Number
Location

Im a newbie as well

 

[mscertified]

You cannot count something that is not there. You need a table of all
locations, then you can do a LEFT JOIN and then the result set will show
missing locations as having NULL in the appropriate columns.

-Dorian

 

[bassstuf via AccessMonster.com]

im still really confused about what to do, I have the locations on a table
(not as there own fields) and when I joined them, the who table came up blank.

You cannot count something that is not there. You need a table of all
locations, then you can do a LEFT JOIN and then the result set will show
missing locations as having NULL in the appropriate columns.

-Dorian

I am trying to create a query that will count the number of records per RMA
Number at a location, I just cannot get it to show the when the location has

[quoted text clipped - 6 lines]

Im a newbie as well

 

[KARL DEWEY]

Post the SQL of your query where you joined them.
--
KARL DEWEY
Build a little - Test a little

im still really confused about what to do, I have the locations on a table
(not as there own fields) and when I joined them, the who table came up blank.

You cannot count something that is not there. You need a table of all
locations, then you can do a LEFT JOIN and then the result set will show
missing locations as having NULL in the appropriate columns.

-Dorian

I am trying to create a query that will count the number of records per RMA
Number at a location, I just cannot get it to show the when the location has

[quoted text clipped - 6 lines]

Im a newbie as well