473,320 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can I make both these reports from the same table?

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
3 1399
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
You can create a query and base the report on that. Why would you
create a new table?

Oct 13 '06 #3
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: airkart | last post by:
Hello, I've scoured groups and the web, and haven't found a question like mine answered. I'm using Visual Studio 2003 with the Crystal Reports it comes bundled with and SQL Server 2000....
4
by: Oreo Bomb | last post by:
I have a secured database that contains a Read-Only group. This group has permissions to view reports, but cannot add, edit, or delete any DB objects. One of the reports the group needs access to...
42
by: WindAndWaves | last post by:
Dear All Can you tell me why you use a class module??? Thank you Nicolaas ---
24
by: Bob Alston | last post by:
Anyone know a way to make all access to a linked table, in another Access MDB, read only? I really don't want all the hassle of implementing full access security. I can't do this at the server...
5
by: Alberto | last post by:
My application uses Access and I have some reports. The problem is that when I design the reports, I use the path of the database in my machine but in the customer it will not be the same. How can...
6
by: scottyman | last post by:
I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm lost in the Java world. The script at the bottom of...
3
by: LurfysMa | last post by:
I would like to hear opinions on the tradeoffs of putting the tables, forms, and queries for several related datasets in separate databases vs one combined database. I am working on an...
6
by: Ian Boyd | last post by:
Every time during development we had to make table changes, we use Control Center. Most of the time, Control Center fails. If you try to "undo all", it doesn't, and you end up losing your identity...
9
by: Mourad | last post by:
Hi All, Is it possible to create a Make Table query in access (2.0 and 2003) that creates the table into a SQL Server database? Following the steps: 1- Create New Query 2- Set Query Type as...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.