From one Minnesnowtan to another, follow Crystal's advice.
To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Mon, 28 Nov 2011 00:32:27 +0000
Subject: [MS_AccessPros] Union Query
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]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar