Recent content by PaulC

Thanks very much. I'm off for some haoppy reading boblarson you're a superstar I thank you Paul

Always open to suggestion. Better to be led than stumble blindly on. Thank you for your input, it is very much appreciated. As you suspect I'm used to Excel (the short and wide analogy is superb), so have much to learn Any pointers on normalization reading material or reference books that will...

I'll read the link tonight, thanks for supplying it. To elaborate: I am trying to create a database to store records in a single table that contain up to 77 variables. There are 5 variables that define the unique identity and 69 positions that are a record of defects counted. The 3 other...

boblarson. Further to above I have changed my query fields. I deleted the Position '*' fields and created new calculated fields using the expression 'EPD6:[Cal Value]*[Position 6]'. In the report I now use EPD6 as a control source instead of =[EPD Records Query].[Cal Value]*[EPD Records...

Thank you both for your replies Kusumerumaal. If I try your first 2 suggestions a message box pops up with the title 'Enter Parameter Value' with 'EPD Records Query' between the title and an empty text box when I switch from design view to normal (?) view. The third suggestion returns '#Error'...

Hello Being new to access (1 week) can I output a calculation in a report textbox or should I have worked it out before hand somewhere else? I have a text box with this formula (expression?) "=[EPD Records Query]![Cal Value]*[EPD Records Query]![Position 6]" in the control source box in...