Report error

[Guest]

Here is an error that we get for a report:

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. (Error 3071)

The expression that I believe it is causing the problem is <=Date(). Is
there a different way to get the same results.

Also, it will work just fine on one computer but not on anothers. Would
reinstalling Access 97 work?

Any help will be greatly appreciated.

 

[Duane Hookom]

Post the SQL View of your report's record source plus any other significant
information. Can you run the query?

 

[Guest]

SELECT [Load Table].[Date Shipped], [Drop Table].LoadNumber, [Drop
Table].DropNumber, Carrier.Carrier, [Load Table].[Full Load], [Load
Table].Shipped, [Drop Table].[Delivery Date], [Drop Table].City, State.State,
[Load Table].[53FootTrailer], [Drop Table].Customer
FROM (Carrier INNER JOIN [Load Table] ON Carrier.[Carrier ID] = [Load
Table].[Carrier ID]) INNER JOIN (State INNER JOIN (Products INNER JOIN ([Drop
Table] INNER JOIN [Drop Detail] ON ([Drop Table].DropNumber = [Drop
Detail].DropNumber) AND ([Drop Table].LoadNumber = [Drop Detail].LoadNumber))
ON Products.[Product ID] = [Drop Detail].[Product ID]) ON State.StateID =
[Drop Table].StateID) ON [Load Table].[Load Number] = [Drop Table].LoadNumber
WHERE ((([Load Table].[Date Shipped])<=Date()))
GROUP BY [Load Table].[Date Shipped], [Drop Table].LoadNumber, [Drop
Table].DropNumber, Carrier.Carrier, [Load Table].[Full Load], [Load
Table].Shipped, [Drop Table].[Delivery Date], [Drop Table].City, State.State,
[Load Table].[53FootTrailer], [Drop Table].Customer
HAVING ((([Load Table].Shipped)=No))
WITH OWNERACCESS OPTION;

I have no problem running the query and/or the report on computer, it is
another computer is having the problem. I'll check to see if they can run
the query.

Thanks!

 

[Duane Hookom]

Whenever something works on one computer and not another, check the
references.

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Duane Hookom
MS Access MVP
--

SELECT [Load Table].[Date Shipped], [Drop Table].LoadNumber, [Drop
Table].DropNumber, Carrier.Carrier, [Load Table].[Full Load], [Load
Table].Shipped, [Drop Table].[Delivery Date], [Drop Table].City,
State.State,
[Load Table].[53FootTrailer], [Drop Table].Customer
FROM (Carrier INNER JOIN [Load Table] ON Carrier.[Carrier ID] = [Load
Table].[Carrier ID]) INNER JOIN (State INNER JOIN (Products INNER JOIN
([Drop
Table] INNER JOIN [Drop Detail] ON ([Drop Table].DropNumber = [Drop
Detail].DropNumber) AND ([Drop Table].LoadNumber = [Drop
Detail].LoadNumber))
ON Products.[Product ID] = [Drop Detail].[Product ID]) ON State.StateID =
[Drop Table].StateID) ON [Load Table].[Load Number] = [Drop
Table].LoadNumber
WHERE ((([Load Table].[Date Shipped])<=Date()))
GROUP BY [Load Table].[Date Shipped], [Drop Table].LoadNumber, [Drop
Table].DropNumber, Carrier.Carrier, [Load Table].[Full Load], [Load
Table].Shipped, [Drop Table].[Delivery Date], [Drop Table].City,
State.State,
[Load Table].[53FootTrailer], [Drop Table].Customer
HAVING ((([Load Table].Shipped)=No))
WITH OWNERACCESS OPTION;

I have no problem running the query and/or the report on computer, it is
another computer is having the problem. I'll check to see if they can run
the query.

Thanks!

Post the SQL View of your report's record source plus any other
significant
information. Can you run the query?