Mail Merge records off 1 record.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Gilbert - 22 Oct 2003 23:50 GMT

I have a client who has an Access database with 190
fields per record, the first 15 fields are patient
personal info and the remaing 175 are psychiatric testing
variables. He prepares a 29 page report from this.

I setup the first 7 pages of data for him and he was to
setup the remaining 22 pages of data.

Somehow the first 7 pages show the correct info from the
desired record, however the remaining 22 pages show the
data from the next record, i.e. record + 1.

Anyone know a fix or what is happening, out of 10 years
Access experience never have seen this.

Thanks,

Phil Gilbert

Reply to this Message

Phil Gilbert - 23 Oct 2003 00:30 GMT

A little more info, if I right click on the field and
select update field it fill in the correct info, maybe a
switch if off?

>-----Original Message-----
>I have a client who has an Access database with 190
[quoted text clipped - 16 lines]
>Phil Gilbert
>.

Reply to this Message

Phil Gilbert - 23 Oct 2003 01:07 GMT

O.K.

If you select desired records(s), select Edit/Select
All/and press F9 it updates all fields.

I would just like to know why the first seven pages
update the fields automatically as you scroll through
records.

Thanks

>-----Original Message-----
>I have a client who has an Access database with 190
[quoted text clipped - 16 lines]
>Phil Gilbert
>.

Reply to this Message

Doug Robbins - Word MVP - 23 Oct 2003 07:49 GMT

Hi Phil,

It sounds like he might have slipped in a <<Next>> field
on the eighth page.

Please post any follow up to the newsgroups. Unsolicited
questions forwarded directly to me will only be answered
on a paid consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>-----Original Message-----
>I have a client who has an Access database with 190
[quoted text clipped - 16 lines]
>Phil Gilbert
>.

Reply to this Message

Phil Gilbert - 28 Oct 2003 14:10 GMT

>-----Original Message-----
>Hi Phil,
[quoted text clipped - 30 lines]
>>
>.

Reply to this Message