Hello, i'm new to access and am trying to figure out how i can split lookup values from a table to show individual results on a form.
I've made an example of what i'm trying to accomplish and was hoping someone could help me out with the code portion?
If you run the form and enter a value range of 2017-07-01 to 2017-07-31 it should come back with 6 results..
My question is, HOW do I show the individual results from the total?
I've played around with the IIF and Val commands with no success. help! Thanks..