Search results for query: *

Neil, i fixed the query like below, and still get the same error "Wrong # of argument used with function in query expression fConcatFld("MainTable","SS","PHARMACY","string",[SS])". What should i do? Select...

Neil, Thanks a lot for your time. I follow your instruction, but i got errors"Wrong # of argument..". I kind of new to vba coding, so if you can point my mistake, i have the copy of the code below: my MainTable contain [SS] and [PHARMACY] the query: SELECT MainTable.SS...

Fae, the data source is from ms access 2000 to word 2000 mail merge. I did check out the article that Peter Moran refer to. It helped alot but since my data from access look like this: name project john 125x john 254w john...

Thanks a lot for all your help!

what can i do to produce letter merge that look like this: <000-00-0000>......<pathmark>, <shoprite>, <stop&shop> .... <111-11-1111>......<a&p>, <wawa>.... from the data source look like this: SS# store name 000-00-0000 pathmark 000-00-0000 shoprite 000-00-0000...

Does anyone know how to mark the last record of a group. ex: john doe made 3 order, i need to indicate the last record for john doe. customer order Indicator john doe 125 john doe 245 john doe 524 1 jane doe 536 jane doe 824 1