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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 97 graph in report
I've designed a report that uses a query as its source for three fields: ID#, Date, TestResult. The report is sorted by ID# and then date with a header for the ID#. I'd like to insert a graph that shows the TestResult (y axis) plotted against date (x axis) for each ID# (separate graph for...- KMAC54
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
selecting one row from multiple rows based on a date calculation
thanks; I'm a little unclear on how to implement the "TOP 1" instruction. This sounds like a setting for a sort command, but I'm not familiar with it. thanks- KMAC54
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
selecting one row from multiple rows based on a date calculation
I'm doing a query on two tables linked by an ID number. Table 1 has one line per ID number that contains an event date we'll call majordate. Table 2 has multiple lines per ID number that contains multiple event dates we'll call minordate and another field we'll call parameter1. Can anyone...- KMAC54
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
