Recent content by Sinoe

  1. S

    Converting Access SQL to Orac;e SQL

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

    Question Criteria in Query

    Thanks you, MarkK. Appreciate your thoughtfulness.
  3. S

    Question Criteria in Query

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

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

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

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

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

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

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

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

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

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

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

    Query to show repeat occurances between two dates

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

    Query to show repeat occurances between two dates

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

    Query to show repeat occurances between two dates

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

    Query to show repeat occurances between two dates

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

    Query to show repeat occurances between two dates

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

    Return Alphanumeric values only

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

    Return Alphanumeric values only

    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...
Back
Top Bottom