Items table help
in [Tables]
|
From: Rob H on 13 Mar 2010 13:18 You are absolutely correct! i have much more experience with Excel, I'm just trying to learn Access as I go about creating this database. you mentioned "JV's", probably something I'm aware of but please elaborate. Thanks for the help "Piet Linden" wrote: > On Mar 13, 10:07 am, Rob H <R...(a)discussions.microsoft.com> wrote: > > Well, yes and no. I really want to sort by Item name first(Dewy Dragonfly) > > then by Size(8x10, 11x14, etc), and then further sort by the Type(Print 1st, > > matted 2nd, and framed 3rd). To get this: > > > > > > Dewy Dragonfly 11x14 Print > > > > Dewy Dragonfly 11x14 Matted > > > > Dewy Dragonfly 11x14 Framed > > > > Moulton Barn 12x24 Print > > > > Moulton Barn 12x24 Matted > > > > Moulton Barn 12x24 Framed > > > > Moulton barn 16x31 Print > > > > Moulton Barn 16x31 Matted > > > > Moulton Barn 16x31 Framed > > > > Maybe this is not as big of an issue as I envision, but when looking up an > > item it would be much easier if the items were listed in this fashion. > > > > I hope this clarifies my issue a bit. > > > > "Duane Hookom" wrote: > > > If I understand correctly you want to sort by size. The issue might be that > > > you aren't storing numeric values. Have you considered using two numeric > > > fields ItemHeight and ItemWidth? You could then sort by either field, both, > > > or the product (square inches). This would remove the problem of 8x10 > > > sorting after 10x14. > > > > > -- > > > Duane Hookom > > > MS Access MVP > > > > > "Rob H" <R...(a)discussions.microsoft.com> wrote in message > > >news:397F9B93-E8B2-4A8D-816B-A585A47AD364(a)microsoft.com... > > > > I have a photography business that I am setting up a database for > > > > tracking > > > > sales by customer, item, demographics etc. I'd like some advise on the > > > > items > > > > table, I have over a hundred photographs that I currently offer for sale > > > > and > > > > each photograph is offered in various sizes as well as being a print only, > > > > matted or matted and framed. This is going to make the items table quite > > > > extensive. > > > > This is an example of what I have right now: > > > > > > Item Size Type > > > > Moulton Barn 12x24 Print > > > > Moulton Barn 12x24 Matted > > > > Moulton Barn 12x24 Framed > > > > Moulton barn 16x31 Print > > > > Moulton Barn 16x31 Matted > > > > Moulton Barn 16x31 Framed > > > > Dewy Dragonfly 11x14 Print > > > > Dewy Dragonfly 11x14 Matted > > > > Dewy Dragonfly 11x14 Framed > > > > > > and so on; > > > > > > So, each "Item" can have 6-12 "options" (ie: size, print or size, framed > > > > etc) x 100 photographs the list will be quite long. > > > > > > What's happening is; when I sort by Item>Ascending, the photos are listed > > > > alphabetically but the size and type become scrambled as such; > > > > > > Dewy Dragonfly 11x14 Framed > > > > Dewy Dragonfly 11x14 Print > > > > Dewy Dragonfly 11x14 Matted > > > > Moulton Barn 12x24 Print > > > > Moulton Barn 16x31 Matted > > > > > > I want the list to maintain the order of Item alphabetically, then Item > > > > size and finally Item Type in the order of Print, Matted or Framed. The > > > > obvious is to re-create the Items table and enter the items in the order I > > > > need but once done and I later add a new image I'm back to square one.. > > > Oh, you're an Excel guy. Excel <> Access. Write a query, and run it > when you want your data sorted in a particular way. <include JV's > "tables are unsorted buckets of data" speech here> > . >
From: Stop$teve on 13 Mar 2010 13:36 "Steve" <notmyemail(a)address.com> schreef in bericht news:eHEDPFtwKHA.3408(a)TK2MSFTNGP06.phx.gbl... > > If you need help with your database, I can help you get up and running quickly. I provide help with Access, Excel and Word > applications for a small fee. Contact me if you want my help. > -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!) Arno R
From: Duane Hookom on 13 Mar 2010 13:40 JV is MVP John Vinson. He (and other wise posters) describe records as if they were marbles in a bag/bucket, in the back of a pickup truck, going down a bumpy road, making sharp turns ;-) There is no order to them until you create a query or SQL statement with an ORDER BY clause. If you hang out here more with questions, you are bound to run into John Vinson. -- Duane Hookom MS Access MVP "Rob H" <RobH(a)discussions.microsoft.com> wrote in message news:2C8B3213-8950-4B27-A878-066F9EE524C7(a)microsoft.com... > You are absolutely correct! i have much more experience with Excel, I'm > just > trying to learn Access as I go about creating this database. > > you mentioned "JV's", probably something I'm aware of but please > elaborate. > > Thanks for the help > > "Piet Linden" wrote: > >> On Mar 13, 10:07 am, Rob H <R...(a)discussions.microsoft.com> wrote: >> > Well, yes and no. I really want to sort by Item name first(Dewy >> > Dragonfly) >> > then by Size(8x10, 11x14, etc), and then further sort by the Type(Print >> > 1st, >> > matted 2nd, and framed 3rd). To get this: >> > >> > > > Dewy Dragonfly 11x14 Print >> > > > Dewy Dragonfly 11x14 Matted >> > > > Dewy Dragonfly 11x14 Framed >> > > > Moulton Barn 12x24 Print >> > > > Moulton Barn 12x24 Matted >> > > > Moulton Barn 12x24 Framed >> > > > Moulton barn 16x31 Print >> > > > Moulton Barn 16x31 Matted >> > > > Moulton Barn 16x31 Framed >> > >> > Maybe this is not as big of an issue as I envision, but when looking up >> > an >> > item it would be much easier if the items were listed in this fashion. >> > >> > I hope this clarifies my issue a bit. >> > >> > "Duane Hookom" wrote: >> > > If I understand correctly you want to sort by size. The issue might >> > > be that >> > > you aren't storing numeric values. Have you considered using two >> > > numeric >> > > fields ItemHeight and ItemWidth? You could then sort by either field, >> > > both, >> > > or the product (square inches). This would remove the problem of >> > > 8x10 >> > > sorting after 10x14. >> > >> > > -- >> > > Duane Hookom >> > > MS Access MVP >> > >> > > "Rob H" <R...(a)discussions.microsoft.com> wrote in message >> > >news:397F9B93-E8B2-4A8D-816B-A585A47AD364(a)microsoft.com... >> > > > I have a photography business that I am setting up a database for >> > > > tracking >> > > > sales by customer, item, demographics etc. I'd like some advise on >> > > > the >> > > > items >> > > > table, I have over a hundred photographs that I currently offer for >> > > > sale >> > > > and >> > > > each photograph is offered in various sizes as well as being a >> > > > print only, >> > > > matted or matted and framed. This is going to make the items table >> > > > quite >> > > > extensive. >> > > > This is an example of what I have right now: >> > >> > > > Item Size Type >> > > > Moulton Barn 12x24 Print >> > > > Moulton Barn 12x24 Matted >> > > > Moulton Barn 12x24 Framed >> > > > Moulton barn 16x31 Print >> > > > Moulton Barn 16x31 Matted >> > > > Moulton Barn 16x31 Framed >> > > > Dewy Dragonfly 11x14 Print >> > > > Dewy Dragonfly 11x14 Matted >> > > > Dewy Dragonfly 11x14 Framed >> > >> > > > and so on; >> > >> > > > So, each "Item" can have 6-12 "options" (ie: size, print or size, >> > > > framed >> > > > etc) x 100 photographs the list will be quite long. >> > >> > > > What's happening is; when I sort by Item>Ascending, the photos are >> > > > listed >> > > > alphabetically but the size and type become scrambled as such; >> > >> > > > Dewy Dragonfly 11x14 Framed >> > > > Dewy Dragonfly 11x14 Print >> > > > Dewy Dragonfly 11x14 Matted >> > > > Moulton Barn 12x24 Print >> > > > Moulton Barn 16x31 Matted >> > >> > > > I want the list to maintain the order of Item alphabetically, then >> > > > Item >> > > > size and finally Item Type in the order of Print, Matted or Framed. >> > > > The >> > > > obvious is to re-create the Items table and enter the items in the >> > > > order I >> > > > need but once done and I later add a new image I'm back to square >> > > > one.. >> > >> Oh, you're an Excel guy. Excel <> Access. Write a query, and run it >> when you want your data sorted in a particular way. <include JV's >> "tables are unsorted buckets of data" speech here> >> . >>
From: John W. Vinson on 13 Mar 2010 15:05 On Sat, 13 Mar 2010 12:40:00 -0600, "Duane Hookom" <duanehookom(a)gmail.com> wrote: >There is no order to them until you create a query or SQL statement with an >ORDER BY clause. If you hang out here more with questions, you are bound to >run into John Vinson. <g> Once in a while... -- John W. Vinson [MVP]
From: Rob H on 13 Mar 2010 15:23 Get Lost "Steve" wrote: > You need Item, Size and Type tables: > TblType > TypeID > Type > > TblSize > SizeID > Size (text) > SortOrder (1 to whatever) > > TblItem > ItemID > Item > > Then you need a table that lists the type and size of each item.... > > TblItemSizeType > ItemSizeTypeID > ItemID > SizeID > TypeID > > To get the sort you want, you need a query that includes all the above > tables. Include the fields in your query: > Item from TblItem > Size from TblSize > SortOrder from TblSize > Type From TblType > > In the query set .... > sort for Item as Accending; > sort for SortOrder Ascending > sort for Type Descending > > If you need help with your database, I can help you get up and running > quickly. I provide help with Access, Excel and Word applications for a small > fee. Contact me if you want my help. > > Steve > santus(a)penn.com > > "Rob H" <RobH(a)discussions.microsoft.com> wrote in message > news:397F9B93-E8B2-4A8D-816B-A585A47AD364(a)microsoft.com... > > I have a photography business that I am setting up a database for > > tracking > > sales by customer, item, demographics etc. I'd like some advise on the > > items > > table, I have over a hundred photographs that I currently offer for sale > > and > > each photograph is offered in various sizes as well as being a print only, > > matted or matted and framed. This is going to make the items table quite > > extensive. > > This is an example of what I have right now: > > > > Item Size Type > > Moulton Barn 12x24 Print > > Moulton Barn 12x24 Matted > > Moulton Barn 12x24 Framed > > Moulton barn 16x31 Print > > Moulton Barn 16x31 Matted > > Moulton Barn 16x31 Framed > > Dewy Dragonfly 11x14 Print > > Dewy Dragonfly 11x14 Matted > > Dewy Dragonfly 11x14 Framed > > > > and so on; > > > > So, each "Item" can have 6-12 "options" (ie: size, print or size, framed > > etc) x 100 photographs the list will be quite long. > > > > What's happening is; when I sort by Item>Ascending, the photos are listed > > alphabetically but the size and type become scrambled as such; > > > > Dewy Dragonfly 11x14 Framed > > Dewy Dragonfly 11x14 Print > > Dewy Dragonfly 11x14 Matted > > Moulton Barn 12x24 Print > > Moulton Barn 16x31 Matted > > > > I want the list to maintain the order of Item alphabetically, then Item > > size and finally Item Type in the order of Print, Matted or Framed. The > > obvious is to re-create the Items table and enter the items in the order I > > need but once done and I later add a new image I'm back to square one. > > > > Ideas? > > > > Thank You > > > > > . >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: I need help setting up my database Next: Items table help - stevie PIMPS again! |