Glad I could help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us
----- Original Message ---- From: Muhamed Faisal <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, November 30, 2007 10:55:11 PM Subject: Re: [ms_access] Pls help me to find a solution for making a query exactly it help me thanking you once more regrds Faisal Riaydh ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED] com> To: [EMAIL PROTECTED] ps.com Sent: Friday, November 30, 2007 8:37:01 PM Subject: Re: [ms_access] Pls help me to find a solution for making a query You will have to use a "Union Query". You can read the help files for details but it kind of goes like this... 1. Go to the design view of a new query. 2. Close the Show Table popup. You will not need that. 3. On the menu bar, you should see the letters SQL. This is the icon to switch the view between Design (which is what you are in, SQL and Datasheet View. We want SQL view 4. You will need some code like this pasted into this window. SELECT PRODUCT1 FROM QUERY1 UNION SELECT PRODUCT2 FROM QUERY2 (Of course you will need to change the query names to match your queries.) Hope this helps. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev. us ----- Original Message ---- From: Muhamed Faisal <muhamed_faisal2000 @ yahoo.com> To: [EMAIL PROTECTED] ps.com Sent: Friday, November 30, 2007 4:49:29 AM Subject: [ms_access] Pls help me to find a solution for making a query DEARS Pls help me to find a solution for making a query i have one query with one filed called "product1" i have onother query with one filed called "product2" now i want to make a new query by sunig this two query i my new query i want disply product1 and product2 continuesely not two separate filed hope you undestand the proble any tips pls regrds faisal ____________ _________ _________ _________ _________ _________ _ Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile. yahoo.com/ sports;_ylt= At9_qDKvtAbMuh1G 1SQtBI7ntAcJ [Non-text portions of this message have been removed] ____________ _________ _________ _________ _________ _________ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs [Non-text portions of this message have been removed] <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font- family:Arial; margin:14px 0px;padding: 0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a; font-size: 85%;font- weight:bold; line-height: 122%;margin: 10px 0px;} #ygrp-mkp #ads{ margin-bottom: 10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff; text-decoration: none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family: Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom: 10px;padding: 0 0;} --> <!-- #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit; font:100% ;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height: 1.22em;} #ygrp-text{ font-family: Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family: Arial; clear:both;} #ygrp-vitnav{ padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin: 25px 0;white-space: nowrap;color: #666;text- align:right; } #ygrp-actbar .left{ float:left;white- space:nowrap; } .bld{font-weight: bold;} #ygrp-grft{ font-family: Verdana;font- size:77%; padding:15px 0;} #ygrp-ft{ font-family: verdana;font- size:77%; border-top: 1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom: 10px;} #ygrp-vital{ background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text-transform: uppercase; } #ygrp-vital ul{ padding:0;margin: 2px 0;} #ygrp-vital ul li{ list-style-type: none;clear: both;border: 1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight: bold;color: #ff7900;float: right;width: 2em;text- align:right; padding-right: .5em;} #ygrp-vital ul li .cat{ font-weight: bold;} #ygrp-vital a{ text-decoration: none;} #ygrp-vital a:hover{ text-decoration: underline; } #ygrp-sponsor #hd{ color:#999;font- size:77%; } #ygrp-sponsor #ov{ padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0; } #ygrp-sponsor #ov li{ list-style-type: square;padding: 6px 0;font-size: 77%;} #ygrp-sponsor #ov li a{ text-decoration: none;font- size:130% ;} #ygrp-sponsor #nc{ background-color: #eee;margin- bottom:20px; padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family: Arial;font- weight:bold; color:#628c2a; font-size: 100%;line- height:122% ;} #ygrp-sponsor .ad a{ text-decoration: none;} #ygrp-sponsor .ad a:hover{ text-decoration: underline; } #ygrp-sponsor .ad p{ margin:0;} o{font-size: 0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120% ;} blockquote{margin: 0 0 0 4px;} .replbq{margin: 4;} --> ____________ _________ _________ _________ _________ _________ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs [Non-text portions of this message have been removed] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
