Select Statement to VB code

S

Sharon

I want to do a mailing. The first mailing contact for an
account is the CFO or Level 1. If the account does not
have a CFO, I want the letter to go to the PRESIDENT or
Level 2 and so on.

How would you write the following select statement in VB
code for a form? (please be specific in your coding for
this novice)

(SELECT MIN([Level]) FROM tblCombMailCont as X WHERE X.
[account]=[tblCombMailCont].[account])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Ways to put code into a subroutine? 10
If - then query 1
Need help modifying code 0
Select Case Statement with values based on another fields value. 1
Use the " character within a SQL statement embedded in vb code 1
How to find the name of the present subform 7

Top