Search results for query: *

... Agreed... This is the quick 1:1 transformation of an excel sheet that is about going out of control (to demonstrate that Access may be better suited). So normalization will be a next step, when people agree to transfer things. Until then I use this as a make-table query, using the table for...

Dear All, I have a query which produces the results I want, but it takes forever (ca. 25 secs on my pretty fast machine). Each line is repeated 15 times for data of different years: SELECT qryActNENK.PID, Sum([CRev2015]/1.29) AS [WS-Rev-2015], (x15) Sum([CRev2015]/1.29*CProb) AS...

Thanks, PHV... As I said before: always good to know that there are competent people who will help! Kind regards, georgesOne

Sorry for bothering you... As often: once I post I find the solution: sSQL = sSQL & "IIf(" & rst.Fields(k).Name & " <> " & rst.Fields(k - 1).Name & ", " & rst.Fields(k-1).Name & " & ' and ' & " & rst.Fields(k).Name & ", '') AS MMove, " Thanks anyway... always good to know that there are...

Hi All, I am fighting with a query... A part of it goes like sSQL = sSQL & "IIf(" & rst.Fields(k).Name & " <> " & rst.Fields(k - 1).Name & ", " & rst.Fields(k).Name & ", '') AS MMove, " This works and means: if the value of a certain field(k) <> the value of another field(k-1) then show the...

Hi Duane, Actually I am on my way... your suggestion works (in a smaller test db). Thank you very much! Probably you will not read the sad news. Kind regards, georgesOne

Thanks for the suggestion and quick response, Duane. I understand and will try - unfortunately the query is already very complex (and will become more complex having many interdependant fields - I needed to separate it in three queries to meet Access field limits) - more than 12000 letters (yes...

Sorry the queries are of course SELECT A.ID, A.MS200810, A.MS200811, A.MS200812, IIf(A.MS200812 = A.MS200810,"","X") As GOMS FROM tblMiles AS A and SELECT A.ID, A.MS200810, A.MS200811, A.MS200812, IIf(bss_fGetDate1() = bss_fGetDate2(),"","X") As GOMS FROM tblMiles As A Thanks, georgesOne

Dear All: I have a select query, which at one part needs variable vield names via a vba function. The following query works: Select A.ID, A.MS200810, A.MS200811, A.MS200812, IIf(A.MS200812 = A.MS200810,"","X") As GOMS However the query: Select A.ID, A.MS200810, A.MS200811, A.MS200812...

Thanks a lot... finally it worked with your help - I obviously always need confirmation by others! There was actually another error, which I introduced when combining two strings, so even when my 'switch' string was correct, I got an errror (and after many hours I did not realize that anymore)...

Hi All: I have this 'simple' (and working) query SELECT A.ID, A.[201409ST], Switch([A].[201409ST]="New",1,[A].[201409ST]="M0",2,[A].[201409ST]="M1",3,[A].[201409ST]="M2",4,[A].[201409ST]="M3",5,[A].[201409ST]="vHVM",6,[A].[201409ST]="rhVM",7,[A].[201409ST] Like "*XxX*",8...

I created the test form with same report configuration... yes, looks like the original form is corrupted as it works OK there. Thanks for your advice! Best, georges

I am creating a test form/report now to see what happens.... Thanks for the time being.... georges

I have moved the report "rptInst3" into the group header (where the other reports reside which I can reference) and it works also for "rptInst3" then. Put back in the report footer and I get the same error again. Best, georges

Probably not the issue... When I select the control... in the property sheet appears: Selection type: Subform/Subreport and in the combobox below "rptInst3". When I click the "Other" tab under Name appears the same "rptInst3". Best, georges

That was quick... I will do and let you know. Thanks anyway, georges

Dear All, I have an access form ("frmCover") which displays an access report ("repMonthly") with four subreports ("rptInst1", "rptInst2", "rptInst3", "rptInst4"). The first two subreports are in a group header section of "repMonthly". I successfully reference their recordsource - e.g. for...

...and then: can I replace two or more items? This was my afternoon topic... But so far no success. Best, georges

Great, thanks a lot. GeorgesOne

Dear All: I use the following code snippet (replace function) to modify the attributes of a text item in a rich text box (Topic1 is a textbox, sFieldName is a variable) ..... Const sTagColor = "<font color=""""red"""">" Const sTagLarge = "<font size=""""3px"""">" Const sTagEnd =...