Recent content by RonieB

  1. R

    Solved Query Fields not Visible When Creating Form

    ok, I have the select query working and it will be in rows not columns. I apologize I was just trying to see if I could get it to work and spend the hour later. I am not SQL efficient and always look for ways to learn it. Simple queries I am good at lol.
  2. R

    Solved Query Fields not Visible When Creating Form

    PARAMETERS [Forms]![frmWorksheetWT]![cboWSProjSel] IEEESingle; SELECT "A-" & [WItemInd] AS [Work Item], tbl_Worksheet.ProjIdxID, tbl_Worksheet.WEstProj, tbl_SOW.SCraft, Sum(tbl_SOW.STEHR) AS SumOfSTEHR FROM tbl_Worksheet INNER JOIN tbl_SOW ON tbl_Worksheet.ProjIdxID = tbl_SOW.ProjIdxID WHERE...
  3. R

    Solved Query Fields not Visible When Creating Form

    I was curious and testing it. This is my query code: PARAMETERS [Forms]![frmWorksheetWT]![cboWSProjSel] IEEESingle; TRANSFORM Sum(tbl_SOW.STEHR) AS SumOfSTEHR SELECT IIf(sCraft='DK', STEHR, 0) AS DK, IIf(sCraft='OM', STEHR, 0) AS OM FROM tbl_Worksheet INNER JOIN tbl_SOW ON...
  4. R

    Solved Query Fields not Visible When Creating Form

    it tells me that I do not have SELECT IIf(sCraft='DK', STEHR, 0) AS DK, IIf(sCraft='OM', STEHR, 0) AS OM as part of an aggregate function. Do you mind explaining how I make it part of an aggregate function please?
  5. R

    Solved Query Fields not Visible When Creating Form

    If you don't mind my asking, where would I put the code if I were to spend the hour to build it?
  6. R

    Solved Query Fields not Visible When Creating Form

    Thank you very much for the feed back and will do the suggested changes.
  7. R

    Solved Query Fields not Visible When Creating Form

    I am trying to get the craft hour totals on the Pricing sheet data tab of the worksheet in the attached database.
  8. R

    Solved Query Fields not Visible When Creating Form

    I get this error
  9. R

    Solved Query Fields not Visible When Creating Form

    I changed it from a totals query, same thing. my query: PARAMETERS [Forms]![frmWorksheetWT]![cboWSProjSel] IEEESingle; SELECT Sum(Nz([NP])) AS NPR, Sum(Nz([PL])) AS PLR, Sum(Nz([SW])+Nz([SF])) AS STEEL, Sum(Nz([PF])+Nz([PW])) AS PIPE, Sum(Nz([OM])+Nz([IM])) AS MACH, Sum(Nz([EL])) AS ELEC...
  10. R

    Solved Query Fields not Visible When Creating Form

    I have a query that I am trying to create a subform and place on a main form. When I create the subform it works fine but when I place it on the main form it will not show and gives the error that the form is not bound. When I try to create the subform from a query, the fields of the query are...
  11. R

    Solved Update Record on Change in Check Box

    Got it and thank you again. :)
  12. R

    Solved Update Record on Change in Check Box

    I took all of the refresh out and it is still working. I thought I had to save for it to be seen. I appreciate the advice and encouragement :)
  13. R

    Solved Update Record on Change in Check Box

    I marked this as solved because it is doing what I want it to do. I do have a lot of structure reconsiderations. I am in process of changing the form to a Tabbed Form because all of the data for each item needs to be seen during the process. The initials and item type are needed to delineate...
  14. R

    Solved Update Record on Change in Check Box

    Perfect!!! Thank you so much for the assist! :)
  15. R

    Hi! Newbie here.

    Thank you. This is an awesome group. I have been helped tremendously and it is really appreciated.
See more
Top Bottom