Follow-up Query (1 Viewer)

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

I'm not 100% sure, but I gather from your question that you have several fields in your table to represent a follow up, and you are showing them as F1 F2 F3 (these are field names).

If I am correct then from experience this is the wrong way to build your database.

Whenever you find yourself adding column after column to represent a different form of the same data then you should consider moving that separate data into a separate table.

Sent from my SM-G925F using Tapatalk

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.

Ah! I see....

In view of Mintys response I suggest you have a look at this explanation.

https://sites.google.com/site/msaccess457966vmfjg/articles-by-toeny-hine-awf-vip/excel-in-access

There is an explanation of the issue in text, pictures and video form. I also provide a free tool to help you carry out the conversion from a flat file database to a multi table database.

Sent from my SM-G925F using Tapatalk