I am looking for a query that will return all the entries where a certain
field has its max value.
For example:
I am interested in all the values where version is at its MAX for a certain id

I have multiple Field columns for my query.  I inserted a field to add
certain other fields together.  My formula is  Lg Grower: +[8]+[8 1/2]+[9]+[9
1/2]+[10]+[10 1/2]
Table is blank.  Total is Expression. I can run this query as is but when I

One table defines budget (each one has a unqiue ID)
Another table defines employees (each one has a unique ID)
Another table defines tasks (each one has a unique ID)
Another table records budgeted time by project, task, employee

Does anyone know if it's possible to view PDF files within an Access 2000
environment?  We run a bespoke database and wish to view linked PDF's that
are stored on our server within the database window.  We keep finding
scanners that would suit our needs for collecting the images ...

*I'm not very knowledgeable with Access*
I want to input a criteria for a query with a range of results, some are all
numerical and some contain letters. How do I create a range criteria for
example "11111 to 33333" or "H12345 to H23456"? The only way i have been able

I am trying to build a query that pulls data from two tables. One table
(sales) has records (879A and 879B). the other table (errors) has records
(879). I accumualte information for both (sales entries in the errors
tables). I only need to see (879) once but I get (879, 879). I ...

I have reports that are emailed each month and usually about 50 are returned.
I need to notify the Managers of the accounts.  The manager name and emails
are stored in a [Main] table.  The email address field can contain multiple
email addresses separated by semi-colons.

Im trying to run a query based on a field which contains both the date
and time value and I want to specify criteria that will pull all
records for a given time frame regardless of date.  I have tried using
the format() function which I know brings back a string value that is

I'm working on a database that needs to consider anything between 3 pm and 3
am the same date --
e.g., December 25: inluces both December 25 3 to midnight AND December 26,
12:00 AM to 3:00 AM

DoCmd.RunSQl "UPDATE [tblCustomers] SET [LastOrderDate]=#" & Me.OrderDate &
"#"
How can I alter this query to include critera to only update a single
record?

using access 2003 on a win xp computer.  i have set up an append query to
append 2 fields from table root_SERV_CALL to 2 fields in Table1.
the field names in root_SERV_CALL are MODEL and SERIAL.  i want to append
this data to Table1 using field names Item_ID and Serial_ID.

I am trying to run an update query and I keep getting the "Type Mismatch in
expression" error message. I have gone through and double checked that all of
the fields in both tables have the same data type. The only thing I can think
of is that [Activity Log].[Activity #] is a text ...

I am using an Access table to track sports schedules and games results. I
have created queries that total the wins for each team, another that totals
the losses and another for ties. I would like to bring these queries together
to get what amounts to the league standings. Really ...

I want to write a statement that goes something like if [smrhcc] is not null
then " ", if [smrhcc] is between 110 and 160, then pass, else fail.  Below is
what I have written so far, why is it passing everything except the null
values in which it leaves blank?  Can someone please ...

I have a table with 4 fields as follow:
id        name     Country    Town
1          R            NY           NY
2          T            KZ           K1