Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Piemonster
 
Posts: n/a
Default Query Options & Calculations

We have just been upgraded at work to Office 2003 from Office 97 (no training
or manuals on offer). I use mail merge to create bills every month. I have
a few problems with the new mailmerge which I can't figure out:

1. I have a datafile in Excel which includes all clients. However, they do
not all need billing every month. In the old version I used query options to
select those required at month end which was simple (e.g. merge where [field]
= "not blank"). Now the process seems much more complicated. The whole data
source comes up as a dialogue box and I have to manually tick those needed
which is a bit tedious (I do use the deselect all and filter which makes it a
bit quicker). Is there an easier way?

2. It also doesn't seem to let me edit the data source from that point,
which you could before - there is an edit button, it is never active.

3. My datasource in Excel calculates fees and total bill (very simple
formulae - number of hours x hourly rate, etc). All figures entered are to 2
decimal points and formulae results are specified to be 2 decimal points.
However, the merge results ignore decimal rulings and my figures are all over
the place. Is there a way I can specifcy the format of figures and get them
to round up correctly?

Thank you.

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting a Parameter to work in Microsoft Query JohnB Mailmerge 1 May 27th 05 07:01 PM
Receiving calculations from an Access query and rounding off Robert Heinrich Mailmerge 1 April 11th 05 04:48 PM
Can't Open Data Source (Query) where criteria is defined by functi l_stocky Mailmerge 5 January 21st 05 03:01 PM
paste options button no longer visible Wendy Microsoft Word Help 3 January 8th 05 10:31 AM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM


All times are GMT +1. The time now is 03:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"