I have a field that includes the full name of a customer. Unfortunately, I
never set up separate firstname and lastname fields.  Is there some way I can
pull out the firstname, or separate the full name into two firstname and
lastname fields?

I have been working on a database that matches participant demographic
information to the studies they have participated in.
Each study and participant has unique autonumber IDs and I have combined
them both in a separate table with dates.

Thank you for looking at my question.  
I have a table that is full of information about phones and their
locations...we can call it a service file.  The service file will contain
information such as the PhoneID, location, model, start of service, warranty

I am new to this so be easy on me, please.
I have linked to an ODBC table, and a few excel sheets.  When I go to query
I want to filter data by a collum that has a date, if it has a date I don't
want to show that data when I export the report - this works fine with an "if

I have 22011 records in table "tblProcChargCounty " when I create a query
between this table and tblFacility table, I have 22011 records, but I try to
add "tblEquipType" table I get bigger number. Now table tblEquipType &
tblProcChargCounty have one-to-Many relationship with ...

I think I can do this in one query but I am not sure the verbage.  I have the
following scenario:
Lname     FName     DOS               Provider1              Provider2
Smith      John         20081212       Jones                   Williams

Thank you all for looking.  Basically I have a form with a pre-populated
combo box and a command button.  Lets say the combo box values are All,
Option1, Option2 and Option3.  When the command button is clicked it will run
a select query with whatever option is chosen as the ...

I have several games that are on EXCEL that were working properly. Now they
will not open or load. What happened and how do I fix them?

I was using the following InStr() to extract data from a field. The string I
am extracting begins with “!TCANC” and ends with an ASCII Null.
I have now recognized that there is a variant that begins with “!OCANC”.
How would I modify my InStr to allow for the variant?

I posted yesterday but did a poor job of explaining my task. I'm trying
again. My apologies. Thank you all who tried to help.
I need a query that will do the following.
Return only the records that satisfies these 2 criteria.

Given the following table tblEvents,
event  user  startdate                    enddate                        
elapsed            work
0156  Pam  10/02/200710:15    20/02/2007 15:44    10d 5h 29m     ???????

I need to generate a list of all the Project Number in a table that do not
appear in another table  How would the SQL synthax go?
Table 1
Name: Parameters

I have a start date for a client stored in a table. Each client needs
to be reviewed every 90 days (do not care about working days or
holidays -- just a straight 90 days). I would like  a tickler report
that will show me which clients are to be reviewed in the 90 day

Can an IF function be used in a Query?  I set up the IF function below to use
in an Excel worksheet to list the Banner name by searching for a name within
the store name field.  My plan was to export the query into an Excel sheet,
but it exceeds the maximum number of lines ...

I need some help with Access 2003 queries.  Please keep in mind that I
am NOT a programmer.
I have a table filled with gender (male or female), race (black,
white, asian, etc), and ethnicity (hispanic, not hispanic, unknown).