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 Chriss Miller 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: *

  • Users: nkll
  • Order by date
  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

Part and Inventory Search

Back
Top