I just had to fix a query my boss was writing. I guessed the answer
correctly, but I really don't know why it is so.  There were two query items
with criteria. One had letters like ACR, BLP, etc. and the others were code
numbers.

This query gives me the who has had action between a given date in a given
[Situation] but what I really need is all the employees names having data in
the "situation" or not having data.   SELECT Employees.[Last Name],
Employees.[First Name], Count(EmployeeProfile.Situation) AS ...

Is it possible to pass an InputBox value to a query?
1) as Criteria?
and/or
2) as the info to Update in the the Update line or an update query

I have a memo field named "CommentRaw".  Examples of memo data:
EXAMPLE1
Can keep strobel construction.  But o/s filler change to EVA diecut, last
has minor revision on lateral toe area to improve fit. Need remake sample.  

Searching the usergroups, I found code that I think might work, but I
wanted to explain exactly what I want to do before I start messing
with the code.
I have addresses that need to be standardized. I have a table of typos

I created a form where the user will type in a ID number.  I want to pass
this ID number into my pass through query to bring back records only
associated with this ID.   I tried the following:
ID = Forms!Form1!txtID.value

Good morning,
I have a field that lists pages as follows:
1
2

Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
set? Thanks.
Nick

Good morning,
I have a table with a field that contains the following:
PAGE_03   
PAGE_03A   

I have an Inventory table and the fields I am dealing with are PartNo, Desc,
and ItemStatus.   ItemStatus 1 = active and 2 = Discontinued.  Running a
query for all parts with a Discontinued status is easy.  The problem is I
need to add "xxx" to the front of the Description field ...

I have a date range that I would like to archive with in the database. I
currently run the select query,  print the data range and then go to the
table and highlight the data in the table to be  deleted . How is it possible
to create a query to move the requested data range ...

I have couples of players have many schedules and home address.  I'm
trying to group one line with many schedules.
For example:
I ran the query and it look like this:

Everything is working except when I query a field and the desired record's
field is blank.  I get nothing.  If I put something in that field and then
query that field for what I put in (I'm querying a couple of fields) then it
works. I assume it has something to do with what a ...

I am thinking I am missing something very elementary, but regardless I'll ask.
I have a form which when a user runs a query specific based upon their user
id  via a command button a list of tasks appear where the Completed field is
0 (ie not compelte)  

I have a column in my table that contains case ID data. There are about one
thousand case id's. I'd like to query records that correspond to 53 Case
Id's. I've identified. Do I place the 53 directly into the query  under
criteria or do i need to create some kind of function?