Follow-up Query

[aparnawangu]

Hi Friends,

I have a table called followup and i have details of enquiries in that like enquiry form no,follow-up No,follow-up date and remarks.
I need that 1st followup done for how many enquiries,2nd follow-up for how many and similarly how many for 3rd followup.

The query should be such that if F1(followup1) found alone for a enquiry then it should show that record otherwise not
likewise if for a enquiry F1,F2 and f3 is also there then it should not display that enquiry similarly for F1 and F2 also it should not should in result.

Pls help.

Regards
Aps

 

[Minty]

Despite being told many times

Here http://www.access-programmers.co.uk/forums/showthread.php?t=283698, here http://www.access-programmers.co.uk/forums/showthread.php?t=284685 and here, http://www.access-programmers.co.uk/forums/showthread.php?t=286022 , and here, http://www.access-programmers.co.uk/forums/showthread.php?t=286120 , And possibly here http://www.access-programmers.co.uk/forums/showthread.php?t=284623

You aren't listening to the advice being given. Your table structure is incorrect and is the reason you can't get a sensible answer to your question. If you keep asking the same question and don't take the advice people will simply ignore you.