By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,028 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,028 IT Pros & Developers. It's quick & easy.

Displaying a Cross Tab query on a Form

P: n/a
I'm sorry to ask this, but I just can't figure it out and it's probably
because it's not possible.

I have a Cross-tab query that shows me the sum of items received by
brand(Columns) for every month(Rows). It also has a sum at the end of
each row to give me a total for the month.

I would like to _show_ this on a Form, with a "Year Total" calculated
from the month totals.

A Datasheet view works to show the data rows ( I will be putting it in
a sub form) but I can't get the Yearly total to work(or even show). Is
it something I should put on the main form?

Ideally, I would also like to show the COUNT of submissions by brand
per month. (Each submission contains one or more items). Possibly from
another cross-tab query.

Does this make sense?

Jan 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.