Access query to show repeat allegations within six month of the initial disposition

[Sinoe]

This is for Markk, arnelgp and plog although anyone with a solution may kindly respond.

Sorry that my earlier posts were sent in bits and pieces without context.

I will attempt to post (attach) a sample table with data. Below is the result that I am hoping to get from the query derived from the table.

Expected Result: Date (assess end date), ID #, Total numbers of allegation received, allegation description, allegation disposition description, # of allegations repeated within 6 months of initial disposition.

Hopes this somewhat clarifies a bit more what I am hoping to achieve.

 

[arnelgp]

Have u seen my reply on your other post?

 

[MarkK]

This thread extends this one ... https://www.access-programmers.co.uk/forums/showthread.php?t=295985

 

[plog]

Sorry that my earlier posts were sent in bits and pieces without context.

So you made a new post without explanation to help matters?

Also, I requested 2 sets of data--starting and expected results. Which of those did you post and when will you post the other?

 

[Sinoe]

Have u seen my reply on your other post?

Yes, I did and thanks. I thought that I would provide a little bit more information about the issue I am working on.

 

[Sinoe]

So you made a new post without explanation to help matters?

Also, I requested 2 sets of data--starting and expected results. Which of those did you post and when will you post the other?

I tried to provide that information you requested but could not get the format I wanted. Instead I posted a table (Attachment) and what outcome I was looking.

Sorry about the confusion.

Thank you!

 

[plog]

Please post 2 sets of data:

A. Starting sample data from your table(s). Include table and field names and enough data to cover all cases.

B. Expected results of A. Show me what data you hop to end up with.

2 sets of data please.

 

[Sinoe]

Plog,

I have attached the table. Here is what I expect to get in the result set:

1. Allegations received by Name
2. Allegations dispositions by name (End date is the disposition date)
3. Allegations repeated within 6 months of the initial disposition date

I can develop a query in Access. to show the initial dispositions. I just don't know how to do it to show the repeats within six months.

Hope this is what you are looking for from me.

Thanks.

 

[plog]

Last chance.

2 sets of data please. Not one set and an explanation.

 

[Sinoe]

Thanks, Plog. Something is getting lost between our communication. I thought that I did provide what you requested; a table and expected outcome.

I'll just quit bothering you with my question.

Thanks.