View Single Post
  #4  
Old March 17th, 2010, 07:09 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Items table Revisited

After 15 posts this might still be a bit confused, not sure if you still
have an open question. But here's a thought on the sorting.

If all of your descriptions are as precisely formatted and entered as your
example, you could just use 4 fields, and derive your description from them

Field: Item (text)
Field: Dimension1 (numeric)
Field: Dimension2 (numeric)
Field: Type (text)

And sort by those.


And then derive your description from those whenever you need it:

=[Item] & " "& [Dimension1]&" x "& [Dimension2]&" "&[Type]