I'm trying to write a select query that counts the number of records for a
particular time frame, tying the city field from the main record-holding
table to a second table with just city and state fields so I can return a
count based on the states. I can count the cities okay in one query, and I
can join the tables okay in one query, but I can't manage to do both in one
query. Essentially I want the results to list the states and count of their
records. How do I accomplish that? Thanks for any help with this.
Re: Using the highest count for the field name in a query ... Group By ZipCode...Query Two based on the table and query one ... I would like to query this data so I can get a totalof peoples visits by their 5 digit zip code. ... I would like the total for all trips in that zip code but have only the city or town with the most visits listed in the city field.... (microsoft.public.access.queries)
Re: Table all in uppercase when imported into Access ... Create a query into this table. ... Access adds an Update row to the grid.... StrConvexpression into the Update row under the City field.... to convert to all upper case; ... (microsoft.public.access.conversion)
Re: Repeating and item in a column ... >gives me explicit directions on doing them. ... Create a new Query.... Select only the City field.... You can put criteria on the Criteria line to make this a selective ... (microsoft.public.access.tablesdbdesign)
Re: Only Update per criteria ... Please post the SQL view of your query, and an example of the problem ... that you are having (what you have in the city field,...John W. Vinson ... (microsoft.public.access.queries)
My form wont let me enter new records ... I am very new to access, and am creating an address database.... I'm tying to ... tables, to create a form to enter the data, it gives me an index message.... The form, created from the query, won't let me enter new data. ... (microsoft.public.access.gettingstarted)
