Query... a little lost

[Frodo]

I have 5 forms and 5 tables.

The database is blank, but the information entered into the forms are saved into the tables.

Now I want to make a query so I can see some statistics regarding the information entered into the forms and stored in the tables.

I have created a query, but Im not sure what to do next, do I connect it to the query and it should give me desired output or do I connect the form to the table
or how does it work ?

need some feedback Im a little bit lost in this
regards
Frodo

 

[oldaf294]

frodo,
First and foremost! Your tables must be related to each other in order for the info to be useful.
"one to many"
"many to one"
Referential integrity...
Once relationships are accomplished the tables are used in querys to supply info to forms and reports. You can use tables as the "Record source" of forms and reports but it is advised to use querys.
jim