Not In statement from textbox - help please

[jclausen]

Hello,



I have a report in which I am using a Not In statement in SQL view.
This report displays all values from the ABSTRACT field in the ABSTRACTS table except the ones in the Not In statement. The ABSTRACTS field type is a number.

Not In (1173,743)

This works fine, but I want to have the Not In statement get its info from a textbox named EXCLUDE on the form LEASE_INFO_INPUT. So I tried:

Not In ([Forms]![LEASE_INFO_INPUT]![EXCLUDE])

This didn't work. If I only put one value in it like: 1173 then it will display all but 1173. If I put two values in it like : 1173,743 then it will display all. I am obviously missing something here.

Thanks a bunch,
John

[TheShabz]

This probably wont work but give it a try:

Not in ( & Forms!LEASE_INFO_INPUT!EXCLUDE & )

[jclausen]

Thanks for the quick response... You were right, it didn't work.

I got an error message : "The expression you entered has too many closing parentheses."

I didn't see too many...

Thanks again,
John

[TheShabz]

I dont know =/

[orange]

Please post you entire SQL

You can't mix SQL and vba syntax. If you're running SQL from vba you need the proper syntax.