I have a field which has the following structure:
A/B/C
I need "B" but it can be any length (for the sake of argument). thanks

I have two numeric fields that I've concantenated in a query.  This is
changing the format to text.  I'm concantenating them, because that is how
they are organized as a primary key in another table.   When I then try to
join the information in a query... it can't because the ...

I need some assistance with the syntax  so that I can use the following SQL
in a String variable  say” mycount” the returned data would be a number
SELECT RED.GreenID, Max(RED.LV_SV_Total) AS MaxOfLV_SV_Total
FROM (Black INNER JOIN Green ON Black.BlackID=Green.BlackId) INNER JOIN ...

I NEED ASSISTANCE IN CREATING A MULTIPLE FIELD SEARCH BOX, I HAVE A
SCREEN SHOT BUT I COULDN'T FIND A WAY TO INCLUDE IT IN THIS MESSAGE.
I HAVE BEEN BATTLING WITH THIS PROBLEM FOR WEEKS.
THE SEARCH BOX WAS CREATED IN FOXPRO, I'M TRYING TO CREATE A SIMILAR

I'm used to the concept of creating relationships between tables, generally
one to many; then whenever I have created queries the necessary relationships
have been there, or I have just been able to link the primary and foreign key
fields.  After moving jobs I have recently come ...

I need assistance in creating a multiple field search box, i have a
screen shot but i couldn't find a way to include it in this message.
I have been battling with this problem for weeks.
the search box was created in foxpro, i'm trying to create a similar

Hi. I am a novice at Access. I had a Access databse created in 2000 version.
Last week I converted it to 2002/3 version using the auto convert feature.
Now I find all teh queries and forms picking up the system date using =Date()
comes back with #Name?    Creating a new form ...

I need to remove an apostrophe from the beginning of each entry in a field.  
The entries vary, ie:
'6788993
'103-5597

Recently the table has been delete some records by mistakes.  Now, I have a
backup of about one-week old table and the latest table with some deleted
records.  I would like to merge these two tables by importing the  latest
update records and new records to the old table.  Can ...

I have 2 tables that I have linked in a query by stock.  I have then created
5 columns by Exchange where the stock is traded (Table 1) and at by looking
up who trades it (Table 2).  I used if statements to get the results (if a
stock trades here, show me the trader).  All works ...

Hi,i am a new user to access 2007.i have a select Query with partial name
input.The criteria goes like this-Like * & [Enter a Part Number] & *
Intially,everything was fine.But whenever i am entering data to my
database.and i tried to use the query,it always prompt me twice.I ...

I have a form whose fields are linked to an underlying table of
constellations and their variable stars.  When the form opens it is initially
linked to the entire table-- all the stars in all the constellations.  On the
form, I create a SQL query by searching on a single ...

I am using a checkbox to seed a query.  I use a Client's form that includes a
checkbox named "Seed".  I check the "Seed" box to choose out clients that
will go into a ClientsChosen query.  From there I can work with that
particular group of Clients for the time being.  When I'm ...

I link to a table in an Oracle database to run queries. There is a table that
records every application an employee submits for a job, so a single employee
could have multiple applications. The table has a field called ProfileSeq
which sequencially numbers each employees ...

Back again for more punishment...
I have my database set and am building queries to generate some totals.
I have three tables which are related,
[Rep07] contains all report data, is related to [IndicentResponders] by