Followup on SQL Help Important

  • Thread starter Thread starter Brandon Johnson
  • Start date Start date
B

Brandon Johnson

http://groups.google.com/group/micr...b489bf4c209/dfc7e531198a4f41#dfc7e531198a4f41

to continue off of that thread, I have tried to comment out everything
after the from clause to see if it directed to the right table. it did
direct to right table and ran perfectly. Now i jsut need to implement
the where clause. So i think theres something that has to do with that
where clause and i have ran the debug to see if it was throwing me the
right information within the varible. it is as far as i can see anyhow.
If anyone has any thoughts please let me know. Still very urgent.
thankyou
 
Hi,


Your field, accordingly to its table design definition, is a text or is a
number? If it is a number, try to remove the ' around the supplied number in
the IN clause.


Vanderghast, Access MVP
 
.... and if you got an overflow, try:


IN( CDec(4460001683) )


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top