Search results

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...

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 have a query where i enter a start date and an end date to work out total profits for campsites, i add a chart select the profits query and preview the chart it shows up correct when i enter dates then I finish it when it actually displays the chart it comes up with East, West and North and a...

Im stuck on another query. I need a query that gives me members whos membership is going to run out in a month or under. SELECT tblMember.memberNo, tblMember.dateJoined, tblMember.renewalDate FROM tblMember WHERE (((tblMember.renewalDate)<=Month(Date())-1)) ORDER BY tblMember.memberNo; i...

I need to make a query that displays pitches at a campsite that are not booked for a given date the user enters. I have a tbl which holds pitch info tblPitch and a table which holds booking info tblBooking (see attachment) tblBooking has the pitch number, start date and end date so if theres a...