m17347047711116
Registered User.
- Local time
- Today, 14:44
- Joined
- Feb 4, 2002
- Messages
- 68
I have the following tables:
[Production]
[Excellence]
The tables are linked by Machine_No
I have 3 Queries based on the above Tables
[Production_Query] - This Query works fine
[Excellence_Query] - This Query works fine
[Production_Excellence_Query] - This Query is a comination of the above 2 Queries and includes an expression of Pcs/ hour. The expression is as follows
Avg(Production_Query].[Pcs]/[Excellence_Query].[Run Time])
The above combine Query works fine on small date ranges, when I increase the date range to a period of a month I get an error message indicating the expression is to complex to be evaluated ......... something like that.
Why will this query only work on smaller date ranges and not on any date range ???>?
[Production]
[Excellence]
The tables are linked by Machine_No
I have 3 Queries based on the above Tables
[Production_Query] - This Query works fine
[Excellence_Query] - This Query works fine
[Production_Excellence_Query] - This Query is a comination of the above 2 Queries and includes an expression of Pcs/ hour. The expression is as follows
Avg(Production_Query].[Pcs]/[Excellence_Query].[Run Time])
The above combine Query works fine on small date ranges, when I increase the date range to a period of a month I get an error message indicating the expression is to complex to be evaluated ......... something like that.
Why will this query only work on smaller date ranges and not on any date range ???>?
