Recent content by A.M

Thank you so much for your help. Yes Update Query is perfect (just been informed that i shouldn't use Update Query on this occasion as the database is linked to multiple tables, events and resources) - so I've to leave for now as the whole schema would then have to be updated *nightmare*. But...

This is a database which comes off the back of an educational system. The users create events (timetables) and choose from drop down lists (on the timetable system) various options from Event_Category this automatically updates to a database. Now as the system is going to be updated, I need to...

Thank you very much, I will give that a go!

Sorry for not being more specific. 1. I have a column called Event_Category and there are several Event_Category names, i.e. Exam, Pre Entry, Interviews/Assessments and when these have been already been selected and they need to be changed to the name 'Notional'. 2. All the Event_Category...

Hi there, hope you can help. I'm looking to write a query that when you choose a field from a database, if that field is e.g. 'Monday' you can change all the 'Monday's to a 'Tuesday'. Also, if a field is either a 'Mon' or 'Tue' or 'Wed', can these all be changed to a 'December'? (I am not...

Hi there, thanks for letting me into your forum :0) I am from Ireland. My educational background is in I.T. Unfortunately I never seemed to get the hang of programming and right now I'm trying to develop Access Queries to increase my understanding and also incorporate some of these into a...