Syntax error in from clause

[Emmanuel Ayivi]

Again am sorry for not leaving to expectation on this website, This may be because am new but I promise to adjust.
I have a table "tblfeesdetails" which is updated by a command button click from a form belonging to another table. In the above mentioned table (tblfeesdetails), I have the following fields; GroudpID, ...,BillDate. Now I want to select all the records or data updated just now or (to day) based on two criteria thus Groupid and BillDate. But I am prompted with "Syntax error in FROM clause. The line Set rstd = CurrentDb.OpenRecordset(strSQLDetails) is highlighted with yellow colour meaning that the error is comming from here.

 strSQLDetails = "SELECT tFD.* " & _
                "FROM   [tblFeesDetails] AS tFD" & _
                "       INNER JOIN" & _
                "      (SELECT Now([BillDate]) AS [NowDT]" & _
                "       FROM   [tblFeesDetails]" & _
                "       WHERE  ([GroupID] =  '%G'"")AS sQ" & _
                "  ON   tFD.[BillDate] = sQ.NowDT " & _
                "WHERE  (tFD.GroupID = '%G'"";"
 
strSQLDetails = Replace(strSQLDetails, "%G", mgroupid)
 
     Set rstd = CurrentDb.OpenRecordset(strSQLDetails)

[TheSmileyCoder]

I suggest you read this insights article on VBA debugging:
Debugging VBA code

Reading your post would be alot easier if you would bother to use the Code bbtags, but im guessing the issue is too many quotes around the %G, or an emty mGroupID. But read the debugging article and you will be able to spot such mistakes easy enough.

[NeoPa]

Emmanuel:
Again am sorry for not leaving to expectation on this website, This may be because am new but I promise to adjust.

Always a welcome comment. There is a FAQ available to help you come to understand all that is expected of you as a poster. We feel all the requirements are reasonable, and they are there for the benefit of all involved - not just we who run the site, but also all those of you who use it too. We always welcome such a statement of intent though :-)

Now the code tags are in place (and I can see you've laid your code out well to be easily readable) I suspect your problem(s) lie with extraneous double quotes (Lines #6 & #8) and possibly the misuse of the function Now() on line #4.

I don't have my Bytes database available ATM but I have some text in there that explains how to debug such things. I'll repeat some of it here, but possibly not the full version.

Basically, what you should be doing when working with SQL created in VBA is to separate the two out. This involves using something like Debug.Print strSQLDetails after it's been set up, and looking at what's in there. In this case it would show something like :

SELECT tFD.* FROM   [tblFeesDetails] AS tFD       INNER JOIN      (SELECT Now([BillDate]) AS [NowDT]       FROM   [tblFeesDetails]       WHERE  ([GroupID] =  '???'")AS sQ  ON   tFD.[BillDate] = sQ.NowDT WHERE  (tFD.GroupID = '???'";

I haven't formatted it as I normally would SQL, because it's exactly what you need to look at. Spaces and all. It's much easier to work with SQL directly than it is to work with what you think aught to come out after VBA has finished creating it for you.