Search results for query: *

I am trying to convert this query from Oracle to Access. I am getting an error Syntax Error 'Missing Operator" in query expression 'Case When...' Does anyone have any idea what is wrong with the syntax in this query? Thanx, Trudye SELECT R.RETAIL_CNTR_NUM, I.VIN_NUM , I.LEASE_ACCT_NUM...

Hi Mufasa, thanks for responding. I am seeing the error in Access.

I am trying to convert this query from Oracle to Access. I am getting an error Syntax Error 'Missing Operator" in query expression 'Case When...' Does anyone have any idea what is wrong with the syntax in this query? Thanx, Trudye SELECT R.RETAIL_CNTR_NUM, I.VIN_NUM , I.LEASE_ACCT_NUM...

Got it! Give me all I recs and those M recs that match the I recs? Thank you so much I can duplicate that in Access. Trudye

I have inherited this (sub) query from a Guy who coveted his work. I have figured out everything else except I cannot figure out what the (+) is for. Because of the field values he could not have been adding the fields. Does anyone have any idea what (+) means and how it would translate to...

Thanks so much Guys that worked great on some PC's but not on others. Do you have any idea why? Trudye

Hi Guys, sorry it took me so long to get back to you but things got crazy for a minute. When I used the commands suggest all I got was a minimized DOS window. The msg I typed in the run command was never delivered. I'm sure it's something I'm doing wrong, not sure what. Thanx, for responding...

Hi Guys, does anyone know the format for sending messages to another PC usng RUN (on the Start menu). I cannot for the life of me remember the command which is embarassing because I do remember it is a very simple command. Thanx Trudye

I thought I had set everything up right but.... I went into Tools; Options; Delegates, I added my name to the Delegates list. Shouldn't I then be able to send emails with "on behalf of" in the FROM box? Is there something special I have to do when I enter the From. Note: The mailbox I'm...

Thanks so much Guys for all your help. CautionMP you were right on the money, we found all the options for DSNOptions. It was kind of weird tho, the default should have been Zero which is what we want. However the default was not working. We placed a zero in the option and VIOLA! it works...

Hi Guys, I have a question about CDO. For some strange reason CDO is causing Outlook to produce a 'Request a Read Receipt' from each recipient. Does anyone know how to turn this off, or how we got outselves into this mess? Everything else is working fine not errors, no messages, everyone is...

DUH! Sorry to have bothered you. Be well, Trudye

Hi Guys I can't seem to get rid of decimal places on my report. Two decimal places show up on the report the output should not show decimal points. In the table the field(s) are defined as Single; general; zero decimal places. On the ouptut report the fields are defined as general, zero...

Thanks Duane so much for responding. I'm sorry I now realize my question was vague. The two fields need to be summed independantly. I need to have sumOfA and a SumOfB. But as you know Crosstabs only allow one value field and one column field. I guess maybe I'm kinda answering my own question...

Hey Guys, I have a question. I have a table that has two fields that need to be summed in a Crosstab query. Is there a way to accomplish that?

Thanks to everyone for taking the time to respond. PHV I tried you suggestion and nothing changed. Skip - No the field is an ID number and the character is just character. But that is curious that you should ask, I asked if it was packed decimal too. CMP - I have not had an opportunity to...

Thanks CM for responding. The file comes in as CSV and I open/save it as Excel (XLS). The problem is that most of the data in the field is numeric, there is the occasional string/text value. When I import the file as CSV to create a spec for it I assign the field as Text(in the Advanced area)...

Thanks Bill for responding. When I attempt to import the file into Access I am getting errors on the field. The records that are showing up in the Error file are the ones that have alpha characters (ie. 0907C) and the value is left justified, all the other values in that column (for the recs...

I have a User that receives a *.CSV file daily. When the file is opened (in Excel) some of the values become invalid. There are alpha values in a numeric field (ie. 0907C). I wrote the code below to change all the values in that column to string/text but it is not working. The original format...

I am soooo very sorry. I figured out what it was days ago, but failed to report my findings. You hit the nail on the head Mtntrvlr, it was the report groupings that needed to be adjusted. Thanks so much to both of you for taking the time to respond. Be well, Trudye