noobie needs help.

  • Thread starter Thread starter testas
  • Start date Start date
T

testas

well aren't they always do?

right.
I need some tips on Access 2000, wuz wondering whether you guys’ll help me
out with this. and yeah, my english sux too.

Firstly, I got a list of item in a database, which I separate each of ‘em
with item codes. It’s something like this:

A1000 - books

B1000 - cassettes

C1000 - cd’s

Now I wanna re-arrange ‘em back according to the codes. I mean I got 60+
books, 20+ cassettes exactly 28 cd’s. I didn’t sort them accordingly when i
designed the db, so it sux when the datas are in jumbled order.

Instead of lookin’ like this:

A1000/1, A1000/2, B1000/3, C1000/4, C10005, A1000/6….

I wanna make ‘em look like this (when i look 'em up in a query ):

-A1000/1, A1000/2, A1000/3….

-B1000/1, B1000/2, B1000/3….

-C1000/1, C1000/2, C1000/3….

Question is: How do I use a query to do it?

I mean, I can list them down according to the codes, but I wanna re-number
‘em back accordingly so that I know the exact total of each.

I’ve been searchin’ all over the net, but no nearest sample on how to do it.

If you’re not too busy, Plz help.


Thanks in advance.

-yours truly -
 
Sorting is not done in tables. Rather you sort records in queries, forms, and
reports.

If your columns across the table look like the following:
A1000/1, A1000/2, B1000/3, C1000/4, C10005, A1000/6….
you are making a major mistake with the design.

You might want to look at some of the pre-built Access database templates
such as the music collection at:
http://office.microsoft.com/en-us/templates/TC010186291033.aspx
 
hey thanks man. yea i guess i screw up the design in the first place.
i'll look into it right away.
thanks fer the link!
 
Back
Top