Recent content by Spirals

Thanks Plog - I was hoping to move away from Excel, even as a front end of sorts. I guess I've picked a really tricky project? But I'm too stubborn to go down that route until I know there's no other option - is there really no means in Access of doing this? Many Thanks, Spirals

Hi Plog, Sorry for the confusion - the DB is normalised, but the reports and queries based on the data need to be structured that way (months along the top, waste types along the side). I need my reports/forms to accommodate variable numbers of columns. When I said 'tables', I meant how the...

Greetings everyone, I apologise if this is a wall of text. I'll try to keep it brief. I took on a project recently to move a heavily automated Excel workbook I'd created to Access. The project is reporting on waste data throughout the city. I have everything set up, but am having great...