UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Relate Tables And Show Records Only From One Table, Office 2007    
 
   
Tiesto_X
post Mar 31 2012, 07:15 PM
Post #1

UtterAccess Veteran
Posts: 330
Hi everyone,

I have two tables related one-to-many with field "pibPO".
Query use ALL fields from Table1 and ONE field "nameOfObject" from Table2.

How to get ALL records from Table1 and only values from field "nameOfObject" of Table2 that match Table1.

Table1 got 1050 records.
Table2 got 1692 records.
When i run current query it has 1713 records.

I need query with 1050 records from Table1 and added field "nameOfObject".

Hope you guys got me.

I wasted all day on this and still nothing...

Thanks in advance!
Go to the top of the page
 
+

Posts in this topic
- Tiesto_X   Relate Tables And Show Records Only From One Table   Mar 31 2012, 07:15 PM
- - Doug Steele   You say you've got a 1 to many relationship. I...   Mar 31 2012, 07:25 PM
- - Tiesto_X   Its everything as you said. Very thanks for making...   Apr 1 2012, 04:21 AM

« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 03:39 PM