Recent content by lizardman2014

That Worked Great thanks! But I now face another challenge and that is now I have all the Info together how to I get it from that query into a linked Mircosoft Excel spreadsheet. So basically when a user updates their table it will update the query and the excel table to be live viewing of...

Hi Simon, Thanks but I am still getting 'Syntax Error in query.Incomplete query clause' Below is the exact union I have. I must still be doing something wrong? Select AFRAME.Time, AFRAME.[Entry Name], AFRAME.[Tote Colour], AFRAME.[Other Details], AFRAME.Location FROM AFRAME UNION ALL Select...

Apologies for the DC (distrubrution centre).. I have tryed to run this code and recevied an Error. I had: SELECT Time, Location, Entry Name, Tote colour, other details FROM Replen UNION ALL SELECT Time, Location, Entry Name, tote colour, other details FROM Promo UNION ALL etc But syntax...

Hi, I really need some help, what I have is a database setup with multiple tables in which different areas of my DC can input information simutanously into their respective tables. I then have another database linked to it for myself to have a live view of each updated record. I would like to...