Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Invalid Bracketing in Ms Access 2000

I have a query with the following parameters

PARAMETERS [Forms]!frmSetReportDate![StartDate] DateTime, [Forms]!frmSetReportDate![EndDate] DateTime;

I keep getting invalid bracketing error (or parameters missing dialog box)

I have read that this is a bug but is there a work round?

Have tried all variations of brackets I can think of

:confused:
[390 byte] By [Ben Dearg] at [2007-11-11 9:53:51]
# 1 Re: Invalid Bracketing in Ms Access 2000
Get rid of the brackets []...
PARAMETERS Forms!frmSetReportDate!StartDate DateTime, Forms!frmSetReportDate!EndDate DateTime;
Ron Weller at 2007-11-11 23:43:33 >
# 2 Re: Invalid Bracketing in Ms Access 2000
No brackets does not work but did find answer by continuing variations
Ben Dearg at 2007-11-11 23:44:31 >