query:HELP! HELP HELP HELP HELP 
Author Message
 query:HELP! HELP HELP HELP HELP

ok here goes...
i have a database set up with many records that are listed like this...
there is an "agency name" then a "contact name" for each agency.
BUT, there can be more than one "site" for each agency, with a related
"contact name" for each "site".
SO...
i know that when i run a query, if i use a single check mark next to a
column name, it will sort out all the dupicates.  which is exactly what i
want.
i need to print a list of all my agencies and the address etc, sorting out
all the duplicated "agency names" that come up due to the multiple
"sites".

as u can see, it is kinda complicated, but if any 1 can provide me wih
help, i would appreciate it so much...


thanks.



Thu, 30 Sep 1999 03:00:00 GMT
 query:HELP! HELP HELP HELP HELP

Quote:

> ok here goes...
> i have a database set up with many records that are listed like this...
> there is an "agency name" then a "contact name" for each agency.
> BUT, there can be more than one "site" for each agency, with a related
> "contact name" for each "site".
> SO...
> i know that when i run a query, if i use a single check mark next to a
> column name, it will sort out all the dupicates.  which is exactly what i
> want.
> i need to print a list of all my agencies and the address etc, sorting out
> all the duplicated "agency names" that come up due to the multiple
> "sites".

> as u can see, it is kinda complicated, but if any 1 can provide me wih
> help, i would appreciate it so much...


> thanks.

Not sure what your problem is but here's a few ideas.
1) If you want a report which prints each agency followed the all its
sites then use a group band and put the agency name in there and
the site address in the record band (if your data is denormalized)
otherwise you have to link the agency table with the sites table
2) If you just want a list of agencies, follow the above and clear out
the record band and shrink it to zero.
Hope this helps.
--
****************************************************

* SCF Consulting, Calgary, AB
*
* 'There are more objects in Mainframe and the Net
*  than are formulated in your paradigm, Bob'
****************************************************


Thu, 30 Sep 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. help help help help help help help help help

4. SQL To ORACLE Help Help Help Help Help

5. NULL Values in SQL Queries - HELP HELP HELP...

6. Help help help help

7. HELP HELP HELP HELP!

8. HELP HELP HELP HELP

9. HELP HELP HELP

10. Refresh Test Environment help help help

11. backup HELP HELP HELP

12. HELP HELP HELP!!!!


 
Powered by phpBB® Forum Software