Search results

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