Access question

Funkmasterr · Post by **Funkmasterr** » May 11, 2006, 3:49 pm

If I have a record in access that is sorting its self in binary format (ie:1,100,101, etc, ) as opposed to numeric (1,2,3,4) how do I change that ? It has been forever since I have worked with access and I cannot remember anymore.

Edit: this info is a .csv file downloaded from on of our forms.

Truant · Post by **Truant** » May 11, 2006, 5:05 pm

I'm gonna go with.......magic?

Funkmasterr · Post by **Funkmasterr** » May 11, 2006, 5:20 pm

cadalano · Post by **cadalano** » May 12, 2006, 9:33 am

i'm thinking that your question is too vague for anyone to help you. unless its a common problem and i've just never heard of it

Lynks · Post by **Lynks** » May 12, 2006, 10:24 am

Its because that field isnt a Number but most likely Text. Change the field to number and it should sort you out. If thats not the case, then its magic.

Zaelath · Post by **Zaelath** » May 12, 2006, 10:24 am

cadalano wrote:i'm thinking that your question is too vague for anyone to help you. unless its a common problem and i've just never heard of it

Not to mention that "binary" and "numeric" are the same sort order. Personally, I think he's been on the pipe, again.

Funkmasterr · Post by **Funkmasterr** » May 12, 2006, 7:11 pm

Ok, maybe I was being a bit vague.

The retailer is saving a po from our site, it saves as a .csv file which you can open in excel or access, they are using access. One of the fields from the po that is opening in access is the store number, and the way it is sorting that field is something to the effect of what I said in the first post

1,10,11,12,118 (just an example) through all the stores that start with one, then it goes to the store that start with a two. So in short, its sorting by the first digit mainly.

The way I want to get that field to sort is like you would think it should 1,2,3,4,5 etc..

I think that might make a bit more sense. I need to do a desktop share with them on monday and try to figure it out so I was looking for ideas cause I havent kept my access skills up for the past few years now.

edit:
Meant to say thanks Lynks, im just getting as many ideas as I can built up so i'll give that a shot.

Xyphir · Post by **Xyphir** » May 12, 2006, 8:13 pm

Sounds like they have the store ID formatted as a Text, not Number. If they're opening the PO into an Access table, click the Table 'Design View' button in the upper left. Find the field for the Store ID and change the 'Data Type' from Text to Number.

Zaelath · Post by **Zaelath** » May 13, 2006, 2:13 am

Xyphir wrote:Sounds like they have the store ID formatted as a Text, not Number. If they're opening the PO into an Access table, click the Table 'Design View' button in the upper left. Find the field for the Store ID and change the 'Data Type' from Text to Number.

What Xyphir said. The DB this is imported to needs the right datatypes on the fields.

Funkmasterr · Post by **Funkmasterr** » May 14, 2006, 4:08 pm

Thanks guys, that sounds about right. I need to polish up my database skillz here, i'm a little rusty.