Hello,
I am sure this is simple but I just can't get it and I have tried...I also did look through the threads here but did not seem to find anything on this so what I am trying to do is this...In my query, I have a field that is giving me the number of business days between a period of time and then I want to subtract that number - the person's PTO time to see the actual days they were available...when I simply type the number in (see below) it works great but I want to set up a prompt that will ask me how many PTO Days to calculate as it will be different for each person I am quering...is this possible?
Days Available: ([Number of Business Days])-28
Thank you for any help with this...I truly appreciate it.
Lilly:banghead:
I am sure this is simple but I just can't get it and I have tried...I also did look through the threads here but did not seem to find anything on this so what I am trying to do is this...In my query, I have a field that is giving me the number of business days between a period of time and then I want to subtract that number - the person's PTO time to see the actual days they were available...when I simply type the number in (see below) it works great but I want to set up a prompt that will ask me how many PTO Days to calculate as it will be different for each person I am quering...is this possible?
Days Available: ([Number of Business Days])-28
Thank you for any help with this...I truly appreciate it.
Lilly:banghead: