C
Caroline
I have a report based on a query right now that takes one Line of Business
and gives all the data associated with that. It gets the one Line of Business
from a prompt that I put under criteria, and it works fine.
Now I am trying to add something so users can add more than one Line of
Business. I thought about putting [LOB 1:], [LOB2:], etc under criteria but I
don't want the user to have to click through all of the LOBs if they only had
to do input one. In fact, I tried it, and once I clicked through all of them
I got all of the data back unless I wrote the same Line of Business in every
prompt.
Then I thought about making a form with tick boxes, and when the tick boxes
are ticked, it sets the criteria for the query. However, after much googling,
I am unsure of where to start. I can't even figure out how to make tick boxes
that check the details inside the field. For example, the field name is LOB,
but that includes Chile, Australia, etc. I want Chile, Australia to be the
names of the tick boxes and what it references. There are thousands of
records but only about 6 Line of Businesses.
Let me know if this is possible or if I am in way over my head. I am only a
beginner Access user...thanks!
and gives all the data associated with that. It gets the one Line of Business
from a prompt that I put under criteria, and it works fine.
Now I am trying to add something so users can add more than one Line of
Business. I thought about putting [LOB 1:], [LOB2:], etc under criteria but I
don't want the user to have to click through all of the LOBs if they only had
to do input one. In fact, I tried it, and once I clicked through all of them
I got all of the data back unless I wrote the same Line of Business in every
prompt.
Then I thought about making a form with tick boxes, and when the tick boxes
are ticked, it sets the criteria for the query. However, after much googling,
I am unsure of where to start. I can't even figure out how to make tick boxes
that check the details inside the field. For example, the field name is LOB,
but that includes Chile, Australia, etc. I want Chile, Australia to be the
names of the tick boxes and what it references. There are thousands of
records but only about 6 Line of Businesses.
Let me know if this is possible or if I am in way over my head. I am only a
beginner Access user...thanks!