I have a tblPersonalInfo containing information including dtmHiredDate and
strJobTitle.  I have another tblPromotions containing info including
dtmPromoDates and strPromoTitle. This table may contain duplicate
strFirstName and strLastName because of different dtmPromoDates and

I have a database that contains a table with an administration area
and a number associated with the "count" of a certain characteristic
of that area.
For use in another piece of software I need to convert the count

I need to sort a table on one field into ascending order but by capital
alphabetic not numeric order.
I.E.
Methomyl

I'm new to Access. I'm using an Access table to record compliments that our
company receives. I have a column which lists the date that each compliment
is received. I would like to run a query that just holds compliments we
received in 2006. Please could someone help me?

I need your help and expertise in this situation, please
FieldA   Estimation      Existing             tblA
            ResultA          ResultA
21       021                   021                   021

I'm sure this is easy one... I have a standard SQL Union Query:
SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Shanks Mounts]
UNION

I have a query that filters out weekends and holiday dates. This query drives
a combo box on my form. I would like the default value in this combo box to
be the next available maturity date from the filtered query. The next
available date will be driven off of a text box ...

Ok. I have a form with a text box and button,  the textbox take a text value
which represents the number of day.  I have a table and one of the columns is
named DateCreated,    I would like to take the number entered in the text box
and  subtract it from a short date in a query, and ...

I have a FirstName and LastName field.  I want to concatenate the two fields
but when I do there is no space between the first and last names which is
what I want.  Can someone help?
Thanks,

what code do I write to run a query without getting a warning ?
and I dont want to set it by the access options because then it dose not
warn me by running any  query.

Task is simple, but it appear as very though to complete.
Table:
Table1, IDRecord (may be AutoNumber)
record values:

Help…
I need to create an access database that would query Multiple Paradox
Databases
the Paradox Databases all have the same fields.

Group,
    I have been trying to make a query that will count text occurances in a
crosstab format.  For example:
Table1

Ordinarily, I would put field expression code in the
OnFormat_Detail event section. However, if it's possible
to build the expression I want directly into a query
grid pane while in grid design, I would prefer to do

Below is the SQL for a query that I have. Below the SQL is the results. What
I need to do is rank the score by each name in descending order. When the
name changes I need the rank to start at 1 again.  
Thanks in advance for your help. I am stuck.