A
Arichmond
I am new to access so you will have to bear with me. I need to adjust a query
that I have. I am editing an exsiting database that was created to control
company tools. I added a proprietary column in order to see if the tool is
personal or company. I had the query to state only the total net value. Now I
want it to only state the net value if proprietary = company and in another
column to state the net value if proprietary = personal. I am not sure how to
enter this as an expression. The way I have the proprietary set up is with a
seperate table so that it makes a drop down list when you click on the form.
Let me know if you need more info. Thank you, Amber.
that I have. I am editing an exsiting database that was created to control
company tools. I added a proprietary column in order to see if the tool is
personal or company. I had the query to state only the total net value. Now I
want it to only state the net value if proprietary = company and in another
column to state the net value if proprietary = personal. I am not sure how to
enter this as an expression. The way I have the proprietary set up is with a
seperate table so that it makes a drop down list when you click on the form.
Let me know if you need more info. Thank you, Amber.