Search results

I have a table which has lines 1-18. On completion of the last line the cursor goes to line 19 to enable entry of new record. I have a form based on this table which has a number of calculated fields. The formulas are carrying down to row 19 even though I have not entered a new record. This is...

I do not want to update the table. What I eventually want to achieve is a form with a number of calculations based on 3 fields in a table with fixed values, and 2 text boxes to enter variable values. My problem is getting the result of a calculation returning a different value which I can then...

Running the Query produces error "Undefined function Test in expression". The text box on the form produces an error. I don't particularly want to store the result. I only created the calculated field as I am not sure whether you can do a calculation on a calculation in a query

Differences are whole numbers

I have a calculated field in a table which returns the difference of 2 values. If the difference is between 1 and 18 I want to return a new value of 1, between 19 and 36 =2 and 37 and above =3. How do I do this?

Just a thought. I am trying to achieve a live scoreboard to display the current competition. We only run one competition each day. Instead of having to establish the ID of the competition could we not load the report having todays date. I have bought a VBA coding text book and may hopefully be...

The record source of the report is a query called Results which has a field called 'Report' set to true. The ID comes from the CompID field in the Competition Table

The database is for a golf club and primarily deals in scores. The Club Championships are played over 3 rounds and each of these rounds is a competition in its own right and has its own result. These rounds are played on different dates and players handicaps may have changed from 1 round to the...

I do not know if this has any bearing or not. Each competition has its own ID and the form used for entering the data has a check box which makes the ID for the Report the current ID. Your code has produced the following error Run-time error '3061; Too few parameters. Expected 1 Debug highlights...

I have a report which displays live scoring. I have two linked databases. One for input and the other displaying the report on a TV as a 2nd monitor. Data is updated on the report timer. It works fine until the screen is full. I have another function which scrolls down but stops when it reaches...

Thanks for your help. I think I can understand what you are doing. The query that I originally used was actually the result of 3 queries. By making changes to the source table I have now been able to obtain the result from a new single query. This has resulted in having blank cells instead of...

I have 3 fields (R1,R2,R3) containing scores and am trying to extract the best 2 scores. One of the major issues is that one or more of the 3 fields could contain a zero value. R1 R2 R3 Result I get 80 75 0 80 75 155...

hi, I am a retired self taught access player. To call myself a programmer would be a bit of a liberty. Most of my problems have been solved by trial and error and I am sure that some of my solutions could have been solved in a simpler way. The database I have been working on is for my golf club...