Recent content by fendermate

Thanks Neil, I'll start researching. If I have any more problems (no doubt), I know where to come.

I would like to sort, numerically, the unit numbers and by building numbers. Here's another parallel problem; You have a database of customers' addresses. The streets are both numbers and names. Most data fields I've seen for addresses usually don't have separate fields for building # and street...

The order I would like when I sort in ascending order is units #1 to 23 of building #370 and below that units #1 to 23 of building #380 and below that, units #1 to 23 of building #390. If the units/ building numbers are in one field they are addressed as whole numbers. The resulting sequence is...

I presently have split the data into two fields and have no problems. What I'm doing is creating an entry form for others not so diligent with Access. If I stay with this design, I will have to figure out how to set up a search box to include both pieces of data; the unit number and the building...

No, they are all numbers. It would be nice to sort by building number eg. 1-370, 2-370, 3-370, etc. There are three buildings, #370, #380 & #390 and each building's units are numbered 1 to 23. Does that help?

My database is a maintenance record of our building complex. The unit/building number is the key field. The problem I am having is having access recognizing the unit numbers and building numbers, not as whole numbers. Example: I-380, 10-380, 2-390, 13-370, and so on. When sorted, access treats...