Prev: IF ISNUMBER FIND in query design expression
Next: Currency Format Lost in Union Query
From: arlene ramirez on 27 May 2010 17:19
Does your query have a start time and end time.
If so, you can't run the query to see your time on Paper with Paper still
open as you will not have an end time and the query will (when you try and
open it) try a half calculation (that like say 1 + = intead of 1 + 1 =).

Maybe I am not understanding.

Can you post the sql so we cna see it


--
Wayne
Manchester, England.



"relativehunter" wrote:version

> I am having a problem with a form and a query. When I open the form (called
> Paper), it runs a query that adds a row to a table called Time. If Paper is
> open and I try to run a query to see my total time on the form, I get a 2950
> error. If I close the Paper form, then I have no problem calling the total
> time query. I tried doing an explicit close of the Time table in the macro
> that sends the row to the Time table, but that did not solve the problem. Any
> ideas?

 | 
Pages: 1
Prev: IF ISNUMBER FIND in query design expression
Next: Currency Format Lost in Union Query