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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nkll

  1. nkll

    auto fill information

    thanks for the design tip...I had not thought about that...for what I am doing though, a small geographic area...it will not be an issue.
  2. nkll

    auto fill information

    I have a table "City" within that table I have "County" , "Zip" What is the best way to design a form so the user selects from a drop down box the "city" , then the "county" and "Zip" are automatically prefilled for them?? Thanks...
  3. nkll

    Query sum

    FldValue being either "coachPitch, Jr, MachinePitch ...? I was thinking FldValue was a keyword... so no I was not replacing it but when I did I got the same results. SELECT QryRegistered2004.Division, Sum(NZ(Minors,0)) AS Total, (Sum(NZ(Minors,0))/(Select Sum(NZ(Minors,0)) From...
  4. nkll

    Query sum

    now this returns: also it asks for parameter "Fldvalue" Division Total PercentOfTotal CoachPitch 0 #ERROR Jr 0 #ERROR MachinePitch 0 #ERROR Majors 0 #ERROR Minors 0 #ERROR TBall 0 #ERROR ...thanks
  5. nkll

    Query sum

    Hello, looks like am almost there. This code provides the following results: ====================================================== Select Division, Sum(FldValue) As [Total], (Sum(FldValue) / (Select Sum(FldValue) From QryRegistered2004)) As [PercentOfTotal] From...
  6. nkll

    Query sum

    Golom, sorry... i guess i need more clarification. where is the code placed into a vb built expression or in a query that has a calculated field?? thanks
  7. nkll

    Query sum

    Probably a simple task for most, but not for a rookie. I have a table with a division field in it. The division field has entries such as (minor, major, pro). I would like to create a summary query/report that would look something like this: Division Total Percent of Total Minor...
  8. nkll

    auto fill a field in form

    Thanks...works great...this is great forum for rookies.
  9. nkll

    auto fill a field in form

    Keeping this real simple as an example. A form has two fields: 1)Name1 2)Name2 Is there a way to have Name2 automatically populated with the value that is typed into Name1 ?? Thanks much... Mark
See more

Part and Inventory Search

Back
Top