Re: Using Multiple Check Boxes/Data Structure Issue
- From: "hawk_2001 via AccessMonster.com" <u41550@uwe>
- Date: Tue, 31 Mar 2009 12:33:37 GMT
Thanks for the help/suggestions. I have set up a three field table as you
suggested. I am well on my way to achieving my desired results. Thanks
again.
John W. Vinson wrote:
Have a question that I can't seem to work through on my own.[quoted text clipped - 23 lines]
I am looking for any suggestions to help get this customized reporting
together.
If the rate depends on two factors - the weight category and the distance -
then I'd suggest a three field table with fields for WeightCategory, Distance,
and Rate. You can use a Form with combo boxes to select the appropriate
category and distance, and base your report on a query using these combo boxes
as criteria to select the appropriate rate.
What you should NOT have is a table with multiple checkbox fields, or multiple
rate fields, in each record.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200903/1
.
- References:
- Using Multiple Check Boxes/Data Structure Issue
- From: hawk_2001 via AccessMonster.com
- Re: Using Multiple Check Boxes/Data Structure Issue
- From: John W . Vinson
- Using Multiple Check Boxes/Data Structure Issue
- Prev by Date: Re: Posting Question
- Next by Date: Pivot table cropped on the form
- Previous by thread: Re: Using Multiple Check Boxes/Data Structure Issue
- Next by thread: Invalid Use of Null, Control Wizard Button
- Index(es):
Relevant Pages
|
