You have placed three tables in one query and have not related the tables to each other. There are no joins. With this type of query you will end up with a cartesian result. I believe that from what you indicated in your first thread you wish to have three different queries. I cannot build them for you, because I don't know what you want as results. Which fields from each table are to be included? Currently, you only have one field selected. What information is needed for each query.
Now to the meat of your db design. Why do you have three tables? The information in each appears to be the same or very similar except for the status. Why not have one table with a field for status and in that field you can identify Cancelled, Closed or Dispatch. You then only have to query one table and change the status criteria. I urge you to make this change early in the design as it will continue to prove problematic as you get further along in your db.
Your combo box SQL statement needs to be changed to
In the properties for the combo box, on the format tab, change column count to 1 and change column widths to 1". On the data tab, your bound column should be 1. This will resolve the error message, but your query would still fail as noted above in the first paragraph.
Suggest you read the next link carefully. It is on proper set and design of databases.
http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
If you wish to work effectively with Access, then you need to learn how to design a data base that will be efficient. Access is not as intuitive as Excel. I urge you to get a book and learn step by step. Once you have a good understanding, then you can venture into the world of development.
Additionally, you need to change the names of the queries in the List to Cancel, Dispatch and Closed. They cannot have the same name as your tables.
Bookmarks