Hello, I posted a few days ago and received help but I’m still having a
problem with the query I’m trying to run. I’m new to Access and if anyone
could help out I would really appreciate it. Please, any ideas or suggestions
would really help. Thanks.

I am going insane with this - i have built a database for a garage which
tracks customer mots - (date passed) - (date remind due) etc. i need to do a
query to search on (date remind due)- which will open from switchboard which
will then open a box so i can just put a month in (ie ...

I have a tour bus reservation system and have an interesting challenge.  I
need to build a crosstab query to show how many buses of each type have been
reserved for each day in the future.
The reservation system includes these fields needed for the crosstab:

When I run a query I want to create a blank record with a message "no
previous record"
without upsetting the primary key field  and the underlying database-
ie as a place holder when there are no previous records

I have a field in a table named Author where som authors ends with a period
'.' and som do not. Ex. L. Stone. or F. Olsen
I want to put a period at the end of all authors in the table, but only one.
Can anyone help me?

Is there a way or retrieving the record ID of a record just added within the
same SQL statement or similar method
I am new to Access and in SQL Server one can use the @@Identity method
Thank you,

Here is the trick. I am using 3 queries for my report. Two of the queires
(sub) are based off the main query that holds the main parameter. As you have
guessed by now I get 3 parameters because of the nested queries. How do I run
my report with one and only one date range.

I have a between date type parameter query. How would I add error handling to
a parameter. Example: If the user puts in the wrong date. I want it to return
a msg stating...Invalid date entered.
how or where would I begin.

Wondering if anyone has some insight into my latest dilemma. I'm building a
database to handle stock quantities and location.
So I have a table, Kit_Quantities, with the fields Part_Number(key),
Project_Name(key), Location, Quantity, and Checked_Out. If a user needs to

I want to create a query that employs a dropdown to allow the user to select
information from a specific field in a specific table.  The purpose is to
avoid misspelling of the input data (the value is the name of a customer),
so I want the user to be able to choose from existing ...

why do I get just the sum with Avg([column1]+[column2]...) and how do I avoid
trunacation of my formulas?

I have a query which compares two text fields for an exact match (I thought).
I find that it finds differences in the text strings if there is a leading
space in the string, BUT not a trailing space in the string.
HELP!  I need to know whether the text fields are an exact match ...

I have a table that gets a new YTD entry once a month. Sample data:
Officer#     OfficerName     Month      YTD
100            Jane Doe         7/31/06    $6,091,022
100            Jane Doe         8/31/06    $6,091,023

Is there a way to have a subtotal at the end of a group like the SUBTOTAL
function in Excel?
Thanks

Good morning:
I am working in Access 2000, and I am trying to set up a cross tab query
that will calculate the monthly total of our product in stock.  The select
query that I have created takes information from several fields in my