Each day I must review a multi-office list of files identified by "Claim ID".
I append these daily lists into one table, then use a query to pull the
files by date range and a few other criteria which target files just for my
specific office.   Due to internal procedures, some ...

I'm getting this weird error. Does anyone know what this is?
Runtime Error 3188. Could not update; currenlty locked by another session on
this machine.
This is situation in which this happens:

I am new to access i have a database and need to generate reports based
i=on that, eg. 1 Volume of work in to process.
2) volume of work completed, 3) book to bill ratio 1/(2+3) and so on please
help i can provide dummy database .

Can Use the the Today function with a Perameters Query.  Something like...
between [ Enter Start Date ] and Today ?
Thanks for the input and have a great day.

I'm really stuck. Within my database I have two related tables. I would like
to search within 6 fields of one table and pull back any hits in terms of a
product stored in a related table. I've tried this and it only seems to give
back data relating from the hits in the first ...

I work with a large amount of data in Microsoft Access, where a client could
attend a hundred appointments all on different dates/times.  Using a query,
I can obtain their first appointment and last appointment easily enough.
But I really want to find an easy way to obtain a ...

Thank you for using time on my issue.
I have created a query "quyRoundPrices" that give me the following result
Year    Round   FirstP  SecondP    Long      One            Two
2006       1        Peter     Will          Will        Peter

I have a table (with 1000 records) which I use to append data to.  It
has a auto number field contains number from 1 to 1000.  After I
deleted the 1000 records from the table and rerun the append query,
the auto number is not started at 1001.  How can I have it started

Is there a way to do something like an if else so that I can run one of two
selects based on a form field? Something like
IF form!fiield = true
selct ....

Is this possible:
I have 2 tables:  Schedule and Monday
Monday has the fields called
Monday (date field and primary key)

I have a very simple query that has two parameters - [Enter Start
Date] and [Enter End Date].
The End Date should always be 90 days from the Start Date.  I would
like to just have the [Enter Start Date] parameter and have Access

I have a query that shows the visits of my contacts. I would like to filter
it so that only one visit per contactID shows and is the most recent visit.
right now all the visits of each contact show eg Contactid 1970 visitdate
02/14/2006

Is there an access function that performs the same action as the TRUNC
function in excel?  
The round function doesn't work for my needs. Don't need to round up, just
lose the decimals.

Wonder if someone can help me please.
I have a date and time field which shows the dates and times that files were
received onto a server at work. This is in the format of DD/MM/YYYY HH:MM and
comes in the form of a .csv file which I then import into the database.

I hope I can explain this so it makes sense....
I made a duplicate query with the wizard which is fine BUT I'd like to have
it give me only the records that duplicate since a certain date. My fields
are: