By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,548 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

create index and mail merge

100+
P: 114
I’m a Access newbie. Have a ASCII flat file that is tab delimited. Access imports this file without any problems. I need to create a key field using data found in another text field. The field was created by an old application that placed an order number in the field (exam: “Order #: 123456”) and is not static as to location within that field.

Could someone tell me how and what I should do to solve this or steer me to documentation.

Also need to find example of script/instruction on how to feed Word with selected keys from a query using this Access database and print a mail merge document filled in using a basic template.

Thanks in advance
Dec 8 '06 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,660
I’m a Access newbie. Have a ASCII flat file that is tab delimited. Access imports this file without any problems. I need to create a key field using data found in another text field. The field was created by an old application that placed an order number in the field (exam: “Order #: 123456”) and is not static as to location within that field.

Could someone tell me how and what I should do to solve this or steer me to documentation.

Also need to find example of script/instruction on how to feed Word with selected keys from a query using this Access database and print a mail merge document filled in using a basic template.

Thanks in advance
Is the field that contains the OrderNumber always the same?
What do you know about the contents - what can be used to identify which part of the field is OrderNo and which is not?
Dec 8 '06 #2

100+
P: 114
Yes the field that contains the OrderNumber is always the same. It is within a memo field. The order number is always preceded with the text "Order Number : " followed by six numeric characters that make up the order number. For some reason the order number was not a tab delimited field but was placed within this memo area, why I don't know.

That info in that area can be left there, I just want to pick it up and create a field that I can use as a key.
Dec 11 '06 #3

NeoPa
Expert Mod 15k+
P: 31,660
I should be able to help here with something but tied up working atm.
If you can wait, I'll look at it later today.
Dec 11 '06 #4

100+
P: 114
No problem, would like to work with it on Wednesday if that OK. Thanks much
Dec 11 '06 #5

NeoPa
Expert Mod 15k+
P: 31,660
Assuming the memo field is named MemoField then you want something like :
Expand|Select|Wrap|Line Numbers
  1. SELECT Mid([MemoField],InStr(1,Nz([MemoField],''),'Order Number : ')+15,6) AS OrderNumber
  2. FROM ...
Don't have any info for the rest so you'll have to add my bits into your own query.
Dec 12 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.