John-
How are you relating records in the Shipping table to the items shipped? If
there's a link, then the date in the row in the Shipping table gives you what
you need.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John S Moss
Sent: Saturday, November 26, 2011 3:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Staging Table
So have Date field for each item? That seems like an awful lot of the
same dates to be stored. That field would have to be auto-populated
until the user is done with the batch of material. Also, the Date
Shipped needs to be on the Manifest and associated with the Shipping,
Tracking, and Receipt numbers. That's why I had a separate Shipping
Table and why I was thinking of using a separate staging table for
materials being processed for shipping.
On 11/25/2011 3:10 PM, Clive wrote:
>
> Hi John,
>
> You wrote: "I'm using one table to hold all the
> materials shipped or waiting to be shipped."
>
> You can get the 'items waiting to shipped' by using
> a Query and filtering on,
> Where IsNull(tShipped.ShippedDate)
> If you don't have a ShippedDate then they must be
> waiting.
>
> Hope that helps.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "yshopper"
> <jlinux@...> wrote:
> >
> > I have a Shipment table with date shipped, tracking number, etc.
> That's related to the Manifest table - Many Manifests for each Shipment.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "Clive" <zctek@>
> wrote:
> > >
> > > Hi John,
> > >
> > > You must have some way of keeping track. You will need,
> > > at the very least, a Ship Date for a Shipment.
> > >
> > > You will probably need some sort of control on the
> > > filling and storing of boxes to keep track of the
> > > components that go in them.
> > >
> > > It's a bit like Production Control where you have to
> > > keep track of Components, Bills of Materials and
> > > Assemblies.
> > >
> > > Regards, Clive.
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "yshopper"
> <jlinux@> wrote:
> > > >
> > > > I'm not sure if that's feasible. There will be many items per
> box and many boxes per shipment.
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "Clive" <zctek@>
> wrote:
> > > > >
> > > > > Hi John,
> > > > >
> > > > > Do you enter a shipped date when the materials have
> > > > > been shipped?
> > > > > If so then you can find the items waiting to be
> > > > > shipped by the absence of a shipped date.
> > > > >
> > > > > Regards, Clive.
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, John S Moss
> <jlinux@> wrote:
> > > > > >
> > > > > > I posted a few days ago "Database Design Help". I have most
> of it set,
> > > > > > but there's one sticking point I need to resolve. I'm using
> one table to
> > > > > > hold all the materials shipped or waiting to be shipped. I
> was thinking
> > > > > > of using a Check-box to indicate what items were waiting to
> be shipped,
> > > > > > but that's a lot to remember to enter into the form for the
> end user.
> > > > > >
> > > > > > I'm thinking of a Staging table to hold the items waiting to
> be shipped
> > > > > > and then Appending that data to the main table. I need to
> run a Report
> > > > > > for a shipping manifest before Appending. I would like two
> buttons that
> > > > > > will make it easier for the user to do the job.
> > > > > >
> > > > > > Is it possible to run a Report from a button? Any tips
> appreciated.
> > > > > >
> > > > > > Will an Append query just copy the data to the other table
> or can you
> > > > > > tell it to append and delete the data in the Staging table?
> > > > > >
> > > > > > Thanks so much for all the previous help and any to come
> > > > > >
> > > > > > John
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar