By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Query/Report

P: n/a
I am lost and would appreciate anyone's help!!

I have to make my current access database do billing. In theory that would
be a * b = c, but I have a lot of variables and no idea how to program this
to make it work.

Table 1 - Rate Table
Customer Rate Commodity
ABC Co $225 Twine
ABC Co $500 Burlap
Widget Inc $200 Plywood

Table 2 - Inventory
Customer Warehouse Receipt Description
ABC Co 113456 Treated Burlap Squares

I need to have a query or a report be able to know that the charge for
warehouse receipt #113456 is $500 and I have no idea how to get from this
info to access knowing that answer. If there were only one option per
customer, I could figure it out but since there will be multiple rates per
customer depending on the commodity, I have no idea how to get Access to
recognize the commodity from the description in the Inventory table and then
report that info back out onto an invoice.

Anyone have any ideas??

Thanks so much for your time!
Christine

--
Message posted via http://www.accessmonster.com

Nov 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Based on the information you gave, you don't have any way to tie your
two tables together to get the information you want. The only field
that is common to both is the customer and if you link those fields in
a query, you are going to get all the matching rows. In order for you
to determine how much a receipt is for, you should be using the Receipt
Number in both tables, not the Customer.

Hope that helps!
Takayla via AccessMonster.com wrote:
I am lost and would appreciate anyone's help!!

I have to make my current access database do billing. In theory that would
be a * b = c, but I have a lot of variables and no idea how to program this
to make it work.

Table 1 - Rate Table
Customer Rate Commodity
ABC Co $225 Twine
ABC Co $500 Burlap
Widget Inc $200 Plywood

Table 2 - Inventory
Customer Warehouse Receipt Description
ABC Co 113456 Treated Burlap Squares

I need to have a query or a report be able to know that the charge for
warehouse receipt #113456 is $500 and I have no idea how to get from this
info to access knowing that answer. If there were only one option per
customer, I could figure it out but since there will be multiple rates per
customer depending on the commodity, I have no idea how to get Access to
recognize the commodity from the description in the Inventory table and then
report that info back out onto an invoice.

Anyone have any ideas??

Thanks so much for your time!
Christine

--
Message posted via http://www.accessmonster.com
Nov 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.