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

Can I make both these reports from the same table?

P: n/a
I have two different levels of people who want to see my production
report.

We get orders which each call for one of five products.

One level wants to see a spreadsheet type report with six columns, one
for the order number and a column for each product. This report would
show the quantity ordered in the column for that product.

The other level wants to see a three column report. The report would
show the order number, a column with the product name, and the last
column would show the quantity.

I know how to make the report for the first type but I don't know how
to do the same without making another table like the report.
Specifically, I don't know how to get the name of the one of the five
columns that has the quantity in it. The name of that column would
then be the entry in the second column.

Please tell me if I can do this.
Oct 13 '06 #1
Share this Question
Share on Google+
3 Replies

P: n/a
You tell us what you want to see as output, but you don't describe what data
you have and how your Tables are laid out. If you will clarify, then
possibly someone will be able to not only tell you whether you can (the
answer I'd give now is: "probably so") but offer suggestions on how to do
it.

Larry Linson
Microsoft Access MVP

"Newbie" <xy******@yahoo.comwrote in message
news:kn********************************@4ax.com...
>I have two different levels of people who want to see my production
report.

We get orders which each call for one of five products.

One level wants to see a spreadsheet type report with six columns, one
for the order number and a column for each product. This report would
show the quantity ordered in the column for that product.

The other level wants to see a three column report. The report would
show the order number, a column with the product name, and the last
column would show the quantity.

I know how to make the report for the first type but I don't know how
to do the same without making another table like the report.
Specifically, I don't know how to get the name of the one of the five
columns that has the quantity in it. The name of that column would
then be the entry in the second column.

Please tell me if I can do this.

Oct 13 '06 #2

P: n/a
You can create a query and base the report on that. Why would you
create a new table?

Oct 13 '06 #3

P: n/a
Newbie <xy******@yahoo.comwrote in
news:kn********************************@4ax.com:
I have two different levels of people who want to see my
production report.

We get orders which each call for one of five products.

One level wants to see a spreadsheet type report with six
columns, one for the order number and a column for each
product. This report would show the quantity ordered in the
column for that product.

The other level wants to see a three column report. The
report would show the order number, a column with the product
name, and the last column would show the quantity.

I know how to make the report for the first type but I don't
know how to do the same without making another table like the
report. Specifically, I don't know how to get the name of the
one of the five columns that has the quantity in it. The name
of that column would then be the entry in the second column.

Please tell me if I can do this.
If you know how to make the first type but not the second, your
table structure is not correctly designed..

I'm sure your table has the following structure
Order_number
Item_01_qty
Item_02_qty
Item_03_qty
Item_04_qty
Item_05_qty

the proper table structure should be
Order_number
Item_Ordered
Qty_Ordered
Date_Ordered
Date_Delivered
....

Your second report is simply a query of the three columns you
want where date_delivered is still blank.

You get the first report by making a crosstab query of the three
columns, the order number is the row source, the item_number is
the columnsource and the value is the quantity.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.