Setting the Record Source property with SQL code

[andegre]

I have a report that needs to be opened but the original Select statement that Access put in the RecordSource property isn't all that I need.

Currently, the RecordSource property has Select ... FROM ... INNER JOIN ... ON ...

Question: I want to add a where clause that has nothing to do with the INNER JOIN stuff. Where do I add the WHERE clause, before or after the INNER JOIN? All the WHERE clause is going to be is 'TableName.FieldName = false'

Anyone know Access SQL coding...

 

[andegre]

Nevermind, I just inserted my code in the WhereCondition on the DoCmd.OpenReport...

Thanks anyway...