View Single Post
  #1 (permalink)  
Old August 26th, 2005, 02:31 AM
Astro Astro is offline
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Default select statement with listbox item(where qnsID ="

I was advised on this.

select * from ans_table, ss_table where ss_table.qnsID = " & List1.ItemData(List1.ListIndex)

i'm a bit skeptical on how SQL joins with VBA using =" & (is it really meant to work?)
excuse my inexperience so please do correct me.

I kinda need to compare a listbox item to a column in my table.
Need some serious help.

Thank You very much.

Astro

Reply With Quote