soting data ascending not working

[Guest]

i dont know.i want to sort a column which is the result of two added columns
but it is not working ,I dont know why

 

[Ken Snell \(MVP\)]

Post the SQL statement of the query that you're using and let's see.

 

[Guest]

THANKS
It a simple sum query like (A2+E2) for a column of 777 cells. I cant sort
ascendingly this column?

 

[fredg]

THANKS
It a simple sum query like (A2+E2) for a column of 777 cells. I cant sort
ascendingly this column?

Looks like an Excel calculation, not Access.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.

Please repost to the correct newsgroup for the Excel program you are
using. I would suggest you include your Windows and Office version
number in the message.

 

[Guest]

Please provide the SQL like Ken requested. Open the query in design view.
Next go to View, SQL View and copy and past it here. Information on primary
keys and relationships would be a nice touch too.

If you can't find design view for the query, then fredg is probably right.

 

[Pat Hartman\(MVP\)]

Your result must be text. Fix the calculation so that it generates a
numeric result or enclose it in a function that will convert it to numeric.