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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with table/query/report setup please
What you are performing here is a Many-to-Many join, and therefore this will require THREE tables to make it work properly. The first table, Members, will need a MemberID field (Autonumber) and a MemberName field (Text). The second table, RaceClasses, will need a RaceClassID field (Autonumber)...- Lhurgoyf
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
Format part of a text box
Is [Cumg/l] being returned as a single type value? That is what is sounds like.... Try replacing the [Cumg/l] with: CStr(Format([Cumg/l], "#0.0")) This should force a digit to be placed in at least the ones and tenths digit places and then give that value as a string...- Lhurgoyf
- Post #2
- Forum: Microsoft: Access Reports
