The sales department keeps changing regions for which they are responsible.
This makes quarterly reports difficult because the area they cover is always
changing size. Currently I have RegionIDs 1-17 that represent areas of the
country and I use a crosstab query to get the ...

I'd like to remove the first 10 characters of field1 and update an empty
field (field2) with the result.
Thanks for your help,
Ellen

I built a DB with a query call Full-Time Query.  This query shows all clients
who are working full-time.  Now, just for testing purposes, I removed the
"Yes" from the criteria cell to leave all criteria cells blank.  It should
then show all records in my DB, Right?  But it ...

I have a table with one text field
Text
JB10/08/07-1
JB10/05/07-1

Hello,
This seems to be one of those issues I feel like I am just missing.  I have a
report that runs off of a query.  When the report is called directly from the
report objects list, runs just fine.  

Hello -
I'm back and still learning how to use Access.
I'm trying to find a function that can do the following:
If I find 1 in field A and 2 in field B, then please return 3. If not, then

Hoping to get some help modifying the following query that I have...
TABLE: NAMES
ID, FirstName, LastName
TABLE: EMAILS

I want to list all patients (from my patients table) that are <> to  query1.  
When I enter Query1 in the criteria access does not recognize query1.  How
can I do this.
This is what I did, in query2 I entered <>[query1]![patient key] in the

I need some SQL advice...
I'm writing an application that will track passwords for the
organization I work with. It uses a field HistoryID as an ID for the
password. And generation, as a way to track old passwords. Each time a

I need  help on this query to fix the ambiguous outer join?  I think I know
what the problem is but I don't know how to fix it.  I have a self-join where
I want a parentNodeName showing when a node was split.  The tableNode_1  is
the self-join.  I added the tblNodeName_1 because ...

I use a criteria in a query colum to filter some data.
My combobox there are a option to chose. Based in the opition that I chose,
the query execute the filter.
But, I would like that there are the option "All" in my combobox, like the

The question I have may have a simpler than I think. I have a form and
subform. The form contains employee info and the subform contains working
hours.
How can I find out which employees don't have entered records for a certain

hey guys,
I have created graphs based on a database.. the figures entered into
the database are dates shown as 07/08/07 for example.
I have managed to create these graphs using queries but the y axis

I'm new to Access.
I have a function in excel that I want to do in access below:
=IF(ISNUMBER(SEARCH("v",A2)),"OK", "Not OK")
It's called "Check if part of a cell matches specific text".

I am building a query using the dateserial function to identify store open
dates that are currently stored in an integer YYYYMMDD format.  I can convert
that to a date using DateSerial(left(4),Mid(5,2),Right(2)).  Next I add
criteria to the query of >=date()-365 to get those ...