I have a field titled Subject that will have a value CROps ID# in it.  
Immediately following this value there will be numbers.  Sometime 3 digits,
sometime 4 or 5.... then a space and the rest of the field.
How can I make this statement more dynamic so it will pull back just the

I have mutliple information in my columns for Access 2003.
Here is an example of what I have
Report #     Worksheet Location     Text
3055                    A103                  XYZ COmpnay

I am a novice wrt database design and desperately need help.
I have a table containing all things of type X, and another table containing
things of type R.  Each R needs to refer to a subset of X, and there are many
Rs and many Xs.  For example R1 needs to be associated with X3, ...

Need some assistance with a Make Table Query.
I have two tables that I want to combine data in and create another
table. Here is the simplified structure:
Table 1

    Got a question on SQL to ask:
Say I have an Access database containing a table with the following fields
and records:
Model     Serial

While working on a pre-existing database. Everything seemed to be working
fine until recently results are reflecting duplicate records.
Even my most basic queries return duplicate records which are directly
related to the # of sub-records related to the employee found in the ORG

I have tried IIf is null, NZ and several other functions.  I still get #error
in the results of my query.  Any ideas?
MgrLvl: IIf([OrgSupeIndexCCode]![LinkSupe] Is
Null,"E",IIf(Right([OrgSupeIndexCCode]![LinkSupe],5)>60000,"S",IIf(Right([OrgSupeIndexCCode]![LinkSupe],5) Between 1 ...

What is best way to create a variable that depends on five different fields
and is defined by multiple rules. This is similar to  CASE or ELSE IF
statements  in Excel.
Something like:

I'm volunteering for a nonprofit. They want to do this.
Got a db with the following fields:
Fname Lname SpouseFname SpouseLname
I want to create a query that returns the follow:  If the SpouseLname =

I have looked at my SQL and changed the bracketing but now it says there is
a syntax error in the parameter clause:
PARAMETERS >=[forms]![reports form]![DateFrom] And <=[forms]![reports
form]![DateTo] DateTime;

I have a DB with 5 tbl that all have like keys but different data. I need to
be able to search the 5 tbls and return to the user all the find condition
and allow them to select the one they want by dblclick. I want to add a field
on the fly as I build the search query to id what ...

When I export a query to Excel and print it from Excel, the query title from
Access prints at the top.  How to I delete it or change it?
Thanks,
Pat

I need to count the number of like responses for multiple fields.
I have two tables.  One with questions and one with personal data.  They are
joined by ptid.
I created a report which is grouped by Location. I now need to count the

I am not sure what this is called, but here is what i am trying to do. I
have a table with a column of salespeople names with there relative sales $
figures in the second column. I need to be able to calculate how many people
achieved the top 80% of sales, next 15% of sales and ...

I have a table containing wait times, and want to exclude the top and bottom
5% since I think they will contain the exceptions. There are a number of
possible groupings and I want to be able to select two of these at a time, eg
group by salesperson and urgency, or by urgency and ...