Recent content by Sinoe

Is there a converter around somewhere to convert Access SQL to Oracle SQL? I saw one in a different forum but after the conversion the SQL return and error "Missing Expression" which could me a number of things.

Thanks you, MarkK. Appreciate your thoughtfulness.

A couple of days ago I posted a question about how one would go about designing a query to show if an occurrence was repeated within six month of the initial determination of the first allegation. I got some help but I think my question was not clear. I am attempting again to get some help this...

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.

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...

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!

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

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...

Thanks plog. Here is the table and sample result...

Thanks to Markk and arnelgp for their responsed. I am still having some trouble utilizing your solutions. As a result, I am posting a sample table of the data that I am working with in the hope of getting a query that will help me achieve my result which is to get a the number of allegations...

Thank you so much arnelgp. I can't wait to try this. MarkK's response was helpful but the result wasn't what I expected. I will post later about what results I get and if my original question was phased correctly. Thanks again.

Thanks so much for responding so quickly, Mark. I will try out the code as soon as I get the chance.

Hi Everyone, It's been a while since I posted. I need your help! I am trying to develop a query that will provide information about alleged abuse. I want to be able to show that the same allegations occurred within 6 month of the initial allegation and to the same person. My data fields...

jdraw, Thank you so much. It worked!!!!

Here is the SQL statement. This returns result but include the numeric as well as the alpha numeric id numbers. SELECT [Navigator data MAY 7-13].[Last Name], [Navigator data MAY 7-13].[First Name], [Navigator data MAY 7-13].[Assister ID], [Navigator data MAY 7-13].[Assister Org Name] FROM...