Create Self-Join Query In Design View - Microsoft Access / VBA

PC Datasheet

A query based on TblEmployee shows TblEmployee in the query window. Is there
a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the query window.

Thanks,

Steve

Nov 13 '05 #1

Subscribe Post Reply

1861

Allen Browne

Right-click the table in the upper pane of the query design window, and
choose Properties.

Set the Alias property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:sL****************@newsread2.news.atl.earthli nk.net...

A query based on TblEmployee shows TblEmployee in the query window. Is
there a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the query window.

Nov 13 '05 #2

Tim Marshall

PC Datasheet wrote:

A query based on TblEmployee shows TblEmployee in the query window. Is there
a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the query window.

Being cautious about my ridiculousness earlier this morning... Just
bring the table into the query design grid twice (Click the add button
twice on the Show Table dialog). One will be tblEmployee, the other
will default to tblEmployee_1. All you need to do is right click the
graphic for either table and bring up the properties window and change
the alias property to T1 or T2 in the "field properties" display that
appears.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Nov 13 '05 #3

PC Datasheet

Thanks, Allen!

Something simple that I never knew!!
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:43**********************@per-qv1-newsreader-01.iinet.net.au...

Right-click the table in the upper pane of the query design window, and
choose Properties.

Set the Alias property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:sL****************@newsread2.news.atl.earthli nk.net...
A query based on TblEmployee shows TblEmployee in the query window. Is
there a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the query window.

Nov 13 '05 #4

PC Datasheet

Thanks, Tim!

Something simple that I never knew!!

Re: Ridiculousness ---
I was up all night two nights ago working on something. After some sleep the
next morning, I went back and looked at what I had worked on. Speaking of
ridiculous mistakes!!! If I would have plotted the degree of ridiculous
agaist time it would have been an exponential curve :)

Steve
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:dd**********@coranto.ucs.mun.ca...

PC Datasheet wrote:
A query based on TblEmployee shows TblEmployee in the query window. Is
there a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the query window.

Being cautious about my ridiculousness earlier this morning... Just bring
the table into the query design grid twice (Click the add button twice on
the Show Table dialog). One will be tblEmployee, the other will default
to tblEmployee_1. All you need to do is right click the graphic for
either table and bring up the properties window and change the alias
property to T1 or T2 in the "field properties" display that appears.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Nov 13 '05 #5

Similar topics

How can I create a wxgrid dinamically ?

by: Kepes Krisztian | last post by:

Hi ! My problem is that: 1.) I want to create a frame with some buttons, and client area. If the user clicked on a button, the procedure create components on client area, and show results.

Python

How do you create a custom QCursor in Python Qt?

by: Steegg | last post by:

I am a newcomer to using Python and Qt and the main problem that I have is the dearth of any example code or books describing the use of Python and Qt together. My current problem is that I want...

Python

Help Create Good Data Model

by: mwt | last post by:

Hi. I'm reworking a little app I wrote, in order to separate the data from the UI. As a start, I wanted to create a iron-clad data recepticle that will hold all the important values, and stand up...

Python

pre-PEP: The create statement

by: Steven Bethard | last post by:

The PEP below should be mostly self explanatory. I'll try to keep the most updated versions available at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

updated pre-PEP: The create statement

by: Steven Bethard | last post by:

I've updated the PEP based on a number of comments on comp.lang.python. The most updated versions are still at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

wxpython: can't even create a Panel

by: John Salerno | last post by:

I'm using the sample code of the file 'simple.py' and trying to make a single window with a panel in it, but I keep getting an error. Here's my code: (I know I might need something else, like a...

Python

Function to create Tkinter PhotoImages from directory?

by: Kevin Walzer | last post by:

I am trying to create a number of Tk PhotoImages from a single directory. Currently I am hard-coding file names and image names, like so: def makeImages(self): self.imagedir = (os.getcwd() +...

Python

inherit from file and create stdout instance?

by: MisterPete | last post by:

How can I inherit from file but stil create an instance that writes to stdout? ----------- I'm writing a file-like object that has verbosity options (among some other things). I know I could just...

Python

How to create new files?

by: Robert Dailey | last post by:

Hi, I'm trying to create a Python equivalent of the C++ "ifstream" class, with slight behavior changes. Basically, I want to have a "filestream" object that will allow you to overload the...

Python

Re: Tkinter - How to create combo box using Tix with the existingTkinter widgets/

by: dudeja.rajat | last post by:

On Mon, Aug 25, 2008 at 12:57 PM, <dudeja.rajat@gmail.comwrote: Ok...now I found the way to do that. But I'm stuck further. my code is as below: main module ********************** myRoot...

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA