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.

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

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

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

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

I cannot get my query to return result when I enter the month of "June" as search criteria. June is listed in the table and query, every other month is returned except June. I have attached two example for your reference. Thanks.

Hi, I am new - sort of. I use to post a long time ago when I worked with Access on a daily basis. My post today is probably already listed somewhere in the forum so please forgive me. I am trying to have my form auto-populate a field when I select an item in a drop down list in another...