473,320 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

report sorting

i am trying to sort my report by year. however, the format of the year is different than you would expect. the format is YY### (the # are a project number unrelated to the sorting). i am trying to get the report to sort by the year from NEWEST to OLDEST. for example, i want to sort from 06### to 76### in that order. i can get it to sort from the 90's to the 70s, but it leaves the 00's at the bottom.

any ideas?! any solutions?! please help!!

thanks
Jun 29 '06 #1
3 2017
i am trying to sort my report by year. however, the format of the year is different than you would expect. the format is YY### (the # are a project number unrelated to the sorting). i am trying to get the report to sort by the year from NEWEST to OLDEST. for example, i want to sort from 06### to 76### in that order. i can get it to sort from the 90's to the 70s, but it leaves the 00's at the bottom.

any ideas?! any solutions?! please help!!

thanks
That's what all that Y-2-K thing was about. Unfortunately, without seeing all your tables and data, the thing I would do (probably not the right thing to do, but it would work):

To the table that contains your "06###" field, add another field to hold the 4-digit year associated with it.

THEN add that field to the query your report is based on.

THEN, in your report, sort by the year field FIRST, then your "06###" field.

I think that would do it. The snag of course is that when you add a new record, you'll have to add the year in that extra field.

Don't know if this helps...
Jun 29 '06 #2
the report isn't based off a query, it's based off of a table. the thing is that i have to make this database easy to use because the person using it has never used it before.

however, i just played around with my report and the table assoc. with it and i found a field that i had not noticed before that i figured i could use to sort the way i wanted to. low and behold, it worked! i didn't know the coulmn existed until know ( i didn't create it ) - i convereted this entire database from Lotus Approach, so i have lots of fun still ahead of me.

thanks for your reply. if you're an avid access person, i'd appreciate using your expertise for some further problems and questions i know i will have.

thanks a lot
Jun 29 '06 #3
the report isn't based off a query, it's based off of a table. the thing is that i have to make this database easy to use because the person using it has never used it before.

however, i just played around with my report and the table assoc. with it and i found a field that i had not noticed before that i figured i could use to sort the way i wanted to. low and behold, it worked! i didn't know the coulmn existed until know ( i didn't create it ) - i convereted this entire database from Lotus Approach, so i have lots of fun still ahead of me.

thanks for your reply. if you're an avid access person, i'd appreciate using your expertise for some further problems and questions i know i will have.

thanks a lot
You can certainly use me -- though I still consider myself a novice -- especially when it comes to writing expressions. But I'll be happy to share what I can!
Jun 29 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Hohn Upshew | last post by:
I need some help to build a report enumerating the products in descending order depending on the sum of liters. In this way i can view the top products sold for a given period.But i fail to do...
3
by: Grim Reaper | last post by:
I know this is probably an easy question, but I could not find/figure it out. Basically, I am printing mailing labels with a "Sorting/Grouping" section that groups the label types together....
3
by: ahaque38 | last post by:
Hello. Using A2K SP3, I am having the following problem with a report using "Sorting and Grouping". I have recently added a grouping in the reports for "Category2<>'CONTRACTS'". I have...
11
by: James P. | last post by:
Hello, I have a report with the Priority field is used as sort order and grouping. The problem is the data in this Priority field if sorted in ascending order is: High, Low, and Medium. How...
8
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...
5
by: Mike | last post by:
Hello All, I have a report based upon a query. I have added a control to report footer that calcs the total cost of the inventory: =SUM(). When this total calculation is NOT on the report,...
7
by: manning_news | last post by:
I've got a report that's not sorting correctly. I build a SQL statement and assign it to the recordsource in the Open event, sorting the data the way the user chooses. The user can choose up to 3...
4
by: ApexData | last post by:
I have one table used to maintain information on Service Events. Each record contains a Repair, Maint, and Battery checkbox (bound/boolean). Any one of these fields may be checked or left empty....
4
by: Jana | last post by:
Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite...
8
by: sara | last post by:
Hi - I have looked at all posts and tried both Allen Browne's Report Sorting at run Time ( Select Case Forms!frmChooseSort!grpSort Case 1 'Name Me.GroupLevel(0).ControlSource = "LastName"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.