Can someone help with the following recursive statement:
I have an employeeID, supervisorID, supervisor_last_name and
supervisor_first_name
For each employeeID how to populate supervisor_last_name and

I need to know how to take a report that is grouped by account number showing
cost detail - it shows the account number, all detail including spending,
then at the end of the group shows the sub-total -then the spending by the
next no. and a sub-total for that acct number and so on.

Using Access2000 - Trying to delete old data out of a table but it gives
above message - turned the uniquerecords to yes - then it wants to delete all
the records - not the ones I queried out.

Access 2003 - I'm trying to get a list of birthdays grouped by month.  My db
has "Clients" and "Spouses".  I create a query for each of them filtering out
null birthdays and making a simple expression to show the month.  I now want
these combined so I can get a report that shows ...

I have a database that logs issues. The crosstab query shows the volume of
issues by age (in days). Sample result looks like this:
IssueType     1   2   4   6   9   12(Days)
IssueA          4   4        2   1    1

I am trying to create a query that allocates values on a pro-rata basis.  
However the results never add up to the original value.  For instance, 85MM
is allocated across seven funds (L_Alloc).  I need to distribute 50MM at the
same proportions as the 85MM to ensure fair ...

I have two tables, one the main table "AR Details" has all invoice records
with all the dollar amount, the second table "Nameaddress" has just customer
names, customer numbers, and addresses. I join the tables and wrote a query
to pull only the records that match and only have a ...

Hi everyone, I am having quite a time trying to create a query that returns
what I am looking for. Here’s the set up
Employee Table
Skill 1

Hi, David! Hope you found this continuation post and have time to play...
I'm still loving the PrimaryFamilyMember method.  So, I think the next step
(big picture) is to be able to incorporate the FamilyBucks query, the
membership dues, and the "cashed-in" Bucks into consideration ...

I have an update query that runs fine when I go to queries and select it but
when I reference it from the form that provides the criteria, it doesn't
update the record like it should.  It should update the current record on
the form.  How can I make that happen?

I have a Query created with the Access Query designer. What I am trying to do
is the following: I have a table of 'leads', consisting of information
including a property address and an Owner ID. I have a separate 'owners'
table with detailed information for each owner (name, ...

In Access97 I need to make a crosstable query where the columnheadings
are A1, A2, A3, a1, a2, a3 which are field-values that are entered
capssensitive. A1 <> a1 etc.
In the properties of the crosstablequery at the columnheader I specify

Hello all :)
I have read thru almost ALL of these postings and I can't find my answer
though many have been helpful anyway.  Thank you.
I am developing one query from another.  The first query has parameters - I

I have a parameter query "Cost by Style" that works wonderfully [Enter
Style].....
I have another query I have based off of the one above "Total Cost by Piece"
(because within each style there are several pieces) - but I do not want to

I have a table with 181 fields and I have the following select query:
"Select * from Table1 where [Field1]=[Please enter 1: ] and [Field2]=[Please
enter 2];"
This query works fine for sometime and then it gives the following error