Report Format

[rgreene]

I have a database that tracks client contact and I have a report that I want to print that shows all the contact a rep has had with the client. I enter the start and end dates I want and the reps name and when I run the report its listed in date order so I might have Jane Doe - 10/1/06 then Jack Jones - 10/2/06 then Jane Doe - 10/3/06 (again) I want Jane Doe - 10/1/06 , 10/3/06 then Jack Jones - 10/2/06 and so on. I'm pulling the information from a query and when I run the query it displays it properly with all the Jane Doe records together but when I run the report is sorted by date. I am in the process of redoing this database and it's on the new one this happens on the old database it works like it's supposed to when I print/view the report.

Any thoughts on where to check?

Thanks,
Rick

 

[lightray]

Can you post an image of your page?
Have you applied any grouping in your report? check grouping tab

Does your query sort on the right fields?

 

[rgreene]

I don't think I have any groupings and I probably should have mentioned this is access 97. Where do I find groupings?

What kind of image do you want?

 

[lightray]

Gosh! it's certainly been a while since I used 97 (10+ years), and I currently don't have a version.

Usually groupings is on the tool bar when in design mode. You could also check if a User has resorted your table on the date column, if there is no sorts in the query or groupings in the report.

.... a screen dump in design view would certainly tell if you have group headers or footers.

... perhaps a 97 User could pick this up

 

[gemma-the-husky]

is this ok now? - ignore this if it is

access reportsdon't use the sorting declared in the query - they use their own sorting. There is a sorting and grouping icon on the tool bar, or right click the whole report selector (top left of report design). Then pick sorting and grouping for your report.

 

[rgreene]

That's it THANK YOU VERY MUCH!!

Rick

 

[rgreene]

After playing around a little more I guess I have only gotten 1/2 of my format issue fixed. I'm trying to get it to sort on the last name and then on a contact date. The last name is working correctly and in the grouping section I added my cdate as the second grouping (after lname) but my report has for instance a record from 9/22 then the next one is 9/6. Another clients report is 9/13 then 9/14, 9/20, then 9/8 and 9/12 another is 9/25, 9/12, then 9/22

And like I said this is a redesign from an existing database and I compared the grouping settings onthe 2 and they look the same.

 

[gemma-the-husky]

you have a problem with your dates. it sounds like your cdate is a string not a date

if you thing about them as text strings then this is not necessarily sorted wrongly

9/22 then
9/6 is correct in terms of a text string

eg
9/13
9/14
9/20
9/8 makes sense as a text sort
(although 9/12) would appear to be wrong in this context. (perhaps there are some spaces or something)

Have another look at how the sort is working - I am sure Access is doing it correctly, even if its wrong!