Search results

Rich thank you for all your help. I know ive asked some stupid questions :p One last thing though in a report I want the [Enter start date] and [enter end date] dates to be displayed so a report shows what dates teh user entered any ideas? Once again thank you.

Not a clue what that means or how to do it :p Sorry, all this is really new to me.

Yeah ive tried but get the error 'The Microsoft Jet database engine did not recognize "[Enter start date for total to be calculated]" as a valid field name or expresion.

Thank you so much :D the query works. But another problem now :p my graph... I dont know how to make it so that I have the profits shown, the month the profit is for and some way of knowing which campsite the profit is for. And is it posible to add some text in the header to say what dates...

Its got the tables, the profit query i use and two reports (1 profit report and 1 profit report with graph) i need another report with a graph that gives profits for each month.

Thank you for the help :) still cant get it working though.. :(

Each person has to pay a set amount and under 12's pay half. The pofits are calculated by pitchcost + people cost. How can i group by month?

Also how i enter the dates for the graph how do i show these dates on the report? so that if the user entered 1/1/2003 and 1/1/2004 these dates would be displayed in the header or something.

:D Thank you

'try the name of your date field' Not sure what you mean by this. this is the query the report comes from SELECT [tblCampsite].[campName], sum([peopleCost]*[people+12]+[peopleCost]*([people-12]/2)+[pitchCost]) AS Profits FROM tblCampsite, tblBooking, tblPitch WHERE...

I want a validation rule which makes it so that if a date of birth is entered that means the persons age is under 21 a msgbox pops up. I got the macro setup and this is my code im using Year([dob])>=Year(Date())-21 This only sees if the date entered's year is more than 21 years ago though not...

Right at the moment I open my report and enter a start date and then an end date, my graph is then displayed. I want it to then display January - December and the profits. Sorting and grouping opens Field/Expression Sort order Any ideas what i need to put in? Thank you for you help so far...

Err im not sure what grouping and sorting options are and no idea how to use them.

I need to create a query which will display profits for each month over a year(year entered by user) I have a table which has the booking date and the total is calculated from other attributes. I think i need to select all bookings between [start date] and [end date](entered by user) then some...

I couldnt seem to get that working FoFa.. :confused: (The db included has a different booking table with end dates)

I just want to enter one date that date then returns pitches which are not booked between my booking date and booking end date in the bookings table. Thank you for all the help.. sorry im not explaining very well.

When i set the chart up and before I finish it click on the option to preview it shows correct but when i run the report and in designview it is these place holders.

FoFa I tried that but it returns pitches which shouldnt be still but takes out someone which should be there :confused: Ive included the basics from my database

I've tried that and follwed it as best i could but it returned no results at all :confused: Thank you for the reply.

WHERE ((tblMember.renewalDate) < DateAdd("m",1,Date())) That works, thank you fast response :D Cheers