Help please... filtering query

[Jarreman]

Hi, i am a self tought novice to access. i have created a database for my scout troop and i am tying to filter a query between two dates.

I have one table for school terms consisitng of 3 fields:
the first field id the term name, second field the start date and the third field is the finish date.

I have another table for finances, this has field for the scouts name, the date, paid etc.

Basically i want to create a query that will show the payments the scouts have paid for each term.

I have managed to filter the table using an equation in the criteria box in design view on the date field for the finaces table, but i would like to incorportate the term table too.

As i mention avou i am a novice so please forgive my ignorance if i am doing somthing completly wrong

Cheers

 

[Guus2005]

It all starts with a normalised database. You're giving very little information about your tables and i get the impression that your database isn't properly normalised. Read about normalization in the wikipedia pages.

You will notice that scouts name, the date, paid etc can't all be in the same table and you must have a reference between the Terms and the payments.
Logically the date is a reference which points to the term but only if that fact is known in the database. So you must have a table for that.

HTH

 

[Jarreman]

Thanks Guus2005,

I managed to compete my query using the following sql:

SELECT Term.Term, Finances.Scout, Finances.Date, Finances.Description, Finances.[Received (In)], Finances.Notes
FROM Term, Finances
WHERE (((Finances.Date)>Term!Start And (Finances.Date)<Term!End) And ((Finances.Description)="Subs Payment"))
ORDER BY Finances.Date;

cheers

 

[Guus2005]

If you got there from my answer then you're no novice. Maybe a little rusty