Hi. A criteria is not working on my query.  
I have a query that loads somes queries. In one, I have the department code
field/column.
so, in this final qury appears me all department codes.

I have created a template used as a customer profile.  When typing data in
the form, the "saved words" move.
EX:  Name:  Jane Doe  Address: 111 Main.  In this example, when typing Jane
Doe, the saved word "address" moves when typing in data.

I have the following SQL code for a query that joins 3 tables so I could
enter data.
SELECT tblInmGangData.DOCNumber, inmtinfo.IN_NAME, tblInmGangData.NName,
tblInmGangData.Rank, inmtinfo.IN_OFFENSE, inmtinfo.IN_CMTCNTY,

Okay, I have one field that contains either an assigned project # or text
indicating Prorate. I need to separate out the prorated items which isn't the
problem.
I've used CO:Left(DAC Name],1) to pull the first character of the field.

I have a database that I can create a query on, to bring up certain details
that I need to look at, without all the fluff.
When i run the query, I need to create either a macro, or a query, that will
show me a search box, so that I can search forspecific postcodes in my query.

I have a userform with a 2 option button's in a Groupbox. I would like to use
these as the criteria of a query if possiable. The option buttons value's are
1 and 2.
So I thought I could say............In the Criteria of TENDER_TYPE

I asked a question earlier today and was told to use select case to address
my need.  I ended up doing so, but there is a small issue I didn't cover.  My
original question concerned figuring commissions for sales people.  I am
inserting the MVP's suggested code--it worked fine; ...

I have a table with data field year, state and value.  I'm trying to run a
query for the table with criteria: If user select "report1" in the report
list, then exclude TAS from the data set, otherwise, include all data for all
other selection.  The following is the criteria I've ...

1. How would you make a query that allows users to enter a letter or a few
letters and selects all Customers Last Name that have those letters ANYWHERE
in the name?  
2.  How would you make a query that displays dates like this May 2-10 and

I am trying to display limited information based on a part # of an item.  How
can I set up a query to show rows associated to specific part #'s, when those
part #'s - and how many part #'s - changes each time I run the query?

I'm trying to create a select query which have field date.
Now I want have a field which return the date value to
week format.How to create it.I want the week change
every monday at 7.30 am.How to make access achieve

I am trying to determine the most efficient method for querying data on a
backend SQL Server.  Most of the queries require a parameter (or two)  to be
passed and are all called from the VB code within a Form.
Is it:

I am creating a query to update my SQL server tables from a custom
ODBC driver that accesses my financial software.  Basically I do a SQL
Pass Through query to the ODBC Driver which returns the updated
results.  I have saved this query and it runs successfully every

I have a dropdown box with 3 options, for example option1, option2 and option3
When the user creates a record they select the relevant id, there can be
many records for each id.
CAn anyone tell me how to create a query to count how many times that each

I have the following columns in my query empid, courseA, datecompA, courseB,
datecompB, courseC, datecompC.  What I need is an extra column that will have
an indicator Yes if any of the 2 dates(i.e., datecompA, datecompB, datecompC)
have  dates, blank if all 3 dates have dates ...