Kamis, 02 Agustus 2012

[MS_AccessPros] Re: Exporting partial records

 

Hi Clive -

I will be emailing the partial records for them to import into the existing database on a weekly basis.

...funny on the pigeon :)

--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Valerie,
>
> To select records that have not yet been sent,
> you must be using a query to select the records.
>
> In that query you need to add the DateSent field
> and in the QueryGrid for that column put Is Null
> so you select only unsent records.
>
> When you have sent the records you will need to
> update the 'DateSent' field so that they don't
> get selected again when using the same query.
>
> How often are you sending the records? hourly, daily,
> weekly?
>
> I saw your reply to Bill's post. How are you sending
> the information?
> By post on a CD, or paper documents, strapped to a pigeon,
> or via a courier?
>
> Hope that helps.
>
> Regards, Clive.
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar