Ok I'm trying to create a query which will be the basis for a report.  Now
the query results will be determined by selections made by the user on a form
called frmLists.  The form will have up to five separate list boxes, but
we'll work with two for this discussion:

When I do sorting in Access 2002 I get the following results:
GAB
GAC
GAD

I have 2 tables and 1 query:
tblPersonalInfo containing: dtmHiredDate for Employees (a for Bill, b for
Sam, c for Tom)
tblJobPromotions containing: dtmPromoDate for Employees (d for Bill, e for

Hi I am a beginner in Access just 1week since I learnt it
I have a Table with Name and TotalSalary there are 500 records in this table
I want to build a query which will show me Top 20 salaries
What formula should I type in the Criteria cell below TotalSalary in design

I have tblIssIn that has records of IssInID(auto#),LocID, StartDate and
EndDate.
I need to have a daily count of students in ISS as well as a count for the
next 14 days as well.

Whenever I try to include the restriction WITH COMP to a field table in MS
Access 2000, it raises a 3290 Error indicating an error syntax at CREATE
TABLE query.
And my query is as simple as follows:

Hello.  Thanks for helping.
I would like to create a query that will sum up expenses for various
categories within a date range.  I have created the query that sums
the amounts, but I want it to use a high end of "Date()" or "Today()"

i have a table called "t_daily_reject". i want use this table to make a
query. i will select three field from this table, that is "kind_of_defect",
"qty" and "date". "date" i will change to month format. then i want to
calculate the percentage for each kind of defect which by ...

I've been given the task of designing a database of employees in Access 2003
and am very much learning as I go. What I want to do is have a button or drop
down box in a form which the user can type an employees name into, or select
one from a list, which will then take them to ...