RE: Coding Help Needed!!
From: Paul B. (PaulB_at_discussions.microsoft.com)
Date: 03/09/05
- Next message: Paul B.: "Access Help"
- Previous message: Sky Warren: "Coding Help Needed!!"
- In reply to: Sky Warren: "Coding Help Needed!!"
- Next in thread: Roland Alden: "Re: Coding Help Needed!!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Mar 2005 12:19:04 -0800
I don't think there is any way of putting two seperate pieces of data into
one field. I'm still learning this myself, so please take this with a grain
of salt.
Why not create a second field for 'Producer2'. Then you could test for a nul
value when you go to figure out if you need to split commissions.
Alternately, maybe you could concatenate the string names into one string. I
don't know if this would work, only a guess, but then you would have to
seperate the string if possible, and then figure out your math for splitting.
Like I said, I'm no expert, just something to think about.
"Sky Warren" wrote:
> Hello all,
>
> I have a table "Application" where sometimes two agents share equally in a
> insurance application. I need to divide percentage between them equally so
> both agents get a fifty, fifty slice.
>
> Right now I have a combo box that I select an agent name from. I can add one
> or the other, but not both agents names without filling out a whole new
> application record.
>
> Here's what I would like to do:
>
> 1. Add first agent into the "Producer" field to create the first record.
> 2. Add second agent into the "Producer" field and make this a second.
>
> I hope I explained this right, and I hope this can be achieved too!
>
> Thanks in advance...
>
> -Sky
- Next message: Paul B.: "Access Help"
- Previous message: Sky Warren: "Coding Help Needed!!"
- In reply to: Sky Warren: "Coding Help Needed!!"
- Next in thread: Roland Alden: "Re: Coding Help Needed!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
