D
Dale Brown
I am trying to get the following query to work.
SELECT CheckRegisterPre.EntryBlankID, CheckRegisterPre.MoneyID,
CheckRegisterPre.Amount, CheckRegisterPre.Note, CheckRegisterPre.entrydate
FROM CheckRegisterPre
where checkregisterpre.entrydate = [forms]![checkregister]![begdate]
The CheckRegisterPre is a query. The entrydate field is a datevalue() of a
date/time field from a table. The begdate is a combo box with the dates in
it populated by another query that gets the datevalue() of the date/time
field. When I run this I get the following error
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables"
Any ideas?
SELECT CheckRegisterPre.EntryBlankID, CheckRegisterPre.MoneyID,
CheckRegisterPre.Amount, CheckRegisterPre.Note, CheckRegisterPre.entrydate
FROM CheckRegisterPre
where checkregisterpre.entrydate = [forms]![checkregister]![begdate]
The CheckRegisterPre is a query. The entrydate field is a datevalue() of a
date/time field from a table. The begdate is a combo box with the dates in
it populated by another query that gets the datevalue() of the date/time
field. When I run this I get the following error
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables"
Any ideas?