User Defined Function in SQL Select

[theDBguy]

Hi. Not in front of a computer again but try binding the Textbox to txtSalePrice.

 

[GK in the UK]

YES ! That did it.


I can sort of see what's going on with the SQL select. It's beyond my current skill level, I do have SQL selects and updates but I can see it can do some very powerful stuff that I should learn.


Thanks for spending the time on this, really pleased with the result

 

[theDBguy]

YES ! That did it.

I can sort of see what's going on with the SQL select. It's beyond my current skill level, I do have SQL selects and updates but I can see it can do some very powerful stuff that I should learn.

Thanks for spending the time on this, really pleased with the result

Hi. Glad to hear you got it to work and sorry it took so long. It would probably have gone faster if we only had a sample db to look at to make understanding the situation sooner. Good luck with your project.