Senin, 28 November 2011

Re: [MS_AccessPros] Union Query

 

thanks, Duane :)

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: Duane Hookom

Bill,
From one Minnesnowtan to another, follow Crystal's advice.

ill.Singer@at-group.net

      I have found that a UNION Query will allow me to see all 6 pieces of information from six different colums of information in one place. I have an insurance carrier that writes Life Insurance, Short Term Disability Insurance, Long Term Disability Insurance and Dental Insurance. I have the Carrier Name for each of these lines of insurance stored in seperate colums of a table. I want to view them all in one form at one time and the UNION QUERY will do that just fine... except I want to be able to edit the commission information in the UNION QUERY all on one form. The UNION QUERY will not let me edit. Does anybody have any ideas how to pull all six pieces of information together and show it on one form and have the ability to edit it?

I hope my question is clear.

Thanks,

Bill in MN, where the cold means it is programming season.

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar