I have the following fields and I want to create a query that will give me
the top 5 in each category.
Product make  
Product model

I wanted to know how you can update data in a table using the update query
and a parameter query.

My table has an Case ID, date, start time and stop time. I need to be able
count the records with overlapping times. This is an OR utilization
application and we want to know how many cases we have going on at the same
time. For example: Case 1 Start time 11:00, Stop time 12:58; ...

I posted and received a response to my question (see below) about  getting my
database to come up with a list of forms issued and the last number issued
for each.  Bob  Quintal was kind enough to respond and I tried his suggestion
but was unsuccessful.  After cutting, pasting and ...

I have created a table with the following fields
ID (autonumber)
RID (Lookup)
Weight (number,Single, 1 decimal place)

I run my query but instead of listing just the childs name for each social
worker, it lists all the childrens names under each social worker.

I have a table that has a short date field (Field1), and another General Date
field (Field2). Can I set up a query to look between 2 dates using "Field1"
and then ask for times between 10pm and 8am using "Field2"?
My goal was to look at a specific month and see the volume of calls ...

Hello! I'm a n00b at Access and trying to learn by doing. I have a
very specific task I'm trying to accomplish and it's very complicated
(to me, at least). I'm hoping this is one of those "oh, but the
solution is so simple!" things that you just can't know as a

I need to create a query to select dates that are between date 1
(1985-11-04) and date 2 (1985-11-11). Currently no records are showing up
when I do this:
Between (1985-11-4) And (1985-11-11)

i have a data base that has data in a field showing 200101 to 200710
i need to pull data between 200101 and 200112, then 200201 and 200212 ., etc.
I have tried between but to no avail

I am experimenting with parameter queries and am wondering if anyone has ever
managed to swap a list box with the default box that pops up asking for a
parameter value to be entered. My thinking is the list box in its place would
be more user-friendly as the user would only have to ...

Using Linked MS SQL Server Tables in an mdb Access Database, if a query (not
passthrough) includes joins, where, groupby (summations), and order by
statements, what part of the query is executed on the SQL Server and what
part is executed locally in Access?

I have a database that list clients...I want to create a report that is only
open clients and excludes closed clients.  I created a query on which to base
the report but I cannot seem to eliminate the clients that have been closed.
Any suggestions?

Thanks for any help.
I have a query and I would like to add to it a field that concatenates
fields from records it groups.
So the query is like: