Results 1 to 5 of 5

Thread: Strange query...

  1. Mar 21st, 2006, 12:06 PM #1
    daniel_b
    daniel_b is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    7

    Strange query...

    Hi everybody!
    I have a problem with something. I have an "event" table. For each event there should a few contact people, customers, and technicians. Now, I created a table for the event, which including a few details about the event, three tables, that will have everyone the details for a contact man or customer or technician (depens which table). Finally I created three more tables, that will combine a certain event (by his ID) with a few contact men, or customers etc.
    Now, my question is how can I create a report that will include all the above details. It should look something like that:

    event_name: "bla bla"
    contact peoples: "Jon"
    "Bob"
    customers: "Jim"
    "Alice"
    etc...

    I don't know how to do it...
    Any ideas?
    Thanks
    Daniel
    Reply With Quote Reply With Quote
  2. Mar 21st, 2006, 01:14 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Strange query...

    What are you going to be using for reporting software?

    What kind of database are you using?
    Reply With Quote Reply With Quote
  3. Mar 21st, 2006, 01:20 PM #3
    daniel_b
    daniel_b is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    7

    Re: Strange query...

    Hi.
    I am going to use the vb report writer... or maybe the crystal report that come with vb (v. 4.6)...
    My database is access 2000.
    Thanks
    Daniel
    Reply With Quote Reply With Quote
  4. Mar 21st, 2006, 11:32 PM #4
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Strange query...

    You would have to use 'JOIN' in your sql statements...
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  6. Mar 22nd, 2006, 07:02 AM #5
    daniel_b
    daniel_b is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    7

    Re: Strange query...

    Thanks..But how exactly? I Don't think I understood... Can you give me an example?
    Thanks
    Daniel
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width