Hi,
I am very new to access and my question is 2 fold:
1 - Is it possible to 'grey out' a drop down section of a form if another section has been selected?
If not,
2 - I need to write a query that counts the number of entries in column A, column B and shows the relevant dollar value. This is working fine except in cases where the user puts an entry in both A and B. In this case, we only want to count column A as per below:
- if column A null and column B has an entry, return 1 count and dollar value for column B
- if column B null and column A has an entry, return 1 count and dollar value for column A
- if column A has an entry and column B has an entry, return 1 count and dollar value for column A only
I can't attach the db as it contains customer sensitive information. Is anyone able to help based off this email?