If this correct use of Select

Hi there

I want to use the following statement in the RowSource for a report but am 
unsure of whether it's correct:

SELECT *, *
FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] = 
T_General[StudentID_FK]; 

Does this look correct to anyone?

Thank you in advance for your help.
0
Utf
6/5/2010 2:29:32 AM
access.modulesdaovba 1670 articles. 0 followers. Follow

3 Replies
804 Views

Similar Articles

[PageSpeed] 13

On Fri, 4 Jun 2010 19:29:32 -0700, forest8 <forest8@discussions.microsoft.com>
wrote:

>Hi there
>
>I want to use the following statement in the RowSource for a report but am 
>unsure of whether it's correct:
>
>SELECT *, *
>FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] = 
>T_General[StudentID_FK]; 
>
>Does this look correct to anyone?

Not really. The SELECT * syntax means to select all fields (from all tables);
so by using the asterisk twice you're saying SELECT each field twice. I expect
Access will assign an alias fieldname to one of the duplicates. The RIGHT JOIN
will cause all records in T_General to be included, whether or not they have a
match in T_Participants; if they do have a match you'll get all the field
values in T_Participants, otherwise those fields will be in the report's
recordsource with NULL values.

Could you explain what fields are in the two tables, and what you intend this
query to accomplish?
-- 

             John W. Vinson [MVP]
0
John
6/5/2010 5:54:27 AM
I was planning on using the select in the rowsource of a report.



"John W. Vinson" wrote:

> On Fri, 4 Jun 2010 19:29:32 -0700, forest8 <forest8@discussions.microsoft.com>
> wrote:
> 
> >Hi there
> >
> >I want to use the following statement in the RowSource for a report but am 
> >unsure of whether it's correct:
> >
> >SELECT *, *
> >FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] = 
> >T_General[StudentID_FK]; 
> >
> >Does this look correct to anyone?
> 
> Not really. The SELECT * syntax means to select all fields (from all tables);
> so by using the asterisk twice you're saying SELECT each field twice. I expect
> Access will assign an alias fieldname to one of the duplicates. The RIGHT JOIN
> will cause all records in T_General to be included, whether or not they have a
> match in T_Participants; if they do have a match you'll get all the field
> values in T_Participants, otherwise those fields will be in the report's
> recordsource with NULL values.
> 
> Could you explain what fields are in the two tables, and what you intend this
> query to accomplish?
> -- 
> 
>              John W. Vinson [MVP]
> .
> 
0
Utf
6/6/2010 2:50:04 AM
On Sat, 5 Jun 2010 19:50:04 -0700, forest8 <forest8@discussions.microsoft.com>
wrote:

Fine; what's in the table, and what do you want to see in the report? 

Remember *you* can see your database. I cannot.

>I was planning on using the select in the rowsource of a report.
>
>
>
>"John W. Vinson" wrote:
>
>> On Fri, 4 Jun 2010 19:29:32 -0700, forest8 <forest8@discussions.microsoft.com>
>> wrote:
>> 
>> >Hi there
>> >
>> >I want to use the following statement in the RowSource for a report but am 
>> >unsure of whether it's correct:
>> >
>> >SELECT *, *
>> >FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] = 
>> >T_General[StudentID_FK]; 
>> >
>> >Does this look correct to anyone?
>> 
>> Not really. The SELECT * syntax means to select all fields (from all tables);
>> so by using the asterisk twice you're saying SELECT each field twice. I expect
>> Access will assign an alias fieldname to one of the duplicates. The RIGHT JOIN
>> will cause all records in T_General to be included, whether or not they have a
>> match in T_Participants; if they do have a match you'll get all the field
>> values in T_Participants, otherwise those fields will be in the report's
>> recordsource with NULL values.
>> 
>> Could you explain what fields are in the two tables, and what you intend this
>> query to accomplish?
>> -- 
>> 
>>              John W. Vinson [MVP]
>> .
>> 
-- 

             John W. Vinson [MVP]
0
John
6/6/2010 8:17:46 PM
Reply:

Similar Artilces:

Watch this corrective update that came from Microsoft Corporation
--onkdsuysvvng Content-Type: multipart/related; boundary="bfbhdbklwehwbiu"; type="multipart/alternative" --bfbhdbklwehwbiu Content-Type: multipart/alternative; boundary="ampkwllbdcvecaddz" --ampkwllbdcvecaddz Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Consumer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install n...

Debit Cards and NOT using Citibank
We are in the process of trying to take debit cards and use ICVerify and First Data as our credit card processor. It wasn't until I did a test last night from RMS and researched the message I received that RMS only supports debit cards if you are using the built-in Citibank credit card processing. Is there anyway around this? If not, is RMS going to remove this restriction at some point? -- John M. You should be able to process debit cards by opening ICVerify and processing them directly. You would need to set up your debit card tender type in RMS as "Other". This isn...

Payroll corrections after Payroll Year is closed
I have a client who closed their payroll year and issued W2s. Now, they've realized that because the last payroll of 2008 was printed on 12/31 but not distributed until January 2nd, it needs to fall into 2009 for wage reporting purposes. My first thought to correct this was to void the checks from the last payroll and re-issue them but I've discovered GP won't let you do this once the payroll year has been closed. Has anyone ever run into this scenario and if so, how was it corrected? Thx, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www....

Taste corrective patch
--zncknrruviimfhh Content-Type: multipart/related; boundary="nqkfxcjees"; type="multipart/alternative" --nqkfxcjees Content-Type: multipart/alternative; boundary="iqpjepqzbj" --iqpjepqzbj Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Partner this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to protect your...

Accessing Custom entities using webservice
Can anyone tell me if it is possible to access custom entities using a webservice. I am trying to create an instance of a custom entity that has already been established in the CRM. Thanks. ...

Using Friendly Ghost Language
I'm attempting to print an Access report to a BOCA thermal printer that normally uses Friendly Ghost Language (FGL). I get the data to the printer but nothing prints. Any suggestions? -- ARMORinAK You need to have the correct driver loaded for the printer. If you don't have the installation CD, you may be able to download a driver from the web. "ARMOR" <ARMOR@discussions.microsoft.com> wrote in message news:16A00865-A484-404C-9D56-207B6FFD99AA@microsoft.com... > I'm attempting to print an Access report to a BOCA thermal printer that > normally uses F...

Use DirectX Headers and Libs ?
Hi guys, When I installed the DirectX SDK (9.0c) it automatically added the header and library directories. If I am making a regular MFC application should I remove them from the list, or maybe move them to the bottom ? And also, for a regular MFC app should I make sure the Platform SDK directories are at the very top (even though they are older then the DirectX ones) ? Any guidence is appreciated. I'm using VC++ 6.0 (SP5) on XP Pro. Thanks, Robert A. You should have no problems with that - you can leave them at the top, there should be no conflicts. Or are you actually having probl...

Can you calculate delta time using different entries
I import information into excel that includes a timestamp in hh:mm:ss AM/PM format. Is there a way to caluclate delta time between different events? Thanks in advance. Hi, It's done by subtraction =B1-A1 Format as H:MM:SS -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ed" wrote: > I import information into excel that includes a timestamp in hh:mm:ss AM/PM > format. Is there a way to caluclate delta time between different ...

101 Other Uses Of Condom.exe (7/7)
=ybegin part=7 line=128 size=1593921 name=101 Other Uses Of Condom.exe =ypart begin=1497601 end=1593921 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-����J�haak�]w���...

Emails correct sent?
Hallo, Sometimes when i am forwarding a mail to somebody the mail in the map "messages send" is seen as send to myself? So, i am not sure if the person has really received the mail. Regards Huib That is an indication that a problem occurred during the send(process interrupted by user, the ISP, or an AV client are a few of the causes) - The message may have been sent and received(only the recipient can verify if delivered). - WLM creates that message in that form just in case you need to recover the contents and recreate the message -- ...winston ms-mv...

Import auto correct to Word 2007
I am a lousy typist. I am switching from Word 2003 to Word 2007. Is there a simple way a non tech guy like me can export my auto correct setting to Word 2007 without risking screwing up everything? The simpler the solution, the more grateful I will be! Thanks. Hello, On 2010.01.21 17:38, in article 9F0A4A5F-9136-4F3C-8079-520E1A1D93E5@microsoft.com, "ShivN" <ShivN@discussions.microsoft.com> wrote: > I am a lousy typist. I am switching from Word 2003 to Word 2007. Is there a > simple way a non tech guy like me can export my auto correct setting to Word...

Using function IF in WORD 2003
Why the following example does not work? Example: Bookmark "town" has value "Pasco" {IF town = Prague "Not true" "{IF town = Pasco "True" " "} "} The outcome of this function is "{IF town = Pasco " but I am expecting outcome "True". That means the word does not take into account another nested function IF. I am trying to use nested function "If" because I saw this example in Word 2003 help where nested If is used (I thought that it will work): {IF {MERGEFIELD Město} = "Brno"...

correction
What is process "tkupd32.exe"? Safe to end process? It's pegging my processor at 100% utilization. Thx. Looks like it is something to do with Groupshield, and there is a hotfix: http://ktp.e-isa.com/Downloads/McAfee/Patches/GroupShield/Hotfix7.txt -- Mark Fugatt Microsoft Exchange MVP www.exchangetrainer.com www.msexchange.org "jallen" <anonymous@discussions.microsoft.com> wrote in message news:08e501c3c963$a59beaf0$a401280a@phx.gbl... > What is process "tkupd32.exe"? Safe to end process? It's > pegging my processor at 100% utilization. ...

Using RMS on a Palm
Be able to use RMS from a Palm to receive inventory. Scan - Match PO - and Up-date info on the server by syncronization. Any PALM-RMS customizated software ? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroup...

resize picture in Word using VBA
I am writing a usermanual with many screencaptures. I insert them as device independant bitmap. Every screencapture needs to be resized to a standard width, needs to get a blue line around it and needs to get centered on the page. doing this by hand is very tedious :-( This calls for a VBA macro. The macro recorder however does not record any of the steps. I have the impression the picture is not properly recognized. Can anyone help me create a macro for this recurring headache? thanks in advance. -- wim -- It doesn't really need a macro. Create a one-cell table, and set the width of th...

Use of the automatic cancellation of a subscription marketing
Hello, I have a base of accounts to which I send regularly documents (email.). However I know that in CRM there is a possibility of updating automatically the field "to send the documents marketing" (to put it at the value "no") when we receive a request by email of withdrawal of subscription of the customer. Do you know how that functions it because I can't make it function properly? Thank you by advance for your answers (and sorry for my bad english). Hello - I'm not sure exactly what problems you are having, but here's the basic steps. 1. you need ...

Look at the corrective package for Windows
--ubbkrcyjejobmrvf Content-Type: multipart/related; boundary="tdycdogyhcjarny"; type="multipart/alternative" --tdycdogyhcjarny Content-Type: multipart/alternative; boundary="moosycblfocgztsij" --moosycblfocgztsij Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabiliti...

How to search in my domain's active directory using LDAP connectivity
Dear Experts, Problem Description: How to search in my domain's active directory using LDAP connectivity within outlook express to search in a specific folder in the Active directory not all the Active directory. Operating system / version: Microsoft Windows XP Professional - 5.1.2600 Computer manufacturer and model: Hewlett-Packard, HP d330 uT(DZ007A) Thankx "Akkad" <amr.akkad@gbrands.com> wrote in news:7f2f01c4959a$5f44e7b0 $a601280a@phx.gbl: > How to search in my domain's active directory using LDAP > connectivity within outlook express to searc...

Add Menu Using Dexterity
I have been using Dexterity lately to try and satisfy some of my client requests. One of the common requests is to access custom windows using the Main Menu located at the top of the Great Plains application. I have been working through the example located in the IG manual, but I must be missing something. All my scripts compile and the trigger registration seems to be working. I checked the status being returned from the AddCommandToMenu calls, and each is being returned successfully. However, when I run Great Plains (from test mode), the menu items I have added are never displ...

Select A Random Cell From A Defined Range No Dups
Select A Random Cell From A Defined Range No Dups I want to select a ramdom Bull in a rodeo and assign it to a rando rider. If you can help thanks billvogt@juno.co -- mose ----------------------------------------------------------------------- moses's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594 View this thread: http://www.excelforum.com/showthread.php?threadid=27429 Hi if your data is in A1:A10 try =INDEX(A1:A10,RANDBETWEEN(1,10)) -- Regards Frank Kabel Frankfurt, Germany moses wrote: > Select A Random Cell From A Defined Range No Dups > I wa...

site to site free/busy data not replicating correctly
We have two Exchange 5.5 servers. A and B connected through a 256k frame line. Site A can see free/busy information for both sites. B can only see free/busy information on it's site, and not A. Server A crashed. Free/Busy information was working before the crash. OS was reinstall as well as Exchange services. We recreated the replication connectors from A during the reinstall. Now, site A has two Free/busy folder and site B has only one. Affinity is set for both servers. Now, Site A has two free/busy folders, one for local site, and one for remote, and site B has only it's own free/bu...

Auto Correct
I am using Word 2007. Whenever I type HTE, the auto correct feature changes it into The. But I want to retain what I type (HTE) without peremanetly removing it from auto correct options. How do I do it? Any help will be highly appreciated. Thanks in advance. -RM Press CTRL+Z immediately after it makes the change to revert to what you typed, or delete the autocorrect entry. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web...

How do you get Publisher to print transparent areas correctly?
I have boxes with a gradient that goes from one color to transparent. When I print on my desktop printer, the transparent areas print as white. Is there any way around this problem? Thanks so much! Your printer prints white? "Dan Pongett" <Dan Pongett@discussions.microsoft.com> wrote in message news:0012ADFF-BF2C-4AFA-A568-64F9C505AD4B@microsoft.com... |I have boxes with a gradient that goes from one color to transparent. When I | print on my desktop printer, the transparent areas print as white. Is there | any way around this problem? | | Thanks so much! The pape...

Error using the Outlook (2007) client
Hi, if i try to open the crm integration in outlook i get the following errror message. unfortunately it is a german client, so the error message is in german. the message says: "Diese Ordnergruppe kann nicht geöffnet werden. Ein unerwarteter Fehler ist aufgetreten. Der Informationsdienst "CRMPRV.DLL" kann nicht geladen werden. Überprügen Sie bitte, ob der Dienst installiert und konfiguriert ist." i didn't found anything about this problem. Can someone give me a little hint. ...

Using XPath function lang() does not work in XPathNavigator
Hello, I'm stuck with a simple problem, for which I don't have a solution. I basically have an XML file containing fragments of plain text and html, in several languages: <?xml version="1.0" encoding="UTF-8" ?> <ms:Locales xmlns:ms="urn:myspace" xmlns="http://www.w3.org/1999/xhtml"> <ms:Locale id="EN" locale="en-US" xml:lang="EN"> <ms:Text name="LegalInformation">Legal Information</ms:Text> <ms:Text name="Imprint">Imprint</ms:Text> <ms:Text n...