Search results for query: *

Hi bunch, After spending too many hours I decided to try my luck here ;-). I am trying to run a query that calls a function which receives a date and returns an integer. But somehow i keep getting "Data tye Mismatch". for example: SELECT Orders.CloseTime FROM (Orders INNER JOIN...

Thanks for this post rudy, I thought about it, but I ewas worried, that I couldn't calculate it per minutes (not hour), but I think I can (by using "n" instead of "h"). Why didn't you use "Between" instead of all the "Or"s, this kind of usage will have to...

Hi, Let me explain (I have been trying to figure this out for days): 1) I have a wide range of time, lets say one year. During this year many orders have been taken. 2) I would like to find all the orders which have been taken from monday 15:00 untill tuesday 17:00 (for instance). 3) What I...

Hi Mike, Thank you for your help, can you show me the code of openeing a query which is defined in my project and adding the string to it? I am defining a queryDef in my code and it doesn't recoginize it as a data type. Is there a diference in access 97 and 2000,XP? I think I am confused with...

Hi, I have read your discussion, very interesting. I am having a similar problem, but I am trying to find a different kind of solution. Tell me if you think its possible: Define a query in your project with ONLY the common fields, you would always like to show. In your code, get the query...