Statement for Multiple Filters in SQL

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Statement for Multiple Filters in SQL

Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 29th, 2004, 02:52 PM

mckly

mckly is offline

Authorized User

Join Date: Jun 2004

Posts: 13

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Statement for Multiple Filters in SQL

I'm new to this...
How do I combine two filters?
The first one is:

rstBookmarks.Filter = "MacroName = " & "'" & temp & "'"
rstBookmarks.Filter = "DOCT_ID = 2"

I'm not sure how I filter with two conditions together. Please advise!

Thanks,
Beginner

Old

August 2nd, 2004, 01:53 PM

dhay1999

dhay1999 is offline

Authorized User

Join Date: Jul 2004

Posts: 66

Thanks: 0

Thanked 0 Times in 0 Posts

Default

rstBookmarks.Filter = "MacroName = " & "'" & temp & "' and DOCT_ID = 2"

use AND :)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
update multiple column based on case statement??	vinod_yadav1919	SQL Server 2000	6	July 3rd, 2008 07:29 PM
multiple updates in one statement	rashi	Access	1	December 21st, 2007 01:05 AM
multiple sql statement	IbrahimSyed	SQL Server 2000	5	July 1st, 2005 10:27 AM
objRS.Filter (Multiple Field Filters)	egerdj	Classic ASP Basics	1	March 10th, 2004 04:48 PM
Refer to multiple databases in one SQL statement	JimPaum	Pro VB Databases	5	June 25th, 2003 08:57 AM