There were 2 databases originally where one has demographic info and other has make & model of car reported for each record, joined by an ID field as primary key.
2nd database has model of car reported under fields of different car makes.
I made some first queries (LA, SF, NY) separating the records according to different cities (LA only has info for ID's in LA, etc.), then based on that query I made a query to...
iht
Last Activity: Dec 20 '06, 08:09 PM
Joined: Nov 28 '06
Location:
-
One report to list out different queries with same fields?
Say I have a database with types of car driven by people living in different cities.
I made several queries to separate out the database according to city, then made queries to count out numbers of cars. So what I have now are queries those tally different car types in each city (simplified version):
LAQuery
[Total] [NumHonda] [NumToyota] [NumFord] [NumBMW]
50 5 10 15 20
NYQuery... -
Count total occurrences in different fields
Fairly new to Access and really doesn't know much about SQL except some basic commands. Currently I'm working with a database that I've already sorted by some queries, and here's a simplified result.
Query1:
Name A B
Smith_A Ya [null]
Smith_R Yb Ya
Smith_C [null] E
Smith_B E Y
So far I can count occurrences of "Y"...
No activity results to display
Leave a comment: