tstutting
Last Activity: Aug 19 '06, 04:05 AM
Joined: Aug 6 '06
Location:
-
Try setting the query properties to unique record by right clicking in the upper frame (where your tables are shown) and select properties. Then set the Unique record to Yes. -
Thanks mmccarthy that may be just what I'll have to settle for... I hate settling :). Anyway, I thought I'd mention another way to discribe my objective. I'm basiclly attempting to create a form that looks like a Pivot Table but allows me to modify or create records. If anyone knows how I might accomplish this, please point me in the right direction.
-TrevorLeave a comment:
-
Ok, this will be long since I'm not exactly seeing what you want to do so I'll use my own example.
Table Fruits (Fs) with field Fruit(F) contains Oranges, Apples Grapes and Tomatos
Table Vegies(Vs) with field Vegie(V) contains Potatos, Carrots, Grapes and Tomatos
If I want only what is common between Fs and Vs, I make a query with Table Fs and Table Vs joined F - V using option 1 (double click the relationship...Leave a comment:
-
Employee Schedule
Basicly the form is an unbound Outer Form with Crew (Alapha, Bravo...) and Date (January 06, Febuary 06...) information and Bound SubForms where thier Recordsource will be set using VBA code. Imagin a spreadsheet with employee names in Column A and Columns B-B+30 are the days of the month. Column A is a Subform showing all employees for the month working in Crew X (no duplicates) and Subforms B-XX are the Days of the month...
No activity results to display
Leave a comment: