Hi, I'm new at this, so I'll try and explain what I'm trying to do here,
maybel I"m going down the wrong road.  In my instance a member equals a
customer.  Just so you know.
I built a query which is pulling member history data for members with bad

I know you normally need 2 queries to do this, but does anyone have any
suggestions on how to do this in code.  Perhaps create a table on the fly and
append data to it??

I have the following query setup to count how many of each goal.
SELECT tblGoals.Goal, Count(*) AS TotalCount,
Count(IIf(tblGoals.Goal="Relationship",0)) AS RelationshipGoalCount,
Count(IIf(tblGoals.Goal="Travel",1)) AS TravelGoalCount,

Hi to All,
For: myName = “Jim”
I am storing  this SQL String:
Type A

I am trying to find the names of people who gave in honor or memory of
someone since 1998.  I come up with 1217 but some of these people have given
every year so they appear in the query more than once.  I only want to send
them a letter once for the last time they have donated.  ...

Im a little stuck trying to do a datediff query.
i have two fields "request date" and "done date", and i need the query to
show all records which have a difference of 10 days or more. i.e. if it has
taken ten days or more from the date of request to the date of being done.

I'm trying to figure out the criteria where the results will be those records
with no value in the End_Init, End_Date, and End_Time fields. Several
attempts are not yielding the correct results.
User enters start time and date, etc. when a job is kicked off. Completion

I have one table that holds all information, which is linked to external
software. I would like to use Access as a query and report generating tool.
Is there a way to build an simple application within access that allows me
to pick out of a drop down list what I want included in a ...

Greetings!  Could use a little orientation.
Given a table Events:
Event    SomeDate
A          4/1/07

Greetings again!  Is there a simple way using standard Access mechanisms to
clear existing records out of a table before appending new ones to it with a
one-step (to the user) operation?  Am familiar with VBA but would prefer a
non-programming solution if available.  This would seem ...

Greetings!  Have an interesting challenge.  I'm using a crosstab query to
count five categories with two states each -   General structure is counts
for Case1.A, Case1.B, Case2.A, ...Case5.B.  Sometimes a category will have
no counts in one or both states.  When that happens, either ...

What Function or ??? can I use to remove blank spaces within a string?  
Example:  FS 8406 PT 1 to read FS8406PT1.  Anyone with any ideas.
thanks in advacnce

Hi.  I'd appreciate any help with this problem.  I've read threads on this
before, but couldn't get it right.  I want to calculate the difference
between dates in a single field to help calculate trap*nights.
Here's the table structure in the table called tblADateID:

I need to update a temp table (tblBOM) with a summed quantity from a query
(WOShortagesWithSOSum).  Here's what I have so far that is giving me error
"not updatable query ..."
The query WOShortagesWithSOSum is a summarized query:

I need to count the total number of records that were found in a sub-query
(Access 2002). How can I do that please? This isn't in VBA, but is in an
actual Query. Any insight would be most appreciated.
Thanks!