Having Two sets of same info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello guys and dolls, I dont know if I'm asking this question right. But
this is my first time using Access. I have 53 columns, which consist of 1
item number, and 52 weeks of sales. There are two sets of sales that I need
to put together in this report. A column that says my POS, and another that
says their POS. So far I have my pos and their POS, how can I put this in
Access to have the 123 item numbers, and two rows per item? So far I can
only do one row??????????? Pleaseeeeeeeeeeee helpppppppp!
 
I went the easy way out, I ran two seperate queries, then copy one and pasted
it on to the other since it had the same fields, then just sorted the one
spreadsheet, thats the easy way out.
 
Not sure what you are trying to do. Sounds like your table is....
ITEM NUMBER
WEEK1
WEEK1
....
WEEK52

Now, what do you want to pull? You say you want to pull two sets of sales.
Which ones? Your query would simply include the part number and the two
columns you wish to pull.

We need more details.
 
Hello guys and dolls, I dont know if I'm asking this question right. But
this is my first time using Access. I have 53 columns, which consist of 1
item number, and 52 weeks of sales.
Click to expand...

Then you have an incorrectly designed table. Storing data, such as a
week number, in a fieldname is ok for spreadsheets - but Access *IS
NOT A SPREADSHEET*!

A better design would be to have *two* tables:

Items
ItemID
<description of the item>

WeekSales
SaleID Autonumber
ItemID <link to Items>
POS <whatever datatype that might be>
There are two sets of sales that I need
to put together in this report. A column that says my POS, and another that
says their POS. So far I have my pos and their POS, how can I put this in
Access to have the 123 item numbers, and two rows per item? So far I can
only do one row??????????? Pleaseeeeeeeeeeee helpppppppp!
Click to expand...

You can use a "Normalizing Union Query" to get the data out of your
54-column spreadsheet into a normalized table; if you wish to do so,
please post your table name and some representative fieldnames.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top