Recent content by lemondrop9344

Gentlemen, Appreciate your help. SerialNumberType is a string value & not a numeric value (it's text not a number). The query works in Access 2010 & produces the desired results. I was trying to find a 'quick & easy' way to generate the query in SQL CE 3.5. I was hoping I could cut and...

CJ, appreciate the feedback. As you indicated, I need to find the sqle equivalent.... which has been somewhat challenging. The applications generating the data I'm trying to get at were developed years ago.

I'm trying to learn while doing, please humor me. I have a SQLE 3.5 database. Presently I go through a process of exporting the tables into .xlsx format, link to the tables in Access 2010 and generate the results. Access 2010 does not have an OBDC driver for SQLE 3.5 built in. I have not yet...

Thanks for the quick response. Feel sort of foolish now. I was sure I had the field name typed into the statement correctly, obviously, the eyes see what they want to see instead of what is actually there. Your response triggered me to look at the statement with a little more...

I am trying to evaluate the contents of a field entitled FASITYTPE from a database created by another entity. The field will contain a value of 1, 2 or 3. If the value is 1, I want to add 2688876544 to create a field entitled SERIALNUMBER and place it in a field entitld TXID. If the value is...