I have a database whose purpose is to gather and query data from identical linked tables with the same field names. The current process is this:
I have a macro that deletes all data from a temporary table.
I have an input form that the user lists items from one field to get the appropriate records.
I run a union query to gather all the data from all the linked tables.
I run a query to ensure that I get all records listed by the input form.
I then run an append query to append the new data to the temporary table.
That temporary table data is displayed on a form that I use to add some new data into. This data is added into three different tables within the database.
Finally I run a report from the temporary table to sum up all of the work done.
To equate to real world the tables represent inventory lists in different locations, all with unique identification numbers. I have the database pull up all the information from all the tables and the user types in the id numbers they are looking for. Then once they have that data, they add three new bits of information such as where they want it delivered, how many they want and when they want it. I then present a report that is sent to the shipping department to take action.
All that to describe the problem. For some reason or another that I cannot find, I am always one record short on the query. I am using a simple
[Forms]![PCMKIF]![pcmk1] Or [Forms]![PCMKIF]![pcmk2] Or [Forms]![PCMKIF]![pcmk3] Or [Forms]![PCMKIF]![pcmk4]
statement on the query. If I list 3 items on the input form, I get two results. If I list 4 items on the input form I get 3 results.
I have temporarily overcome this by adding a hidden input form box with a default value that will never be used by the inventory system. This allows me to get the right output each time. I would simply like to know what it is I am missing for my own sanity. Thank you for your help and time.
I have a macro that deletes all data from a temporary table.
I have an input form that the user lists items from one field to get the appropriate records.
I run a union query to gather all the data from all the linked tables.
I run a query to ensure that I get all records listed by the input form.
I then run an append query to append the new data to the temporary table.
That temporary table data is displayed on a form that I use to add some new data into. This data is added into three different tables within the database.
Finally I run a report from the temporary table to sum up all of the work done.
To equate to real world the tables represent inventory lists in different locations, all with unique identification numbers. I have the database pull up all the information from all the tables and the user types in the id numbers they are looking for. Then once they have that data, they add three new bits of information such as where they want it delivered, how many they want and when they want it. I then present a report that is sent to the shipping department to take action.
All that to describe the problem. For some reason or another that I cannot find, I am always one record short on the query. I am using a simple
[Forms]![PCMKIF]![pcmk1] Or [Forms]![PCMKIF]![pcmk2] Or [Forms]![PCMKIF]![pcmk3] Or [Forms]![PCMKIF]![pcmk4]
statement on the query. If I list 3 items on the input form, I get two results. If I list 4 items on the input form I get 3 results.
I have temporarily overcome this by adding a hidden input form box with a default value that will never be used by the inventory system. This allows me to get the right output each time. I would simply like to know what it is I am missing for my own sanity. Thank you for your help and time.
