Newbie Help - Query Intergration

[fatmcgav]

Hi

I'm new to this Access lark, and i have a limited knoweledge of MS Access.

I am currently doing a school project, which involves me designing an Access Database for a garden centre. this garden centre needs to be able to produce reports containing plants that fit certain user defined criteria.

The user will choose the following data:

Max Height

Max Width

Light Needed

which will then be input into the computer.

The garden centre then need to be able to produce a report that contains the above data, plus the plants' common name, flowering period and price, and also their company header.

I am at a loss at what to do, i had a read of the How To Article about controlling Report Data, but i got lost along the way. i have a basic data table containg all the plant info, and a basic stock list report, and also a plant input/edit form.

Thanks in advance for any replies

 

[jtvcs]

You're right this is a project ! First you must create a query or query form to allow the user to enter Width, Height, etc. needed. Then you can probably use the Report Wizard to create the basic report but you'll have to add the Company logo, etc. manually. Good luck. JT