Calculating a Date six months in advance of a Date

[speerross]

Not sure if this is actually done with a query (hell, im not sure if it can be done) as my Access knowledge is limited but I've got a list of Patient Appointment Dates and I need to calculate a list of 'Next Appointment' dates that are six months on from the appointment dates not including saturdays and sundays (as the health center is closed those days)

BTW this is for coursework, I don't really work for a health center :S

edit: I seem to have put this in the tables forum, not the queries forum. Apologies for that, I'm not an Idiot, Honest!

 

[ShiftyJaffa]

There are lots of examples on this site regarding working out weekdays between dates. Probably your best route is to create a public function which accepts 2 dates and call that function from within your query, similar example is here

Its always best to search the forums before posting, try searching for 'weekdays', you'll probably find lots more examples.