Recently purchased a new PC with Access 2003 - had numerous problems running
Access 97 db's, so installed 97 - had numerous problems then, then researched
and trouble shooted - finally have both versions available, can open a 97 db
in 97 version just fine.  Can create a 2003 db ...

I want build a SQL query to generate statistical result from
table(students) in MS Access as below:
Student#          City        Amount
001                toronto          1000

Is it possible to query a text field in a table?  
I'd like to determine if Column A is < Column B.
Thanks.

I have a table that contains over 300,000 records.  The records contain a
Longitude and Latitude field to define a precise and unique location.
The problem is that apparently there are a few record that have identical
field values for these two fields, (i.e. they share exactly the ...

I have created a query (qryMO_ProductionDaily) that uses the following
statement to choose data according to date:
Between [Forms]![frmDatesAndReportTitles]![txtDatePeriodStart] And
[Forms]![frmDatesAndReportTitles]![txtDatePeriodEnd]

Hi;
Just spent the last 35 minutes searching Microsoft tech support for:
Append Query.
Using Acc2000.

I have a combobox "A" that  uses whatever I select in  cbo "B" as the WHERE
clause of cbo "A"'s query.  It works great if I select an item from cbo "A"'s
drop down list, But how can I set it up so if I don't select an item or I add
an "ALL"  item, cbo "A" query will select all ...

When I try to build a pass-through query I set the ODBC Connect string to
ODBC; DSN-AS400 but I always receive an ODBC-call error when I try to run the
query.  I don't know how to correct this. I want to be able to run
pass-through queries.

I would like to create a button on a form which runs a query. This query
needs to be based upon a field from a form that the button is to be on, so
that when the query runs, only records relating to this one field are shown.

I have a query which contains many data. I want to ask me base a criteria
what data to show me. For example ask the user to enter the contact name in
order to show the other data. But this is difficult because there are a lot
of names and you have to remember it exactly how is ...

Folks
I'm having a rather strange problem with a query to an Access file
from Excel.
My query looks like

Now i hava a urgent problem in access query.
I have 2 databases that carry 2 different years records, i would like to
write a query for searching cross database data, how can i do that??

i have a table which contains a list of dates.  I can use the Max function
to obtain the most recent date, but I also need to obtain the second most
recent date - is this possible please?
Thanks

Is it possible to build a query in which the criteria is a list box?  I have
a list of workers and I want to build a query that will prompt me with the
list.
Thanks ... Marco

    I'm using an Access 2000 database with at least a dozen error tables my
boss created.  They all start with Tutume_err_  They all have three fields in
common: patient number, facility and log book number.  I'm trying to create
one list of the records that I need to verify ...