I am building reports from a 'logistical' database. Part of this database includes items (description and qty) that individuals are signed for. This can be up to 40 different descriptions per person. In another table is the current cost of these items.
What I have been trying to do is create a query where the items from table 1 are merged with the cost from table 2. The intent is to multiple the qty by the cost to get the total value. However, I get NO records out! I have tried every different type of linking between the tables I can think of.
How can I get this to work so I can generate a report showing what HMJ is signed for and the total cost of all these particular items?
Thanks.
What I have been trying to do is create a query where the items from table 1 are merged with the cost from table 2. The intent is to multiple the qty by the cost to get the total value. However, I get NO records out! I have tried every different type of linking between the tables I can think of.
How can I get this to work so I can generate a report showing what HMJ is signed for and the total cost of all these particular items?
Thanks.