Search results

I am trying to execute the crazy query below with multiple left joins because of the data I am trying to get back. The weird thing is sometimes it work and then sometimes it gives me a join expression error. It seems that access strangely removes brackets around the ON clauses. However even when...

I am working on a database at work which at present is just one table and I think it would be better as 4. Is there an easy way to change the underlying structure of the database or would I be better creating a new database and if yes how would I migrate the current data? Any ideas gratefully...

Hello from Viv in York, UK. I am not new to Access Databases but haven't used one for a looooooong time so class myself as a newbie. I am a computer programmer by trade by have been home edding my kids for the last 13 years and have only just started working (very part-time) over the last few...