I have converted an Access 97 database to Access 2002, (file format 2000). I
have a make table query that retrieves data from on Oracle database.  I am
using a start and end date entered by the user in one of the criteria fields.
The response time in Access 2002 is about 20 ...

I need to be able to select the top 3 rankings for each product group.
I have a ranked table with prodgrpID, prodName, ranking (poor, good,
excellent..).  I also have another table that translates the ranking into a
number (1 - 5).  How do I write a query in access 2000 to show me ...

In a query - I would like to have the ContainerID field return "Other" if
"Container" is not in the field somewhere and for all else the value of
ContainerID.  The following line brings up no data when I know there is:
IIf(([Inventory].[ContainerID]) Not Like

Im trying to figure how how to return order status info.  i.e. OrderID,
CurrentStatus, CompletedDate, DeliveredDate.  i have an order table and a
statuslog table. the status log table is like this. OrderID, Status,Date. it
can log a history of differnt status's i.e. Order ...

how can i select all orders and group by their status history i.e. order
received, processing, completed BUT, if there is a duplicate status, i only
want it to show the most current status. i have an order table, a statuslog
table. this is ms access.  i have pasted  some sql i ...

Windows XP Professional
Office 2000
I have a table in Access with a datetime field.  I need to only show
those records where (datetime >= yesterday's date at 9 pm).  Does anyone

Here's the situation:  I am creating a maintenance/activity log for the a lab
where a user will be able to enter a part name and date installed among other
fields (the rest are irrelevant to this question).  I want to create a query
where the user can type in a date and the ...

On a weekly basis, I need to calculate average weekly sales over the past 13
weeks.  Is it possible to do this type of calculation in Access 2003?  If so,
how?
Thanks!

I have a table that is similar to the one below
FieldA       FieldB
AAA
AAB

hi, im creating a contact list database for a company,
when i add a new user, i need an update query to update the data to two tables
how do i set up the update query?

I have a problem getting the oldest date from a query that returns
results according to the date criteria entered by a user. Here is my
query:
SELECT T1.Key, T1.Age, Min(T1.DatVisit) AS MinOfDatVisit, T1.DatVisit

I am trying to set up an expression in a report that will show the number of
days elapsed during the current year for an item whose date field might
actually be from a previous year. For instance, the date field which I have
named orig, might actually be 01/01/04. In that case, I ...

I am creating a maintenance log which will show different parts and its date
installed.  It is possible that the same part is changed so the log table
would have the same part name more than one time with different installation
dates.  I want to create a query which will enable ...

I have a tables that includes the fields Mins. I'm using this in a crosstab
query but I want it show the minutes in Hours and Minutes. I wrote a function
that would convert them but this doesn't work in the Crosstab because the it
won't Sum them (if that makes sense).