Hi Jeff,

That is not condescending at all, and I know its pretty obvious that I am a newbie, but that is why I am here in this forum with all...

Hey All,

In my table I have a Amount column with values of -25.

I can select the -25 from the SELECT statement, however, I would like to do this

in the...

Koji,

Worked perfectly thank you very much!

Koji,

Awesome, let me try it out.

SQL Bill, sorry about that....

I am not using Rtype as a primary key, so what type of SQL query should I use to create a new row?

What I showed you was sample table of what I am trying to do. On the real table I am working on, I acutally want to create a...

Ray,

Thanks...now here is my next situation.

I have a table with the following columns: Rtype, Amount, Refnumber, Color:

Here is what the table looks like:

RD ...

Okay, the INSERT command answers my question.

Now my question is: I have one column that contains a -25.00 and 25.00, and maybe a few have different values. If...

Ray thankyou, I am going to try that out, and if I am still running into problems I will let you know. Thanks!

Thank you all for your sound advice, I was able to solve the problem, I greatly appreciate it.