Kevin Sims
Last Activity: Sep 8 '11, 12:55 PM
Joined: Oct 19 '10
Location:
-
I realized I need to give more info here. My access database is actually linked to another database. In the other database, the only ID that is on each asset it the Unit and not the group. So you are correct, Group is NOT recorded in a table and for that matter neither is the Unit name in my database. Now, how should I build tables and how many? One for Groups and one for Units? Please help clarify for me. Thanks! -
I guess I'm still not clear what you mean. The table I currently have has the following: a Group Number and the Units contained in that group;
GROUP UNITS
"Group1" "("Unit 04" or "Unit 07" or "Unit 08")"
etc....
I have the form looking at this table. Should I just not be using this table at all? I am just very confused by what you are saying.....Leave a comment:
-
Maybe not...how would I in turn use this as the criteria for my query? If I set it up to do just one unit, the query returns exactly what I am looking for on just that one unit. I created the table with groups in an attempt to be able to select multiple units on the form which belong to those assigned groups.
I know I can type into the criteria of the query manually ("Unit 04" or "Unit 07" or "Unit 08"),...Leave a comment:
-
Help With Query using Form referencing table with group of items
Hopefully the title makes enough sense to get my point across.
Using Access 97 here.
I am trying build a query which uses a form to select the criteria. It works fine if the source contains just one item.
Here is the criteria example:
=([Forms]![frmRETIREMENT_R EPORT]![cboUNIT])
Problem is the table I am referencing from cboUNIT is setup into groups and each group contains multiple items....
No activity results to display
Leave a comment: