Hello,
In Excel pivot tables, there is an option to show items with missing data. I often use this to create a new dataset with zeros to export for analysis. I try and show a small example below. I feel there probably is a way to do this directly in access, and I've tried to left-join two queries but to no effect. Can anyone suggest an approach to do this? I do this so many times that it would be a great help.
Thank you, hope this is clear.
Jim
Morgantown, WV
Example of entered data with a survey plot, the species found, and how many:
Plot 1, Species A, 7
Plot 1, Species B, 3
Plot 1, Species C, 3
Plot 2, Species B, 2
Plot 3...
Wish for in an access select query:
Plot 1, Species A, 7
Plot 1, Species B, 3
Plot 1, Species C, 3
Plot 2, Species A, 0
Plot 2, Species B, 2
Plot 2, Species C, 0
Plot 3...