Query not updated

  • Thread starter Thread starter Lasse T
  • Start date Start date
L

Lasse T

Hello !!

I have this annoying problem with a query.

I have a query that shows all orders wich has not yet been invoices.
Sometime the query shows zero at the ordertotal amount. It does not happend
very often so I tried to make a lot of orders while looking directly into
the query. I then got one zero amount so I checked back in the order form to
ensure that it was not zero and when i looked back into the query the amount
was there.
I can not tell for sure if the underlying table has the amount but sins the
order form is closed and the query gets the amout after some klicking around
the amount has to be in the table.

This problem makes some invoices coming out with an ordertotal that is zero.

Is there anyway to refresh or update the query to make sure it has all the
recent values?

Thanks in advance.

Lasse T
------------
 
You can forget about this question. I foud out that it is a macro that dont
always run.

Lasse T
 
Back
Top