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, 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
>
Tidak ada komentar:
Posting Komentar