- Messages
- 291
- Reaction score
- 1,576
- Points
- 153
w12 q15
Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.
And I am extremely SORRY for posting the ans late....
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.
And I am extremely SORRY for posting the ans late....
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....