Prev: I need help setting up my database
Next: Items table help - stevie PIMPS again!
From: Rob H on 14 Mar 2010 09:17
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"

This worked perfectly for the original data in the Items list, however, when
I enter new items and do a Refresh both the Item and Type update correctly
but the Size is not working. If I choose Ascending in the layout view the
old records show correctly but the new records show in reverse(descending).
If I reverse the sorting order for size then just the opposite happens...

"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>
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: I need help setting up my database
Next: Items table help - stevie PIMPS again!