Re: Query does not show all data

Hello Jeff,

Thank you for your reply.

I have tried what you suggested, but I cannot get it to work. Maybe I'm doing
something wrong.

You said :

"Decide which table is the "from" table (the one from which you want to see
all >rows)."

My problem is that each table contains a bit of the information I want to see.
Table ACD Data contains the numbers of call answered. Table SD Opened
contains the tickets logged. Table SD Closed contains the tickets closed. So
I don't have one table from which I want to see all rows. Each table
contains a piece of information that I want to see in one view (query).

What I have tried is that I created a new query. I added the query I already
had and then I added the three tables. I then tried what you said:

">Highlight the join line between that table and one of the others. Change
>its property to reflect "all" of table1 and "any" of table2."

Unfortunately this doesn't work. I think I'm doing something wrong (well, I
know for sure).

I hope that I have explained it clear enough.

Thanks in advance for your help.

Jeff Boyce wrote:
>The gist of what you need to do is show all of one table's rows (that meet
>your criteria), plus ANY of the data from other tables.
>
>To do this, open your query (with the tables joined) in design mode. Decide
>which table is the "from" table (the one from which you want to see all
>rows).
>
>Highlight the join line between that table and one of the others. Change
>its property to reflect "all" of table1 and "any" of table2.
>
>Now do the same with any remaining joins.
>
>> Hi all,
>>
>[quoted text clipped - 43 lines]
>>
>> Thanks in advance.

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: How do you analyze the report w/ Office Excel?
    ... With the database window showing, on the Queries tab, highlight (but don't ... run) the query. ... Excel. ... Jeff Boyce ...
    (microsoft.public.access.reports)
  • Re: How to highlight records in datagrid ?
    ... query and if so then highlight that row. ... check MSDN documentation. ... >> I am using a datagrid to display a table. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL 2005 Query Execution for selected text using Right Click
    ... It does not deselect if you right click on the empty window in Query Analyzer as you mentioned. ... execute and then right click in the the Query Editor to Execute the ... it would save the highlight and execute only the text which is highlighted. ...
    (microsoft.public.sqlserver.setup)
  • Re: I want to start fresh with an old database, how do I delete the o.
    ... highlight all the records and press the delete key. ... have specified relationships and referential integrity, ... You can create the delete query for each table in the Query Builder. ...
    (microsoft.public.access.gettingstarted)
  • Re: MS Query in Excel
    ... You should be able to set up your Query so that you only import the data you ... then you could simply highlight the B and C above ... leaving you with just columns Aand D (Total fee ... > Card Number, Paid Date, Fee Paid, Total Fee Paid ...
    (microsoft.public.excel.newusers)