I have am importing data into Access and I need to cleanup one of the fields.
The City field contains City Name, State and Zip in one field.  I only want
to keep the City Name - it is delimited with a comma.  How can I parse the
field to keep everything to the left of the comma?

I would like to take the following Query and Concentate (I believe that is
the term) the last three fields into one value and  group by the CanID field
and the order of Concentation should be by the LayerID. Anyway of doing this
in a query?

So far I have created a query where the user can enter department of
their choice to view the detail. I then created a crosstab query to
categorise the results. I created a report with a subreport (crosstab)
to show the results.

My report query includes a link to and fields from a crosstab query.  The
problem is that the field names produced by the crosstab may change from time
to time.  My solution was to place code to determine the fieldnames, modify a
string SQL statement, and run the modified ...

I already tried to tweak many of the examples of running some on this group
without success. Hopping someone will be able to help me. Here is my problem.
I created a performance query that calculates the number of days between the
Open date and close date of request (CAR). Now I ...

I have a table like so:
-----------------------------------------------------------------------------------
ID       API            PRODID                 NAME         NUM
6231   00123         2365                   SMITH         1-C

I want to create a database using Microsoft access 2003 that is relatively
straightforward; it is for a new club that I'm starting.  It is quite as
small club with only about 100 members maximum, I have searched for a
Microsoft access template, but had no success, and most ...

I'm quite good at queries, but i'm crap at agregate queries (counting) - I'm
trying to produce the simplest (i thought) list for the receptionist so she
doesn't overbook my classroom - the final list (my aim) includes just two
fields,

Hello group.  I'm sure this is an easy question but I can't figure it out.
All I want to do is the following.
 1)  Insert a record into the master table
 2) Get the value of the new PK (autonumber)

I'm joining two tables using left join and noticed that some (but not all) of
the rows from the left table were being excluded from the result set when the
join condition is not satisfied. The following SQL returns one row, as it
should:

hi,
I have the following code behind a button:
Dim strSQLArchive2 As String
strSQLArchive2 = "INSERT INTO tbl_archive " _

This is my first message
I am having a problem with forms in access
i have two combo boxes the results in the second combo boxes depends on
what is selected in the first.

i have a service table that asks for client name, client number, service
date, type of service, outcome, length of time you met with client, and case
manager. the intake table has name, age, gender, ethnicity, income, handicap,
language, citizenship, number of people in the ...

I have a table a with columns: date,symbol,action.
I want to return rows where the last action for every symbol = "Watch"
I am little confused how to go about this one.

I want to select dates within a particular range that varies each time from
my crosstab query. My query returns all the data each time regardless of what
parameters I put in.