I have a very basic table in a database that that gives me the Item number,
The Store Number and The quantity sold of that item in each store. I am
trying to do a query that will tell me how many stores sold less than 24
items. Another column that says between 25 and 48 items. ...

I have a query that should return 160 records.  It returns 28.  An INNER
join to user_3 produces the same result as a LEFT join to user_3,which
is to select the record, ONLY if there is a matching record in BOTH
tables.  If I remove user_3, I get my 160 records.  I was under the

I have two fields in each record, Start Time and Stop Time.  I want to
calculate the time between the Start Time of the current record and the Stop
Time of the previous record.  I am using a query to gather the raw data.  How
do I do this?

I need to add a new field in a new table based on concatenating two existing
fields. I don't want to use an update table as this process will be run on a
weekly basis and is included in a macro.
What would the syntax be to add a new field in the design view of a make

How do I search a memo field as a partial string as defined by a use
entered on a form using a query?
What I mean...
- I have a form (frmReport).

I am trying to add different types of criterias in a make table query. The
problem is that  I could not manage to enter a null parameter value (At that
time I want to get all data in the field). for example in the  state part,
there are three different  name "chicago", "NY" ,"NJ" ...

I must output a line of text "ASDF" and then on the next line output the
table and all this goes into a single ASCII text file.  This must also be
done with a single button click on the menu and not using the wizard.  
Suggestions on how to go about this?

I set up a crosstab query using the Query -> Parameters to define the filter
on my query.  When the query is run, it only returns one record (but I know
that more than one record should show up).  If more than one record meets the
parameter criteria, how do I get all records to ...

I have run-time installed in my user's local hard drives - I have 20+ users
performing data input and editing - how can I set it up so an individual
users input can be ID'd.  I would like to do something like have a field in
my source table on the back-end called "LastModBy" with ...

I am trying to create a query that I think is a little above my head...  I
have a form that I have created with close to 10 combo boxes on it that pulls
information from one specific query.  I want the user to choose the
parameters that he/she wants from the form (using all or ...

I'm working with an Access query that sorts on a) Person ID, and then b)
within each Person ID, on Date of Event.  I'd like to pull out the following
records:  For each Person ID, I'd like the record with the earliest Date of
Event.  Is there a way to do this in a query?

I have a query that sorts Person IDs, and within each Person ID, sorts Event
Dates.  I'd like to have the query find the first Event Date for each Person
ID and return those records only.  Is there a way to do this?  Thanks.

In my query I get several values for my EVENT_CODE field.  I am only looking
to find the "R" code and the null codes.  For the "R" codes I would like to
show a "Y" for yes, and for the null codes I would like to show a "N" for no.
Right now I have this in 2 different columns, ...

I would like to use a count from a select query as a test in an if statement.
The query has an inner join and uses a variable previously defined in the
'having' portion.  How can I assign a value to a variable based on the count
from the query?  The code below is the relevant ...

I have the following query:-
Trim([Address1] & ", " & [Address2] & ", " & [Address3] & ", " & [County] &
", " & [Country] & ", " & [PostCode])
However, if any of the fields are blank how can i stop getting two commas