Combine Select Query with Crosstab

[MFJ]

hi,
I hope someone could help me with a certain problem:

I have a table called SALES

Date Company Sale
-----------------------
1 A 2.00
2 B 3.00
3 A 2.00

Note 1.
I did a crosstab query based on this table with the column headings of A and B with Sale as the sum. (Company as column Heading)

Note 2
I did a select query (Query2) from the same table to find the running sum of the sales.

How do i combine these two together because i keep having my Query2 giving error like Query2.Date is not a valid field or expression.

Ive checked the date format and the field properties of the table and queries but everything is A.O.K.

Does anyone has an answer to these solutions.. without using a convert query to table method...

Thanx in advance


[This message has been edited by MFJ (edited 05-21-2002).]

 

[Sohaila Taravati]

Refer to this posting, it might help! http://www.access-programmers.co.uk/ubb/Forum5/HTML/002940.html

Sohaila

 

[Rich]

Running sums are best done on a form or in a report. Why do you need a query?

 

[MFJ]

Yep got the thing to work...
all the problem comes from not specifying the column headings in the query properties

thanx sohaila n rich
p/s: i did the running sum in the query just to see whther it is possible to do it.. hehehe