Filling query with zero values (scale problem)

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

Guest

Hello!
I have a query calculating statistical distribution, but not all values are
presented in the source table. (e.g. 1,2,3,5). How can I fill the result
query with values between min (1) and max (5) with step (1 in this example)
in order to preserve the scale of the distribution?
1001 thanks
 
The non-existent values have to come from somewhere.

Create a table that contains a record for each number across the entire
range you could ever need. It just needs one Number field, marked as primary
key.

Add this table to your query.
Drag its field onto the primary key of your table with the missing numbers.
Double-click the join-line between these 2 tables.
Access pops up a dialog with 3 options.
Choose the one that says:
All records from [name of the counter table],
and any matches from [name of your existing table]

There is an example of how to set up this kind of table (for another
purpose) and code to programmatically populate it in this link:
http://allenbrowne.com/ser-39.html
 
Back
Top