|
Subject:
|
Access Database Help
|
|
Posted By:
|
jonnygrim
|
Post Date:
|
12/8/2005 3:38:38 AM
|
I have a form that enables users to input data to a certain number of tick box fields, i then have a query that collates 5 tables into one. I now need to have create a form which has all the fields used previously blank, still as tick boxes mark off the ones you need then it needs to produce a report of all the fields that have the same boxes marked.
ie.
I have a table with all makes of car
i have another table with all colours
then anonether with all tyre sizes
i run a query that links the makes of car id all together and gives me a list of all the cars that have the colours and tyre sizes together.
I now need to run another form that alows me to choose the tick boxes i want and produce a report for all data that matches.
Please help
ta
|
|
Reply By:
|
arasu
|
Reply Date:
|
12/8/2005 4:54:09 AM
|
Hi,
To use in this query
select a.car_fieldname, b.color_fieldname, c.tyres_fieldname from car a , color b , tyre c where a,carid = b.carid and b.car_id=c.carid
if carid is primary key/ common field for all table
Regards
Arasu. S
|
