I would like someone to please help me with this please.  I have to count and
identify groups by an id that consists of 8 characters.  The characters can
consist of a combination of letters and numbers.  How I need to group is the
id can be ???????A.  However, I need to eliminate ...

I currently have run a series of queries that basically take a final item and
break it down by its components over and over again.. i end up with columns
that look like this
Parent Part    Volume   Component1   Volume    Component2 Volume   Etc

I have a query which will make a table which will then be used in a form
for some data entry/manipulation.  I want to put a couple of Yes/No
fields in that table, filled with "no."
I can set the property of the field in the design grid to yes/no.

I have a Query that has an Exp Date. I would like to have it pull overdue
items, for example if there was a date of 1/31/2007 I would like to see if it
was equal to or greater than the date or over due period....
Thanks,

My quandry at the moment is a method to open a recordset from an
external file (MDB) so that the RS can be parsed and various
conditional tests checked along the way as WELL AS field updates when
various conditions are met.

I want to be able to see which customers bought in the course of ten
consecutive days, where the BeginDate can be whatever date and which can vary
for each customer,  how many products b, e, f one bought out of a range of
products a, b, c, d, e, f, g.

How could I count the number of previous days a record is present
until I hit a null?
For instance, if I wanted to know how many previous days in a row
someone placed an order...

I have a totals query with the following:
Date, Max
Amount, Sum
Type, Where (IIf([Forms]![frmLookup]![checkbox]=1,[Type],[Type]<>3)

I work for a small homeless shelter.  I have a table called
"Services"
that contains records with a ServiceID, GuestID, ServiceDate, and
ServiceType. Such as:

I have a table called Calls table and a table called calls table completed.  
I have a unmatched query to find the records in Call Table that do not have a
record in the calls completed table.  Those that do not have a record in the
calls complete table i want to be able to delete ...

I've read other feeds on this subject and I'm unable to fix my problem.  
I've developed a query with a field that concatenates multiple fields,
excludes empty strings with Null and introduces carriage returns.  
Contatenation and carriage returns work, but my Null doesn't (I want ...

The below query works just fine with my sample dataset, though with my live
dataset (100k records) it takes far to long to crunch. I was curious if
anyone might be able to offer insight into a way to re-write the below query
to improve efficiency? Thank you for your time and ...

I have a massive amount of queries that I need to view the SQL statements
for. Instead opening each one separately, I'd like to download each query and
just its SQL statements onto one view (spreadsheet, word doc, etc).....

My query results in a series of records. One of the fields contains a
date.
I'm only interested in 1 record, namely the one corresponding to the
latest date.

I have a user who is trying to append a table to another table first table is
never available in the selection. She has tried multiple databases and always
the first table is missing.
Another user tried on a different machine and had no issues. The user that