View Single Post
Old 11-17-2019, 12:50 PM   #38
GK in the UK
Newly Registered User
Join Date: Dec 2017
Posts: 117
Thanks: 15
Thanked 0 Times in 0 Posts
GK in the UK is on a distinguished road
Re: User Defined Function in SQL Select

OK I put your code in the record source and it works (I think)
I get the same records that I expect to show in the bottom datasheet
I need to check some stuff out as I've done quite a bit today

Should the values show reversed ?

Does this mean it's going to tblDocTypes for *every* datasheet line that is displayed ? I have difficulty with that. It strikes me as odd to have to go to a table a dozen times or more when the same condition applies to every datasheet line.
GK in the UK is offline   Reply With Quote