Coding of parameter date queries

I am having problems trying to write an SQL command which contains parameters to allow the selection of a date range over which to query a database.
In order to simplify things I am first just querying for data where the dates are >= to a given date using the code below.

Please Login or Register  to view this content.

This however gives me a "Type Mismatch" error on the line marked ********
I can't see why. Can anyone else?
John

mrice,
Thank you for your interest in my problem. I first punched the air in delight as I read your post as it presented such an easy solution to a problem that has plagued me on and off for weeks. Sadly however I think that the * must be a smudge on you screen. On my computer both &'s are in place.
To be quite certain I deleted both and retyped them. I got the same error.
John

First mrice, I have to apologise for impugning the cleanliness of your screen. I have now seen the wayward * and changed it to the & required. Many thanks for your help.
Second to mrice and norie. With the typo removed the sub ran through without error. However when the 'DownLoad' was run it ended with the error "SQL syntax error on the last line. the full code is:-

Please Login or Register  to view this content.

I have excluded lines 10,20,30 in turn and find that it is lines 10 and 30 that cause the error.
It is my intention when this is sorted, to code two parameters FromDate and ToDate
It seems I still have not got the hang of how to deal with dates or parameters, and I still need help
John

I have managed to get the syntax right by removing the "d" qualifier and its associated brackets. The following code works when the "AND" lines are run separately.
When run as shown here though the last line is ignored and all Transaction Types and VAT codes are listed.
I think this must mean that my brackets are wrong.

Please Login or Register  to view this content.

I am not certain of the rules to cover this bracketing so I could do with some help please
John

My only reference on the subject is a book called Teach yourself SQL in 10 minutes published in 2001! I wouldn't put a huge amount of faith in it but it does say that AND clauses ought to be put in brackets (not, I admit, Must be) and generally advises their use to ensure that their order of evaluation is what you want. On further examination I realise that the brackets I had did not do this, so I redid them to this

Please Login or Register  to view this content.

Which is pretty much as xlnitwit has given above and glory of glories it all works!!!
I must just let you know xlnitwit, Norie and mrice how very grateful I am at all your help. I have had to come back to one aspect or another of the problem 0f getting data out of Sage Line 100 week after week, it is such a relief to be able with your help, to put it to bed.
John