Multiple WHERE conditions

[Cowboy]

I am trying to write an SQL statement with multiple conditions.

Can I write it as:

SELECT * FROM table WHERE condition1, condition 2, condition 3

Or should it be:

SELECT * FROM table WHERE condition1 AND condition 2 AND condition 3

Or something else completely?

Thanks!

 

[pbaldy]

The second:

WHERE Field1 = 123 AND Field2 = 'ABC' AND Field3 = #9/2/10#

 

[Cowboy]

Awesome! Thanks so much.

When I set a record set to that and return a rs with rows of quantities I want to sum, can I just do the following?

DSum(rsfield, rs)

Thanks again!

 

[pbaldy]

I don't think so; I believe the second argument has to be a table or saved query.

 

[Cowboy]

Shoot.

How would I total up all the values for a quantity?

I posted my code here:
http://www.access-programmers.co.uk/forums/showthread.php?t=198447

Maybe that can help you see what I'm looking to do.

Thanks.

 

[pbaldy]

Replied there.