New to Access-Grouping in Form Question

[ChadDiesel]

I'm new to Access and need some advice. I am trying to setup a database to
print labels and reports for our shipments. I have set up a table with
fields such as

I have taken a snapshot of what I would like to do:

http://www.chadworld.com/images/form.jpg

All of these fields are in a table called: Ship_Info

I would like to type in the Destination, Load ID, Ready to Ship, Ship Date
and BOL# at the top of the screen, and, I would like to type in information
for a list of boxes associated with the Load ID at the top in the middle
subform. I would like the Destination, Load ID, Ready to Ship, Ship Date
and BOL# at the top to also transfer to the Ship_Info table without having
to retype them for each box I type. I would like to scroll with the bottom
record control through the Load ID at the top and have it show each list of
boxes for that shipment. I might be working on 2 shipments for the San
Diego called SD1 and SD2. I would like to flip back and forth between them
on the form so I can add more boxes as needed.

I saw something similar to this in another database I was looking at, but it
was using multiple tables. It was using forms and subforms, but I'm not
sure how to set the Link Child and Link Master properties.

As I said, I am very new to Access, so I might not be on the right track at
all. If you have an alternate suggestion, please let me know. I don't know
much about programming and have been trying to mainly use menus and the
expression builder. Any help would be greatly appreciated.

Thanks,

Chad

[Rog]

You need to use two tables, one with the shipping info - for your main
form - where LoadID is the record key (index), and which has
Destination, Ready to ship, Ship date and BOL# as fields. Your second
table should contain parcel data for your subform. This second table
should also contain the field LoadID so that the two tables can be
linked.

[ChadDiesel]

I'm new to access and need some help.

I have a form with a shipment destination at the top. I then have a subform
that I enter boxes for that shipment. I have several shipments going at a
time, so I can use the control at the bottom of the form to move from
shipment to shipment and I can see all the boxes in each shipment.

I'd like to put a subtotal for the shipment weight and box types at the
bottom of the subform.

I placed =Sum([Weight]) in the footer of the subform and it works fine.
When I switch to the next shipment, it shows a total for just that
shipment-just what I want.

The problem is with text values. I want to have running total of each type
of box I have. I have a field called Box_Type that contains text values
like Assembly Box, Regular Box, Small Box, etc. I would to have running
totals in the footer like this:

Total Assembly Boxes:

Total Regular Boxes:

Total Small Boxes:

These are text values, so I need to count every time the value is "Assembly
Box" for example.

I tried to use the Dcount function with the value = "Assembly Box", but it
gives me a total for the entire table and not just the shipment. I guess
this is because you have to specify the table in the conditions.

What I was thinking is to use the =Count([Box_Type]) with some kind of
condition that it counts "Assembly Box" or whatever other types.

I'm new to Access, so I might not be using the right terminology or going at
the problem the right way. Any information would be appreciated.

Thanks,

Chad

"Rog" <de********@state.gov> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

You need to use two tables, one with the shipping info - for your main
form - where LoadID is the record key (index), and which has
Destination, Ready to ship, Ship date and BOL# as fields. Your second
table should contain parcel data for your subform. This second table
should also contain the field LoadID so that the two tables can be
linked.

[ChadDiesel]

Thanks. That worked great. I appreciate the help.

Chad
"Rog" <de********@state.gov> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

You need to use two tables, one with the shipping info - for your main
form - where LoadID is the record key (index), and which has
Destination, Ready to ship, Ship date and BOL# as fields. Your second
table should contain parcel data for your subform. This second table
should also contain the field LoadID so that the two tables can be
linked.