I need help with SQL syntax.

[Guest_imported]

I'm still learning elementary VBA SQL coding syntax. But I'm not really clear on how Group By and Order By should appear in an SQL line. The code below is a sampling of the code that I am using. Could someone give me an example of how the GROUP BY and ORDER BY statments should be added (should they be inside or outside of the parenthesis, etc...)

Set Rs = Db.OpenRecordset("SELECT [Table Name].*
FROM [Table Name]
HAVING (([Table Name].Date
Between Eval('[Beginning Date]')
And Eval('[Ending Date]')))&quot

 

[raymondo]

The "standard" clause sequence is
SELECT list of fields
FROM list of tables (with JOINS etc)
WHERE selection ctriteria
GROUP BY list of fields
HAVING selection criteria of grouping
ORDER BY list of fields
Parentheses are used within each clause.
Hope this helps.