Hi there I'm hoping that someone can help me with this one. It's the first time I've had to create a database and I know zilch about coding so tried to do everything using the wizards within Access 2007 and a book from the library (some of the code from which wouldn't work when I tried to use the particular part of the database so I had to delete it). I had to use lookup fields for some of the tables as I knew that when it came to viewing information in the associated forms my boss would say that loads of numbers rather than words didn't mean anything to him.
The forms are feeding the info into the tables fine but when it comes to the multi-table queries, although they display plenty of information when they are first opened, if the design view is entered and you ask it to just throw up the results for say all those on the books in a certain area who are plumbers, and click the run button, the results screen comes up blank even though on being originally opened several of that trade are clearly showing. I've got no idea what is going on and I spent a good hour or more trying to figure it out while the boss was out of the room, let alone the time I've spent since arriving back home.:banghead:
I did think about using one of those search by form queries but our sales consultants couldn't come to an agreement on what parameters they wanted to search by but said they would want to see a lot more information about each worker as a result. So muggins here is left to try to sort it all out but needs help.
The forms are feeding the info into the tables fine but when it comes to the multi-table queries, although they display plenty of information when they are first opened, if the design view is entered and you ask it to just throw up the results for say all those on the books in a certain area who are plumbers, and click the run button, the results screen comes up blank even though on being originally opened several of that trade are clearly showing. I've got no idea what is going on and I spent a good hour or more trying to figure it out while the boss was out of the room, let alone the time I've spent since arriving back home.:banghead:
I did think about using one of those search by form queries but our sales consultants couldn't come to an agreement on what parameters they wanted to search by but said they would want to see a lot more information about each worker as a result. So muggins here is left to try to sort it all out but needs help.