query problem - 2nd posting

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

This is the second time posting this problem (first posted
on July 17, 9:15am) and I am hoping it will be seen by
someone who missed it the first time... I am at a loss as
to why the query works on one W98se/Office97 machine but
not on several others... any help would be appreciated...
if more info re the query or database is required, please
let me know and I will try to provide it.
============================================
original posting follows below
===========================================

We have an Access datbase that was developed in 2000 and
was converted for use in 97... the query below works fine
on one computer with Windows 98se and Access 97/SR1 and it
does not work on several other PCs with the same Windows
and Access versions... when we try to open the query we
get the following message:

"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."

The only possible fields in the query that could be
causing the problem are:
Field: Expr1: [EMPLOYEE INFO]![POSITION EFF DATE]+
[Training Available]![DELAY]

Where EMPLOYEE INFO is a table
POSITION EFF DATE is a field within this table
Training Available is a table
DELAY is a field within this table

Criteria: <Date()


Field: [Training Available]![EFFECTIVE DATE]
Where Training Available is a table
EFFECTIVE DATE is a field within this table

Criteria >[EMPLOYEE INFO]![POSITION EFF
DATE]
=========================================
Any suggestions would be appreciated.

Bernie
 
I expect you might have Null values in the table that a mucking up your
query. Otherwise try
DateAdd("d", [Training Available]![DELAY], [EMPLOYEE INFO]![POSITION EFF
DATE])
 
The only possible fields in the query that could be
causing the problem are:
Field: Expr1: [EMPLOYEE INFO]![POSITION EFF DATE]+
[Training Available]![DELAY]
Click to expand...

It may be taking the / characters in the date as an arithmetic divide
operation. Try changing this to

Expr1: DateAdd("d", [Training Available].[Delay], [Employee
Info].[Position Eff Date])

One of the other possible problems is the ! character: that's used for
Form controls, not for fieldnames in a table.
 
Back
Top