Crosstab or Other Type

Crosstab or Other Type - Not Sure!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mona-ABE - 03 Aug 2006 16:03 GMT

Can I send an Excel spreadsheet that shows what I'm attempting to accomplish?
I need some help with a query. I'm not sure what kind of query to use, and
if it's a crosstab, how to force it to allow 6 or more column headings and
sums of values in each column.

Signature

Thanks!
Mona-ABE

Reply to this Message

KARL DEWEY - 03 Aug 2006 19:35 GMT

Post an example of how your data is stored in the Access table and what you
would like the results of the query to be.

> Can I send an Excel spreadsheet that shows what I'm attempting to accomplish?
> I need some help with a query. I'm not sure what kind of query to use, and
> if it's a crosstab, how to force it to allow 6 or more column headings and
> sums of values in each column.

Reply to this Message

Mona-ABE - 03 Aug 2006 19:45 GMT

I have already copied this info from my mdb into an excel spreadsheet. How
can I get it to you? I don't see an option to post an attachment.

Signature

Thanks!
Mona-ABE

> Post an example of how your data is stored in the Access table and what you
> would like the results of the query to be.
[quoted text clipped - 3 lines]
> > if it's a crosstab, how to force it to allow 6 or more column headings and
> > sums of values in each column.

Reply to this Message

KARL DEWEY - 03 Aug 2006 20:42 GMT

I do not open attachments from unknown sources.

Just copy a few records and post here.

> I have already copied this info from my mdb into an excel spreadsheet. How
> can I get it to you? I don't see an option to post an attachment.
[quoted text clipped - 6 lines]
> > > if it's a crosstab, how to force it to allow 6 or more column headings and
> > > sums of values in each column.

Reply to this Message