Search results for query: *

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.

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

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

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

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

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

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

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

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