show zero values in query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database that analyses telecoms data for a number of
clients, each with their own list of numbers. I have a master data list that
contains weekly call data. This is matched up to the list of numbers for each
client and a report produced showing calls to those numbers for a given week.

What it doesn't show is where there haven't been calls to a certain number
(as there is no data to show). How do I show the whole list of numbers,
including those where there is no data for the given time period ?
 
I have an Access database that analyses telecoms data for a number of
clients, each with their own list of numbers. I have a master data list that
contains weekly call data. This is matched up to the list of numbers for each
client and a report produced showing calls to those numbers for a given week.

What it doesn't show is where there haven't been calls to a certain number
(as there is no data to show). How do I show the whole list of numbers,
including those where there is no data for the given time period ?
Click to expand...

Create and save a query on the Calls table selecting the calls for the
desired date range; join this query to the master table, and select
the join line in query design view and choose option 2: "Show all
records in Master and matching records in qryCalls".

John W. Vinson[MVP]
 
Back
Top