Recent content by YNWA

Alot of it came from Northwind mate so all over the place.

Think I fixed it with Nz function.

I think it is down to this bit of code: Extended Price: CCur([Quantity]*[Unit Price]*(1-[Discount])) Could that be the issue?

What are you trying to convey?

The error happened today. The client last used the DB on Friday and it was fine. The 2 other queries calculate fields to feed into the original query error. Having just been looking closer at the make up of the original query, I found those 2 queries feeding it. I tried to run them to see if...

Order Price Totals is calculated to give Sub Total. it will be the Expressions used to calculate but why would it error today when its had a years worth of data in?

I notice I get this error on 2 other queries which feed that code above. Order SubTotal: SELECT [Order Details].[Order ID], Sum(CCur([Unit Price]*[Quantity]*(1-[Discount])/100)*100) AS Subtotal FROM [Order Details] GROUP BY [Order Details].[Order ID]; Order Price Totals: SELECT [Order Details...

It did do yes. For the past year. Now today it doesn't.

Yes. But now if I go to proper database and try what you said it doesnt work. Not sure if another step has effected it. But not working.

It is working now.

Says Syntax error. The queries are set up using Query Builder not pure SQL.

If I input an order its ok. Its just the displaying of active and completed orders on the forms. I think.

Deleted all of Feb data and still getting the message.

I aint changed anything. The client has the database and says they haven't changed anything. So they might have and not say. I have a backup that does work and nothing seems to have changed in the structure. I will delete some data and see what happens.

The message I get is: 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)