Recent content by sjohno

Hi Garry Thanks I'll give it a go, appreciate all your help. regards Sarah

Hi Garry The query has the set info on the left hand side: FIELD TABLE TOTAL SORT SHOW CRITERIA or: In the FIELD I have in each titles in each column. In the TABLE it is based on the REPAIRS TABLE. In the TOTAL I have the GROUP BY with the drop down arrow which gives the following summary...

Hi Bob I need to create a query from a table using the TOTALS button. This brings up the TOTAL row in the query with the GROUP BY and a drop down box with all Min,Max,Sum Count etc Expressions. I have to find the number of mechanics in the Table and when I use the Count in the CRITERIA row...

Hi I understand and agree with you, the mechanics that appear more than once in the table have different jobs asigned to them i.e. David has done 3 different jobs on 3 different cars Each mechanic has a job no assigned to them, the Job No is in the Field Name in the Table and is also the...

Hi Garry Thanks for replying, sorry I am a little confused with your help. I need to create a QUERY from the table and am using the Totals button. This brings up the TOTAL row in the query with the GROUP BY and a drop down box with all Min,Max,Sum Count etc Expressions. When I use the Count...

I am currently learning the Totals in Access 2003, using the Group By and it's drop down menu which has all the Min,Max,Sum Count etc Expressions. I have a table of which I need to create a query, the table contains info with Mechanics names and jobs that they have done, often a mechanics name...