Search results

Good point Mihail, The previous solution does not work. Say, we are in BizNo called "A", are in a subform called "AA" and we would like that in this subform "AA" it should be impossible to write twice the same 'place'. AA_LOAPDORT = OK AA_LOADPORT 2 = OK AA_LOADPORT = "NO! ALREADY EXISTING"...

Hi burrina Thank you very much, it works perfectly. However, I'm wondering, why is the first part for? I only put the second part and everything works, so why change control source and name? Thanks again for your help!

Dear all, I have a mainform (F_main) and a subform associated (F_place). F_place is the form of the table T_place. T_place is linked to F_main by the field "BizNumber". I also have the field "Place" and of course the "Place ID" (primary key) in T_place. "Place" in linked to a combobox (in...

Yes you are right, they don't do the same thing (I just said that they returned the same result). But as MyValue = 0 when IsNull([UK_Working days].[Calendar date])=True I think that: The first solution fills what's before Date() then fills the 0 when IsNull.. then fills the values The second...

Well, I think that they return the same thing. They both return [MyValue] if [Calendar_All Dates].[Calendar date]<Date() OR IsNull([UK_Working days].[Calendar date])=True And return (SELECT [MyValue] FROM [Query222])) otherwise. Is there one faster?

It was pretty clear. One question, I'll be working with a lot of data, which one of these 2 solutions is faster? IIf([Calendar_All Dates].[Calendar date]<Date(), [MyValue], IIf(IsNull([UK_Working days].[Calendar date])=True,0,(SELECT [MyValue] FROM [Query222]))) or IIf([Calendar_All...

Yes Yes and Yes! I needed to add a If [Calendar_All Date].[Calendar Date]>Date() But yes it's perfect! Thanks a lot :)

:D Ok I got the single value

i. Ok, I tried but I see all the dates with all the values. ii. Yes, 2 fields only. Dates ascending, MyValue criteria > 0 total min (or max, I tried both) iii. Syntax error. My SQL code: "SELECT [Calendar_All Dates].[Calendar date] ,[Calendar_All Dates].[MyValue] (SELECT TOP 1 [Calendar_All...

I'm getting used to it ;) 3) i) "Cannot have aggregate function in WHERE clause (Last([MyValue])>0) ii) Does not do anything (I used Totals => Min on the dates) iii) Invalid syntax. Should I write it in SQL?

This was my error, well done! Yes I have it now thanks :)

"We'll do something later" on every line. -I guess it doesn't know how to evaluate what's qryGoodDates.[DateField]. -Why don't I add a field [MyValue] on the qryGoodDates? So it will put only the values corresponding to the dates?

I put Between 2 and 6 and everything's ok. I see the good dates now thanks :)

Thanks a lot for your answer, Ok, I've done it and now I see only the interesting future dates. How to make the Value corresponding to these dates = to the last not = 0 record? Ben

Yes, this will be good to know first in case there is no gaps.

Hello, I’d like to repeat the last not = 0 record under certain conditions, in a table or in a query. What I have: Calendar_All Dates Calendar date MyValue 7/6/2014 0.00 7/7/2014 108.94 7/8/2014 107.71 7/9/2014 107.07 7/10/2014 105.89 7/11/2014 105.30 7/12/2014 0.00 7/13/2014 0.00...