Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to extract records that aren't distinguised in a field
Thanks Skip . . . . . . for your reply and inquiries. These four weather condition categories would really have been easier to work with had only one field been created called: "Weather Conditions", with a combo box added to the user entry form with selections for: Sunny, Rainey, Foggy, Stormy...- starbest
- Post #3
- Forum: Microsoft: Access Reports
-
How to extract records that aren't distinguised in a field
I have inherited a database that was not set up as being relationally friendly. I am trying to report on traffic conditions in comparison with weather conditions. There are four categories of weather distinguished by their own separate fields. The name of the fields are: Sunny, Rainey, Foggy...- starbest
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
-
Records with highest value per group on report
Brilliant. Thank you. The only problem is that for some reason I am not able to group on TEST. It is not showing in the list to group on when using the report wizard. When I force a grouping through the 'Sorting/Grouping' method on the drop down menu, it still will not group on the report by...- starbest
- Post #4
- Forum: Microsoft: Access Reports
-
Records with highest value per group on report
My report shows test grades for each member. There are two tests: 1. Math 2. Reading. A member may have several grades. I only want to include on the report, the highest grade for math and the highest grade for reading. Other times, however, there will be more than one record per subject and...- starbest
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
