Hello all,

I help out my dad at a local travel agents and normally run the office side if things. I was informed last week that I needed to supply some information in an access format. I have never used access before so am 100% stumped but luckily I came accross this forum and hopefully with your help I can get round this.

Basically I need to supply the takings for a 3 month period (October, November and December)

They want me to list them including our total income from insurance and bookings.

They then want me to find the amount paid by each customer including the insurance.

Finally I need to find out the ba;ances due on each booking by each customer.

I have all the information and have run some simple queries lately but I havent got a clue about this.

Do I need to set up some kind of formula?

Any help would be most appreciated as I am totally stumped.

Many thanks to any kind fellow who responds!

Thanks,

Gregory :)

So this information is in an existing Access database and you just need to query it?

We'll need more detailed information. What fields does your table contain?

You will want to use a report based on a query for this information, complete with summing.

So this information is in an existing Access database and you just need to query it?

We'll need more detailed information. What fields does your table contain?

You will want to use a report based on a query for this information, complete with summing.

Thanks for the reply RichO.

Ok here is the information.

I have entered all the information into an access database.

I have to sort out the income for our work in October, November and December fields.

I also need to include the "Accomodation code" in the database.

I need to find the total cost from each holiday booking inclusive of personal insurance ie our projected income.

I assume for this i will need to include my "Price" & "Personal Insurance" fields.

Next I need to find out the amount paid by each customer so far including personal insurance.

Assumably I need "Deposit" & "Personal Insurance"

Finally I need to find out the balances due on each booking from our customers.

I think I need to deduct "Insurance" and "Deposit" from the final "Price"

Lastly I need to sort these grouped by "accomodation" codes with sub totals and totals for the above.

I certainly appreciate any further help given!

Many thanks,

Gregory :)

How about a list of all of the fields in your table. Is there only one table or multiple tables linked by primary key?