Mail Merge records off 1 record.

[Phil Gilbert]

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

 

[Phil Gilbert]

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?

 

[Phil Gilbert]

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

 

[Doug Robbins - Word MVP]

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

 

[Phil Gilbert]

-----Original Message-----
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
.