Creating a SKU by store report

[Zalathar]

I have a table, it is fairly large but pretty simple.

It lists store numbers in the first column. Each column that follows is a SKU, and in the field it either has a 1 or a 0 to represent 1 if it is stocked in the store, and 0 if it is not.

Can I write a report that will show what each store has, and how do I do that? I basically want it to return the sku number (and its description) if it has a one in the box, but not if it doesn't.

It seems easy, but I cant figure it out, or where to even look.

I'm a pretty new user. Thanks for any help.

 

[pr2-eugin]

Hello Zalathar, Welcome to AWF !

Please could you explain a little bit more, with some sample data maybe? Are your current description is quiet vague.

 

[Zalathar]

Current table :

Str#-43840-43832-35810- and so on...
111-- 1 ---- 0 ---- 0
115 0 1 1
117 1 0 0
121 0 0 0
126 0 0 1
etc,
etc
etc

End result that I'm trying to get to:

Store# 111 - Sku 43840 - lookup to a table, return the description for each sku

Store #115 - Skus 43832, 35810 - return descriptions also

Store #121 - blank

etc etc.


Does that help?

 

[JHB]

..
It seems easy...

But it is not due to poor database/table structure.
In databases, data is stored vertically and not horizontally.
I would suggest that you change your tables so that you store data vertically, the other will only cause you problems now and later.

 

[Zalathar]

Hi, thank you. I'm not sure I understand why, but I can flip the table around if that helps.

So if my table has records by Sku - and each store is a field... then I can make a report that tells me for each store what skus it carries (while not returning any zero values)?

 

[JHB]

Post some sample data in a database or Excelsheet, from the flipped around table, zip it.