RE: Record Sorting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I Created a query which represents a table and on two fields set as
ascending order
No Good when i open a form and i a want the latest record to apppear at the end
Ascending means the values get larger as you go down the list. To have
latest at top you need descending - larger - lower.
Your number format will do neither as it is as you have the most significant
digits, 07 & 08 as the right most character.
Use a calculated field like this ---
Year: Right([ProjectQNo], 2)
And then sort on the ProjectQNo field place to the right of the calculated
field.

--
KARL DEWEY
Build a little - Test a little


"dan.cawthorne@xxxxxxxxx" wrote:

Hello and good morning,

can some help me in where i am going wrong,

I'm trying to sort records in a certain way, but its not working,

I Created a query which represents a table and on two fields set as
ascending order

the first column i had was called ProjectQNo: Which has numbers such
as Q077707 but when i hit the year 2008 the QNo was set to Q000108
What happened was all the Qno Numbers lower than say Q077707 where but
at the top of the table. No Good when i open a form and i a want the
latest record to apppear at the end

so i created a Query and Created a ProjectYear Field and had the
Date() format so it created the date automactily and the sorted
projects by ProjectYear: and then By ProjectQNo:

Was Working great untill the 02/02/08 its now its all the projects
created on or after the 02/02/08 in middle of all the January
Projects.


Whats Happening?

.