Access SQL Help

[guggu]

Hi Guys,
I am new at this and am not one that really knows MS Access.
I have an issue where we have recently upgraded our MS Office versions from Office 2000 to Office 2007. We have a query that seems to be linked to many other queries and takes a while (many minutes) to run.
We have not upgraded the database and when you run one particular query it seems to start but never finished using access 2007 when the database is in campatibility mode for 2000.
I have tried to convert the database from 2000 to 2007 and it seems as if it has done this but leaves a screen as if it has frozen and I left this on overnight and it was still in the frozen state in the morning. I then ended the task and ran a few queries and they all worked except for the one I was having issues with.
So my point is is the something wrong with this query?

 

[Galaxiom]

Please excuse my strong words but that is a hideous query from a badly structured database. Radically rethink your data structure.

The query is far too complex to hope to troubleshoot especially when it has not been formatted into a readable layout.

You are relying far too much on IIF functions when you could be using related tables.
For example the displayed messages should be held in tables and related to the codes rather than embedded in the query.

Shorten the table names. The names should be meaningful but not read like a short story. Avoid including spaces, special characters or words like AND in names.

I also suspect there will normalization issues.

 

[guggu]

Thanks,
Not that I know how to do what you have suggested but thanks for the reply.

 

[Galaxiom]

I would suggest posting your table structure and a short description of the goals.