Recent content by potts

Apologies Pat. However, the old thread went cold about a week ago and I am getting quite desperate to resolve the issue. I'll try to be more patient in future. Sorry. But, if you do have any suggestions, it would be appreciated.

I have a form with two subforms. The second subform is really a subform of the first subform - confused? Ok. MainForm has many records in SubForm1. SubForm2 has many records in SubForm2. I know I can have two levels of sub forms in a main form. However, the problem with this is that I want...

Hi This is kind've a re-visit to a thread I posted a few weeks back. I have stored a number of work and rest periods by position for each activity in each session. What I now need to do is summarise the contained information by position for each session. I want the following information in...

I'm sorry. I still can't get it to work. All I get when I run the query is the field headings with no information i.e. it's blank. Any suggestions?

Can't say I have. How would I apply it to my current scenario?

I've had a look on the site but can't find an answer to this question - then again, I may not be searching the correct terms!! I have a sub form that contains periods of work and rest for various groups in a session (mainform). I want to be able to calculate the percentage of the work that was...

Sorry. The original post was titled "auto update ratio calculation". The gist of it is that I have 3 bound controls on a form: variable1, variable2 and the ratio of the two of them. What I want to do is be able to insert values into two of the three variables and have the third one calculate...

I recently posted a question concerning calculating ratios on a form, and was sent some code to try out. Unfortunately, I cannot get it to work. I don't think it is a problem with the code itself, rather where and how I am attaching it to the form. I'm sorry not to be giving more...

I have a table that contains 4 pieces of info: Session Position Work Rest What I want to do is calculate the % of work that was less than 10 for each position in each session. Any ideas??

Sorry, perhaps I should have been more clear. I knew to build it in the modules section, and that I could call it from a form or query, or control. It's the how to call it that I'm having hassle with, both in a form and query. It would be great if you could show me how. Thanks

Thanks for the reply, but at the risk of sounding ridiculously stupid, where do I attach the module - the form itself, control box, or not to anything? Like I say - cobwebs!!!

It's been a while since I built an access application and so this could be relatively simple - might just need the cobwebs cleared out of the old noggin! I have a table that contains two variables (var1 and var2) and the ratio of one to the other i.e. ratio = var1 / var2 Now I know I can...

I have created a report with two subreports. These are all linked by a CustomerID. The subreports contain subtotals that are needed for the calculation of the grand total (an unbound text box using an expression for the calculation) on the main report. In general the grand total calulation...

How do you use the Nz function?

sub-reports ar linked via the CustomerID which appears on both the main and sub reports. Also, they are contained in the detail section.