Hey there,
I've set up a database consisting of four tables. I run a query which
calculates a total for the item (unit price * quantity). Is it
possible to calculate the final total of all this for a report?

I have the following crosstab query:
TRANSFORM Nz(Sum(MSF07.[Share Total]),0) AS [SumOfShare Total]
SELECT MSF07.Aircraft, Sum(MSF07.[Share Total]) AS [Total Of Share
Total]

I have a table of people who have signed up for an event.  In a second
table, I have a list of the people who signed up but did not participate.  
What I want to do is delete the nonparticipants from the signup table so I
have less records to deal with.

I am so hoping someone can help me with something that should be very very
easy!
I am trying to calculate some dates but, need to find the business day month
end dates in order to do the calculations.  

I've got a left join query that I need a 0 to be included in the a specific
column that would normally be <NULL> in the left join.
I'm trying to write the query using SELECT ..., ISNULL(<COLUMN>, 0), but I
get a "Wrong number of arguments used with function in query expression

I have a report that I get a total in several field. See below example of the
fields:
    Field-1
$123.00

I seem to have a lot of problems with writing queries that generate the error:
You tried to execute a query that does not include the specified expression
'[xxx]' as part of an aggregate function.
Neither of the Access classes I took explained what triggers this type of