Tags: access, aproblem, database, example, isnt, microsoft, mysql, oracle, receipts, reports, sellsproducts, shop, sql

How to make receipts with reports.

On Database » Microsoft Access

2,906 words with 2 Comments; publish: Sun, 01 Jun 2008 11:52:00 GMT; (25093.75, « »)

Hello. Maybe the question isnt about reports at all, but i have a

problem of making a simple database of a shop for example which sells

products to customers, looking through the inventory table and

selecting the what the customers wants to buy with a Yes/No field. but

that creates a problem of quantity..unless i create another field

which in some function or condition will multiply the price... and

then keep it in the database with the current day to be like a

shoppers history... but that seems too much for something that

simple... can anyone give me an advice or an example of a simple shop

database with a product list... and someway to make some type of

receipts on reports...

Thanks in advance

All Comments

Leave a comment...

  • 2 Comments
    • Look at how online stores do it. Their methodology seems very standardized

      now. The "Shopping Cart" idea is what I'm thinking of in particular. I

      presume this is just a separate, temporary table. Seems pretty

      straightforward.

      As for reports that look like receipts, I don't see the problem. Just set up

      your fields so that the report looks like a receipt.

      "K" <knuxus.ms-access.questionfor.info.gmail.com> wrote in message

      news:1177188496.636886.174570.ms-access.questionfor.info.d57g2000hsg.googlegr oups.com...

      > Hello. Maybe the question isnt about reports at all, but i have a

      > problem of making a simple database of a shop for example which sells

      > products to customers, looking through the inventory table and

      > selecting the what the customers wants to buy with a Yes/No field. but

      > that creates a problem of quantity..unless i create another field

      > which in some function or condition will multiply the price... and

      > then keep it in the database with the current day to be like a

      > shoppers history... but that seems too much for something that

      > simple... can anyone give me an advice or an example of a simple shop

      > database with a product list... and someway to make some type of

      > receipts on reports...

      > Thanks in advance

      >

      #1; Sun, 01 Jun 2008 11:53:00 GMT
    • On Apr 22, 6:26 pm, "David Portwood" <Mondro....ms-access.questionfor.info.yahoo.com> wrote:[vbcol=seagreen]

      > Look at how online stores do it. Their methodology seems very standardized

      > now. The "Shopping Cart" idea is what I'm thinking of in particular. I

      > presume this is just a separate, temporary table. Seems pretty

      > straightforward.

      > As for reports that look like receipts, I don't see the problem. Just set up

      > your fields so that the report looks like a receipt.

      > "K" <knu....ms-access.questionfor.info.gmail.com> wrote in message

      > news:1177188496.636886.174570.ms-access.questionfor.info.d57g2000hsg.googlegr oups.com...

      >

      If only there was an example... of that shopping cart... i have

      already request in another topic..but if you can give any hint... i

      would be more then thankful

      #2; Sun, 01 Jun 2008 11:54:00 GMT