Search results

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

Thanks jdraw. I tried IsNumeric but it did not work. It actually returned no result.

Thanks for responding so quickly. 132NAV100 is just one of the ID numbers in the table. I want to run the query to return ID numbers like this and not ID number that just have numbers, like 12345 or 7891, etc. Thank you.

Hi smart people, Can anyone tell me how to write an expression/criteria in a query that will return only ID numbers with alpha numeric values. Example: My Id field contains both numeric 479621, 680530 and alpha numeric 132NAV100, 174NAV26a values. I want to run the query to return only the...

Thanks Rookie, The Wild Card Compare "Like" statement did the trick. Still baffled as to why it wouldn't return any value when "June" was selected. Thanks again.

Yes. I can enter all the other months in the criteria and get results but somehow "June" is returning nothing. Strange. Really strange