Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. georgesOne

    Complex and thus slow 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...
  2. georgesOne

    Complex and thus slow query

    ...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 [WS-Rev-RA-2015], (x15) IIf(Sum([CRev2015])=0,0,Sum([CRev2015]/1.29*CProb)/Sum([CRev2015]/1.29)) AS [WS-RAdj-2015], (x15)...
  3. georgesOne

    SQL Query Syntax

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

    SQL Query Syntax

    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...
  5. georgesOne

    SQL Query Syntax

    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...
  6. georgesOne

    Need variable field names in SQL query

    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
  7. georgesOne

    Need variable field names in SQL query

    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...
  8. georgesOne

    Need variable field names in SQL query

    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
  9. georgesOne

    Need variable field names in SQL query

    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...
  10. georgesOne

    Transform sql query in vba access query

    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)...
  11. georgesOne

    Transform sql query in vba access query

    ...Like "*XxX*",8, IsNull([A].[201409ST]),9) AS Rating FROM tblWDefinition As A; and want to change it into vba, but I cannot. The full query is more complicated, but I am sure this is the culprit. Any help available? Thank you so much, georges
  12. georgesOne

    Form/Report Issue

    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
  13. georgesOne

    Form/Report Issue

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

    Form/Report Issue

    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
  15. georgesOne

    Form/Report Issue

    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
  16. georgesOne

    Form/Report Issue

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

    Form/Report Issue

    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...
  18. georgesOne

    Formatting a rich text box

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

    Formatting a rich text box

    Great, thanks a lot. GeorgesOne
  20. georgesOne

    Formatting a rich text box

    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 =...

Part and Inventory Search

Back
Top