|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 22nd, 2007, 02:09 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Missing records in query
May be simple but I cant figure it out.
I have one table that holds property details and another that holds appointment dates for properties. I have a one to many relationship set. (one prop many appts). I need a query that will give me all my properties and details of any appointment set. When I have created the select query I only get back property records where there is an appointment made. I would really like to see the propety details with a blank entry in the appointment field. Would be grateful for any help available. Thanks 
|
|
#2
June 22nd, 2007, 02:14 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Missing records in query
jfaz wrote:
May be simple but I cant figure it out. I have one table that holds property details and another that holds appointment dates for properties. I have a one to many relationship set. (one prop many appts). I need a query that will give me all my properties and details of any appointment set. When I have created the select query I only get back property records where there is an appointment made. I would really like to see the propety details with a blank entry in the appointment field. Would be grateful for any help available. Thanks Double-Click the line joining the two tables in the query. The resulting dialog should be self-explanatory. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
