Creating Date filter and Running a query in a Form

[sonaljain123]

Hi,

I am trying to create a filter to contain dates from a table and then trying to run a query on the same table to get corresponding date's values. But I am getting a run time error in the following piece of code:

iQuery_From = "FROM HD_GL_ACCT_BALANCE INNER JOIN MAP_BALC_DESC ON HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO = MAP_BALC_DESC.[BAL_ID]"
createFromClause = iQuery_From

Is there anything wrong with this one?

Thanks!

 

[sonaljain123]

Also, when I am trying to fetch only certain fields from the table by creating a where clause in the following statement:

iQuery_Where = "HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO=CFA OR HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO=REC";

Does the CFA and REC need to be in quotes like "CFA" and so? Also I have 50 such or conditions to check which are running in three lines, so to separate the lines I should use & _, is that correct?