MattioMatt
Registered User.
- Local time
- Today, 06:54
- Joined
- Apr 25, 2017
- Messages
- 99
I have a crosstab query which I am using my forms record source.
The query itself looks like this:
Month | Low | Medium | High | Very High |
February 2018 0 5 1 2
January 2018 0 4 2 6
I've used the statuses as column headers as that is what I wanted my text boses to be populated with. So I'm using the headers as the control sources of my text boxes on the form.
The form I've built has a combobox to select the month I'd like to view data for. However what I'd like to do is be able to have two combox boxes and some more text boxes so you can view data for one month and then compare it against another month. Is there a way of doing that? Can I get this to work in a query to then use on the form?
I hope I'm explaining what I'm trying to well enough.
The query itself looks like this:
Month | Low | Medium | High | Very High |
February 2018 0 5 1 2
January 2018 0 4 2 6
I've used the statuses as column headers as that is what I wanted my text boses to be populated with. So I'm using the headers as the control sources of my text boxes on the form.
The form I've built has a combobox to select the month I'd like to view data for. However what I'd like to do is be able to have two combox boxes and some more text boxes so you can view data for one month and then compare it against another month. Is there a way of doing that? Can I get this to work in a query to then use on the form?
I hope I'm explaining what I'm trying to well enough.