I've got a table/query of data, which has: Year Group & Student. I have
grouped the students by Year Group, but I want the groups of data to appear
in a specific order on the report.
ie. F, L5, U5, L6, U6

I have a query which has the fields category, subcategory and description.  
There are multiple exceptions per category, subcategory and description.  I
want to pull out the top 3 descriptions per Category and Subcategory.  How do
I do this?

I have 9 form-based parameter queries set up ... one for a header form and 8
for related subforms.  Is there an easy way to tell them (one at a time ...
or all at once) to use a different form as a criteria for a specific run?  
(The database COULD be used by multiple people at ...

Hello!  I am having to redesign a website where one of the main functions is
the ability for the visitor to search a large inventory database.  I'm not
very familiar with web databases, much less how to make it searchable.  My
biggest issue is that I really need to figure it out ...

I need to poll records from two tables if
left([table1].[field1], 3)=left([table2].[field3],3).
I used the above line in critiria but returned 0 record.  Please help.  
Thanks.

I have a query that takes criteria from several combo boxes in a form.  I
used a UNION clause in the Row Source to add "<All>" to the combo boxes.  The
intent is to have the query return all records for a particular field when
<All> is selected.  That is the part I need help with ...

When i try to use NETWORKDAYS function in query it gives me an error as
undefined function.
the same function is working with excel.
How can i use this function?

I have a primary table populated by input data and update queries that
provide two numeric scores for ranking landslides.  The first score is a
hazard score, and the second is a STIP score.  I am using an SQL statement to
rank the scores according to severity.  The SQL works for ...

I am working in Access 2003 SP2 and I have to continually Compact and Repair
the database, because I do not always get the popup asking if I want to save
a changed query.  I like to open an existing query and do a “What If” change,
but don't want to have that change saved when I ...

I have a string field. This unwanted chars only appears once in a while.
EXHAUST trade123456
EXHAUST trade789012
EXHAUST trade345678

Can I create a Parameter query that uses a created combo/list box from the
database in the message that comes up when running the query?
I would like to create a query that prompts me to select an Employee's name
from a long list and then gives me ONLY data associated with the ...

My data looks like this (about 200,000 records)
26-Apr    604190000047407.00
26-Apr    604190000047407.00
26-Apr    060419083050567I

I have a singe table and 2 queries based on the same table. One query
is a Select query with some criteria. The second query is one which
uses the aggregate function Count() in the select statement. I need to
display the results of both of these queries in a report.

Hail all,
Suppose we have 2 tables (20 rows each) as follows:
Table a with Columns A, B and C and an Index
Table b with Columns A, B and C and an Index

Best wishes and thank you all for your previous assistance.
I have another situation where I would like to filter the master database
records by selecting the records by (x) number of days from the maximum date.
I reviewed the query date discussions here and come up with the ...