Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-23-2014, 11:44 AM
Jake0254 Jake0254 is offline Mail Merge Field - Trying to divide time however receiving !Syntax, ; Windows 7 32bit Mail Merge Field - Trying to divide time however receiving !Syntax, ; Office 2013
Novice
Mail Merge Field - Trying to divide time however receiving !Syntax, ;
 
Join Date: Sep 2014
Posts: 1
Jake0254 is on a distinguished road
Default Mail Merge Field - Trying to divide time however receiving !Syntax, ;

Hello



I am merging to a csv dataset and have a field called 'TotalQuantity' and another called TotalPeople

There are currently five sample records in my table...

Total Quantity: 05:00, 05:00, 02:00, 10, 13
Total People: 5, 5, 2, 10, 13

I need to be able to divide the total quantity by total people.. I have created the {= {MERGEFIELD TotalQuantity } / {MERGEFIELD TotalPeople} }

However this returns a Syntax error. Please help!

FYI, if I try and do it on excel, it works. So it isn't a formatting issue that I'm aware of.

Thanks, Jake.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Field - Trying to divide time however receiving !Syntax, ; Mail Merge - Age field jay_son Mail Merge 1 06-30-2014 02:33 PM
time field issue in mail merge Aude Mail Merge 16 05-18-2014 06:22 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail Merge Field - Trying to divide time however receiving !Syntax, ; How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Mail Merge Field - Trying to divide time however receiving !Syntax, ; How big can a mail merge field be? Engineer Mail Merge 2 12-11-2012 01:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft