Very basic question - Beginner using Access 2000.

[AREKKUSU]

Hi, I'm a student, I need an answer to what I suspect is a very basic question for experts or experienced Access users. I'm creating a basic booking system for a real-life client, a professional singer. I have a table with each gig she takes, with details of how much she will earn, and the date of the gig.

I want to be able to show how much she earns every month, so basically adding up all the booking fees up for each month. I'm pretty sure it's a report made from a query - with the query somehow separating fees earned from month to month. Let me know if you have any ideas...

 

[statsman]

In the booking date field of your query enter the following in the criteria:
Between [Start Date] And [End Date]
Square brackets required.
When you run your query, it will prompt you for a staring date and ending date. Enter these. The query will only return those gigs between the two dates.
From there it should be a simple matter to sum the amounts earned.

 

[kstarnes]

Thanks Statsman! I didn't ask the question, but the answer worked. I just spent an hour trying to get this to work with all sorts of expressions!

 

[AREKKUSU]

Yeah thanks for the reply, it worked fine for me too. Another question, a bit harder I think...

Every gig she performs, she can claim expenses beforehand (e.g. petrol, stage clothes). All possible expenses she could claim for are stored in tbl_expense, with the expense id, expense name, expense description, and amount claimed. I need to have a query (to then make a report), showing the net earnings each month - this is bearing in mind that I have a table of gigs showing how much is earned for each gig.

This is what I needed that last bit of help for, I had to make a query to show the bookings for each month with the fees received. I now need to use that 'filter' for each range of values (or months, i.e. between 01/01/2008 and 31/01/2008, and so on..), as a calculation in a query, adding together fees earned and expenses claimed for each month, to then be shown in a report. Hope i've been clear enough...