Search results for query: *

i need to select records from a table where a column contains a data like the following. I am getting a syntax error: "Unclosed quotation mark before the character string ' '." How do i fix my query in order to get this record? select * from cust where custname ='Mary M'connell' thanks

When I preview report in Access (looks great) and then click on “W” at top of menu (Publish it with Microsoft Word) and report is shown in Word as a .rtf document. The problem is the Word document does not look like the Access report after exported. Below is what I have created on the form...

I have a table set up like the following (updates by importing the excel file) and I am trying to set up a DTS package so it will automatically import the file on a daily basis since the file is being updated every hr. How can I code it so it will only automatically know which column represents...

I am trying to import an excel file into sql (import data dts) and for some reason, after I imported the data into sql, “May” is the only column that didn’t get imported. I checked all the format of the column within the excel sheet and I don’t see anything different between may column and...

How can I remove Punctuation from the address field like listed below? 555 S. 3829 W.#

I am working on a report and need to do the comparison between current type and previous type to monitor user who changes the type within the table except for user “zy5897” or “wy5689”. The report is group by acct# then inv#. I need to output the prev type (tt) with prev date (1/10/07) even...

i have a field setup by my co-worker with type = varchar(5000). This is supposed to be a date field . I tried to convert it to smalldatetime [cast (rcvdate as smalldatetime)] and got the error message "syntax error converting character string to smalldatetime data type. how can i fix this...

I am working on a report and need to do the comparison between current type and previous type and the report is group by acct# then inv# and the formula (acct.type =previous(acct.type) is placed at the group footer /suppress (no drill down) / x-2. Since acct# X222 only has one record in the...

Hi, I am pretty new to crystal report and I having difficulities getting started. Please see the table listed below. I have a table contains all the historical data and I need to create a report which will show when the "type" column was modified each time between the most recent "date" and...

Hi, I am pretty new to crystal report and I having difficulities getting started. Please see the table listed below. I have a table contains all the historical data and I need to create a report which will show when the "type" column was modified each time between the most recent "date" and...

I need some help with a report I am working on. Please see the table listed below. I have a table contains all the historical data and I need to create a report which will show when the "type" column was modified each time between the most recent "date" and the previous date (4/05/07 and...