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!
Count(*)
- Thread starter bigcam
- Start date
(*) is used as a wildcard character to find groups of records in which the entries match a specific pattern.
(*) is also used to add all the fields to the query grid.
1. Remove the asterisk from the query grid.
2. Add the fields you want to group by to the query field.
3. Add the field you want to calculate with to the query field.
4. In the Total row for the field you want to group by, select the fuction you need.
5. Click the view button to check the results.
Good luck with your calculation query...
chubby
(*) is also used to add all the fields to the query grid.
1. Remove the asterisk from the query grid.
2. Add the fields you want to group by to the query field.
3. Add the field you want to calculate with to the query field.
4. In the Total row for the field you want to group by, select the fuction you need.
5. Click the view button to check the results.
Good luck with your calculation query...
chubby
- Status
Similar threads
- Locked
- Question
