Mailmerge from Access to Word

[Jan]

I am a new user and have created an access database solely for the purpose of
mailmerging letters to Word. I have created a Form for data input and have
created some calculated controls; when data is input all the figures are
correct. On testing the mailmerge the calculations field were blank. I now
realise that the calculation data is not updated in the table. I need these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are merged eg
£285,000 and correctly formatted in Access they have no formatting in Word ie
285000. Can anybody assist please it would be much appreciated. Thanks

 

[Jeff Boyce]

Jan

Try using a query and adding those calculations as new (output) fields in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jan]

Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the calculation.
I used the expression builder to input the calculation in the criteria field
below where I need the correct figure and it returned a zero in all fields.
I obviously am doing something incorrect. Can you point me in the right
direction. Sorry, about this but I am an absolute beginner.

Jan

Try using a query and adding those calculations as new (output) fields in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the purpose
of
mailmerging letters to Word. I have created a Form for data input and
have
created some calculated controls; when data is input all the figures are
correct. On testing the mailmerge the calculations field were blank. I
now
realise that the calculation data is not updated in the table. I need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are merged
eg
£285,000 and correctly formatted in Access they have no formatting in Word
ie
285000. Can anybody assist please it would be much appreciated. Thanks

 

[Jeff Boyce]

Why are you putting the "calculation in the criteria fields"? I thought you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the right
direction. Sorry, about this but I am an absolute beginner.

Jan

Try using a query and adding those calculations as new (output) fields in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data input and
have
created some calculated controls; when data is input all the figures
are
correct. On testing the mailmerge the calculations field were blank. I
now
realise that the calculation data is not updated in the table. I need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are
merged
eg
£285,000 and correctly formatted in Access they have no formatting in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Peter's Software]

... Also when the figures are merged eg
£285,000 and correctly formatted inAccessthey have no formatting in Word ie
285000.  Can anybody assist please it would be much appreciated.  Thanks

The formatting won't get transferred to Word, so you'll need to
include the "£" symbol in the Word document just before the inserted
value.

Hope this helps,

Peter De Baets
Peter's Software - Microsoft Access Tools for Developers
http://www.peterssoftware.com

 

[Jan]

Any suggestions on where I could put the £285,000 (comma) please? Thanks.

 

[Jan]

This is making more sense and I will try it. Another stupid question!! As I
have set up merged fields to my table will I have to build a query with the
fields that I want and use the query as the datasource. Thanks again for your
time.

Why are you putting the "calculation in the criteria fields"? I thought you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the right
direction. Sorry, about this but I am an absolute beginner.

Jan

Try using a query and adding those calculations as new (output) fields in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data input and
have
created some calculated controls; when data is input all the figures
are
correct. On testing the mailmerge the calculations field were blank. I
now
realise that the calculation data is not updated in the table. I need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are
merged
eg
£285,000 and correctly formatted in Access they have no formatting in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Peter Hibbs]

Jan,

You can format the currency field (or any other type of field for that
matter) in the Word document itself which would give more flexibility.
Have a look at :-
http://word.mvps.org/FAQs/MailMerge/index.htm
for instructions on how.

HTH

Peter Hibbs.

 

[Jan]

Thanks Peter will try that.

Jan,

You can format the currency field (or any other type of field for that
matter) in the Word document itself which would give more flexibility.
Have a look at :-
http://word.mvps.org/FAQs/MailMerge/index.htm
for instructions on how.

HTH

Peter Hibbs.

 

[Paul Shapiro]

I didn't see the beginning of this thread, but you can include a computed
column in your mail merge query using the Format() function to output a
formatted currency string. You can specify whatever formatting options you
want, including commas, decimal points, etc.

 

[Jan]

Thank you very much will try this.

I didn't see the beginning of this thread, but you can include a computed
column in your mail merge query using the Format() function to output a
formatted currency string. You can specify whatever formatting options you
want, including commas, decimal points, etc.

 

[Jan]

Hi Jeff. Thank you for your input. I have followed your instructions and
set up the query and all my calculations are now showing in the query. I
used the query as the datasource for a test to merge to word and for some
reason only one of the calculations figure is merging. The other two
calculations are not merging but are all ok in the query. Any ideas as to
why this is occurring. I am self taught so I apologise if I am not seeing the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] – merged ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] – figure correct did not merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] – figure correct did
not merge

Why are you putting the "calculation in the criteria fields"? I thought you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the right
direction. Sorry, about this but I am an absolute beginner.

Jan

Try using a query and adding those calculations as new (output) fields in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data input and
have
created some calculated controls; when data is input all the figures
are
correct. On testing the mailmerge the calculations field were blank. I
now
realise that the calculation data is not updated in the table. I need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are
merged
eg
£285,000 and correctly formatted in Access they have no formatting in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Jeff Boyce]

Jan

So the query now works and generates correct values.

What happens if you export the query (the results, actually) to something
like Excel, then use Word merge against THAT data set?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff. Thank you for your input. I have followed your instructions and
set up the query and all my calculations are now showing in the query. I
used the query as the datasource for a test to merge to word and for some
reason only one of the calculations figure is merging. The other two
calculations are not merging but are all ok in the query. Any ideas as to
why this is occurring. I am self taught so I apologise if I am not seeing
the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - merged ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure correct
did
not merge

Why are you putting the "calculation in the criteria fields"? I thought
you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the
right
direction. Sorry, about this but I am an absolute beginner.
:

Jan

Try using a query and adding those calculations as new (output) fields
in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data input
and
have
created some calculated controls; when data is input all the figures
are
correct. On testing the mailmerge the calculations field were
blank. I
now
realise that the calculation data is not updated in the table. I
need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are
merged
eg
£285,000 and correctly formatted in Access they have no formatting
in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Jan]

Jeff - I could use excel as a backup - just did a test and all figures export
correctly. However, I would hope to find a solution for this as I have about
30 letters to set up used on a regular basis and had now planned to set up a
number of queries with fields for corresponding letters as opposed to having
one query for all letters. But I appreciate your time though. Thank you.

Jan

So the query now works and generates correct values.

What happens if you export the query (the results, actually) to something
like Excel, then use Word merge against THAT data set?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff. Thank you for your input. I have followed your instructions and
set up the query and all my calculations are now showing in the query. I
used the query as the datasource for a test to merge to word and for some
reason only one of the calculations figure is merging. The other two
calculations are not merging but are all ok in the query. Any ideas as to
why this is occurring. I am self taught so I apologise if I am not seeing
the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - merged ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure correct
did
not merge

Why are you putting the "calculation in the criteria fields"? I thought
you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff, Thanks for your response. Funnily enough I have just tried to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the
right
direction. Sorry, about this but I am an absolute beginner.
:

Jan

Try using a query and adding those calculations as new (output) fields
in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data input
and
have
created some calculated controls; when data is input all the figures
are
correct. On testing the mailmerge the calculations field were
blank. I
now
realise that the calculation data is not updated in the table. I
need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are
merged
eg
£285,000 and correctly formatted in Access they have no formatting
in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Jeff Boyce]

First things first ... you have a (convoluted, but) functioning way to get
the merge.

The next place I'd look would be the formatting within the query. Maybe
something about the fields that aren't going is different from the field
that is?

One possibility might be to use the CStr() function to force all text and
numbers into character strings in the query. It may be that Access/Excel
are having trouble handling exporting numbers (vs. text).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff - I could use excel as a backup - just did a test and all figures
export
correctly. However, I would hope to find a solution for this as I have
about
30 letters to set up used on a regular basis and had now planned to set up
a
number of queries with fields for corresponding letters as opposed to
having
one query for all letters. But I appreciate your time though. Thank you.

Jan

So the query now works and generates correct values.

What happens if you export the query (the results, actually) to something
like Excel, then use Word merge against THAT data set?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff. Thank you for your input. I have followed your instructions
and
set up the query and all my calculations are now showing in the query.
I
used the query as the datasource for a test to merge to word and for
some
reason only one of the calculations figure is merging. The other two
calculations are not merging but are all ok in the query. Any ideas as
to
why this is occurring. I am self taught so I apologise if I am not
seeing
the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - merged ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure
correct
did
not merge


:

Why are you putting the "calculation in the criteria fields"? I
thought
you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that
has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff, Thanks for your response. Funnily enough I have just tried
to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the
criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the
right
direction. Sorry, about this but I am an absolute beginner.
:

Jan

Try using a query and adding those calculations as new (output)
fields
in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data
input
and
have
created some calculated controls; when data is input all the
figures
are
correct. On testing the mailmerge the calculations field were
blank. I
now
realise that the calculation data is not updated in the table. I
need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures
are
merged
eg
£285,000 and correctly formatted in Access they have no
formatting
in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Jan]

Hi Jeff, will look up the CStr() function as suggested and try it. Not
sure if this is relevant but could it be because:
[SALE_PRICE]*[COMMISSION_CALCULATE] are fields in my main table and the
other 2 calculations are based on fields that are results - does that make
sense?

FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - fields in table
- merged ok

VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge

TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure
correct did not merge

First things first ... you have a (convoluted, but) functioning way to get
the merge.

The next place I'd look would be the formatting within the query. Maybe
something about the fields that aren't going is different from the field
that is?

One possibility might be to use the CStr() function to force all text and
numbers into character strings in the query. It may be that Access/Excel
are having trouble handling exporting numbers (vs. text).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff - I could use excel as a backup - just did a test and all figures
export
correctly. However, I would hope to find a solution for this as I have
about
30 letters to set up used on a regular basis and had now planned to set up
a
number of queries with fields for corresponding letters as opposed to
having
one query for all letters. But I appreciate your time though. Thank you.

Jan

So the query now works and generates correct values.

What happens if you export the query (the results, actually) to something
like Excel, then use Word merge against THAT data set?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff. Thank you for your input. I have followed your instructions
and
set up the query and all my calculations are now showing in the query.
I
used the query as the datasource for a test to merge to word and for
some
reason only one of the calculations figure is merging. The other two
calculations are not merging but are all ok in the query. Any ideas as
to
why this is occurring. I am self taught so I apologise if I am not
seeing
the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - merged ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure
correct
did
not merge


:

Why are you putting the "calculation in the criteria fields"? I
thought
you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query) that
has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff, Thanks for your response. Funnily enough I have just tried
to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the
criteria
field
below where I need the correct figure and it returned a zero in all
fields.
I obviously am doing something incorrect. Can you point me in the
right
direction. Sorry, about this but I am an absolute beginner.
:

Jan

Try using a query and adding those calculations as new (output)
fields
in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for the
purpose
of
mailmerging letters to Word. I have created a Form for data
input
and
have
created some calculated controls; when data is input all the
figures
are
correct. On testing the mailmerge the calculations field were
blank. I
now
realise that the calculation data is not updated in the table. I
need
these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures
are
merged
eg
£285,000 and correctly formatted in Access they have no
formatting
in
Word
ie
285000. Can anybody assist please it would be much appreciated.
Thanks

 

[Jeff Boyce]

I don't know if that is a factor but you could test this by using the full
expression (instead of referring to the field/control. That is, instead of
using a placeholder name for a calculation, repeat the actual calculation in
your expression.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff, will look up the CStr() function as suggested and try it. Not
sure if this is relevant but could it be because:
[SALE_PRICE]*[COMMISSION_CALCULATE] are fields in my main table and the
other 2 calculations are based on fields that are results - does that make
sense?

FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - fields in
table
- merged ok

VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not merge

TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure
correct did not merge

First things first ... you have a (convoluted, but) functioning way to
get
the merge.

The next place I'd look would be the formatting within the query. Maybe
something about the fields that aren't going is different from the field
that is?

One possibility might be to use the CStr() function to force all text and
numbers into character strings in the query. It may be that Access/Excel
are having trouble handling exporting numbers (vs. text).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff - I could use excel as a backup - just did a test and all figures
export
correctly. However, I would hope to find a solution for this as I have
about
30 letters to set up used on a regular basis and had now planned to set
up
a
number of queries with fields for corresponding letters as opposed to
having
one query for all letters. But I appreciate your time though. Thank
you.

:

Jan

So the query now works and generates correct values.

What happens if you export the query (the results, actually) to
something
like Excel, then use Word merge against THAT data set?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff. Thank you for your input. I have followed your
instructions
and
set up the query and all my calculations are now showing in the
query.
I
used the query as the datasource for a test to merge to word and for
some
reason only one of the calculations figure is merging. The other
two
calculations are not merging but are all ok in the query. Any ideas
as
to
why this is occurring. I am self taught so I apologise if I am not
seeing
the
obvious solution. Thanks.
FEE_AMOUNT_minus_VAT: [SALE_PRICE]*[COMMISSION_CALCULATE] - merged
ok
VAT_AMOUNT: [FEE_AMOUNT_minus_VAT]*[VAT] - figure correct did not
merge
TOTAL_DUE_plus_VAT: [FEE_AMOUNT_minus_VAT]+[VAT_AMOUNT] - figure
correct
did
not merge


:

Why are you putting the "calculation in the criteria fields"? I
thought
you
wanted to see the results of the calculation?

Try adding something like the following in the "field":

NewField: "Can you see me now?"

and running the query.

If that works, then change the text into something like:

NewField: [SALE PRICE]*[COMMISSION]

NOTE: this assumes your query is using a table (or other query)
that
has
two fields named [SALE PRICE] and [COMMISSION]

NOTE2: spelling counts ... in your example, "Commission" didn't
have a
left-square-bracket.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff, Thanks for your response. Funnily enough I have just
tried
to
create a query (first time) and used the fields required for the
calculation.
I used the expression builder to input the calculation in the
criteria
field
below where I need the correct figure and it returned a zero in
all
fields.
I obviously am doing something incorrect. Can you point me in
the
right
direction. Sorry, about this but I am an absolute beginner.
:

Jan

Try using a query and adding those calculations as new (output)
fields
in
the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am a new user and have created an access database solely for
the
purpose
of
mailmerging letters to Word. I have created a Form for data
input
and
have
created some calculated controls; when data is input all the
figures
are
correct. On testing the mailmerge the calculations field were
blank. I
now
realise that the calculation data is not updated in the table.
I
need
these
figures to be merged to Word and have no idea how I can do
this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE
AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the
figures
are
merged
eg
£285,000 and correctly formatted in Access they have no
formatting
in
Word
ie
285000. Can anybody assist please it would be much
appreciated.
Thanks