Sorting in Report, Text Vs. Numbers

[boblarson]

Your table isn't properly structured. Every discrete peice of data needs to be in its own field. You are jamming 2 peices of data (Category Number and Variety) into SGCatNo and then doing some Frankenstein sorting to overcome it. You need to break this data out into 2 fields, one for the numeric Category Number value and one for the text Variety value. You do that and sorting this like you want it becomes trivial.

Good points

 

[Romper]

Yeah, I was aware of that and I know you're right but I really didn't want to break them up like that and then attempt to bring them back together to display properly. Oh don't worry, this whole mess has been a massive learning curve for me, and I do appreciate the assistance everyone's been giving me but I never thought my idea of creating a simple little stamp database would have turned into what it has.

Thanks heaps to you both.

 

[mdlueck]

... but I really didn't want to break them up like that and then attempt to bring them back together to display properly.

'tis not hard to concatenate two fields back together in order to display them as if they were one field.

SQL could do it.

VBA could do it.

 

[Romper]

'tis not hard to concatenate two fields back together in order to display them as if they were one field.

SQL could do it.

VBA could do it.

Thanks, but as it is, in the last few weeks I've had to try and grasp normalization, relationships, queries and many other small tit-bits just to get what I would consider the most basic of a database to function. I bit off more than I can chew in such a small amount of time and now my brain is mush!

Having said that, day by day my Access for Dummies book is slowly making more sense!

 

[UnrulyJulie]

Shouldn't this also work for grouping? I created an expression using MyGroup rather than MySort - I can't seem to get it to work. I've downloaded and looked at the sample db and have everything set up the same, but simply changed MySort to MyGroup and called it as the group by.

The report is for physical inventory sorted by bin number, so I have more than one item stored in a bin, and need to group by bin, an alpha-numeric text field. Any suggestions?

Thanks!!