Search results

he had the right answer - it works nobody else found me a solution, whatever

How would I make a similar query to show the members who have paid in previous years, relating to the current year at the time the query is run? i.e. run the query in 2003, 2002 members are shown, and 2001, 2000, 1999 etc run it in 2004, shows 2003,2002,2001 etc how would i go about this...

Thank you john, you are a godsend!

that doesnt go in the criteria box?

no? how do i do it? where does this go?

it doesnt work!

And I just type that into the 'criteria' box?? Isn't that some other thing that im not supposed to use?

When they pay in a paticular year, its a years membership, just for that year. i.e. pay in january 2003, membership is till 2004 pay in october 2003, membership till 2004 etc it doesnt matter when they pay, the membership is only valid for that current year. im looking for those payments...

I mean it needs to just calculate whos paid by working out from the date last paid field... e.g. if the date last paid field is 01/01/2003 it needs to show up on the query but if its 01/01/2002 or anytime in 2002 it shouldnt show. Then I need to make a query to show the members that havnt...

Hi, I'm having a problem with a query. I have a database about a fishing club. I need a query that will find all of the members that have paid. There are two fields in particular in the member table, 'Member since' and 'Date latest fee paid' I cant figure out the criteria to put into the...

[smile]! Thank you guys, works like a charm! Much appreciated!

Well, Here's my question. In my database I have a form called 'Main Menu'. How can I have this form opened and maximised when Access is run? Thanks in advance!