I ran across a curious situation that someone who knew what they were
doing would probably be able to solve without even thinking about it.
I have to track some data about services delivered to our customers on
a weekly basis.  I started off with a parameter query and asked for

I'm not sure if this question should be in the query section or maybe module
coding.  I have a table (tbl_cost) that has two fields CC and Cost.  I want
to see which record's cost would equal to an amount I specify.  For example,
There are 15 records.  I'm looking for which ...

I'm still new to Access, so please bear with me.  I am trying to create a
report from a query so that I can pull information about a particular
employee.  I have a parameter query to sort by a specific date range for all
employees and one where I choose what shift I want to see, but ...

I have a .txt doc I am importing into access.  There is a dollar field that
comes over without the decimal (i.e. 45623 instead of 456.23).  The field
carries zeros if the cents are zeros.  How can I update the imported data
with the decimal in the second position from the end.  I ...

I have a query that works just fine on my computer where I have A97 installed
along with A2007. They don't like each other, and they don't play well, but
my client needs A97, so I use it. The query fails when I transfer the .mdb
over to their network and run it. Approximate ...

Is there a way (via a Query) to do the following.
I have 2 tables......samples of the structure follow:
Table 1
The fields are "1st Approver" and "2nd Approver"

I am importing records with a fixed length description field. I need to
create a field from the last word of the description(everything to the right
of the last space). The field length is 30. When I use the function below --
it appears the trim function does not seem to shorten ...

I have a table in access that lists all incidents by stores over a 2 year
period.
Question: What expression can I use in a query that would return the last
incident for each store over that period of time?

I have a query which pulls records based on >=[ENTER BEG DATE] criteria.
I have changed to read ">=DateValue([ENTER BEG DATE])" but the results are
still not correct.
When entering 4/1/07 it gives me all data from 4/2/07 on.

I am trying to set up a data base where it tells me who has a birthday next
month.  I enter the following expression that works until the next month then
I have to go in and change the - number to show the following month or it
will show 2 months ahead and skip the following ...

I'm trying to say:
IIF MEPR field is empty AND TEC field is empty, use RIGHT 4 digits of DESC
field, otherwise use TEC field.
I've used Excel code (IIF(and(isblank(mepr, etc and it doesn't work. I am

I use an update query to change data in one field after a parameter finds the
one requested record. How can I get a message box appearing, telling me that
no record was updated since no record was found using this parameter?

I have an append query that is outputting to a table that I use for mail
merge. The problem is in the table view of my query, I see the correct
information in certain fields like "City, State, Zip" in the regular format
of, say, "Elmira, NY 14905". When I go into the table that ...

I have review many of the previous posts and tried many of the solutions and
I still can't come up with one that works for me.  I am at wits end.  Please
Help me while I still have hair. ;)
My table is structured as follows:

I have one table called tblArchive where I have a department and a location
A1a, A1b, A1c, etc.  I then have a table tbllocation where I have all the
locations listed all the way to Z9z.  I want a query that lists all the
locations from tbllocation that are empty but also all the ...