Note: Always have to create a query before a Wizard report because a Wizard report is simply juts a 'fancy' print layout!
1. Click on the query button
2.Press 'add' and select all the fields which have appeared in the little box
1. Click on the query button
2.Press 'add' and select all the fields which have appeared in the little box
3.drag and drop them into the box below!
4. Now add customized fields, which the questions tell you to add.
5. Next you have to save the query and close it! (this is very important, if you don't do this the next step wont work!)
Calculated Fields
1. Click in the first empty box at the end of your query
2. Click on 'builder' in the ribbon
3.Double click the fields you need in your calculations and on any '+-*/' you need. In this example it was [cost price] + 200
4. Click 'ok' in the builder
5. Test your calculations!
6.Go back into design view and delete the text EXPR1_ KEEP THE COLON:
7. Type in the new field name and test it works.
8. In design view, then click on 'property Sheet' and correct any formatting problems
9. If the properly sheet does not display correctly, save a