Topics Search

Find Maximum Value of a Field and Add 1

Find Maximum Value of a Field and Add 1
Views: 45
When I create a new record in a form, I need the ID field on the form to automatically be the highest number found in the ID field plus 1. The table name is tblContacts. Is there a formula for this and where do I put it? Autonumber is not an option
Sponsored Links:

More topics

 

Add 1 to a field when another filed reach a certain value.

Preview
I was wondering if anyone could help me with my problem. I'm new to MS Access 2003 and I've searched for an answer many times and still found none.

I made a form which is bounded to a table. The form or table has 2 fields named "points" and "free_time". The field "points" has a validation rule of <=300, which means - that field should have a maximum input value of up to 300 only. Now, what I was aiming for is to find a formula or code that when the field "points" reaches its maximum value which is 300, it will automatically add 1 (one) to another field called "free_time".

In simple terms 300 points = 1 free time, but I don't know how to make that happen in my form.

And if it's possible, after adding 1 to free_time, the field points would go back to zero since it cannot exceed the value
 

Bolding a record in a field that is the max

Preview
Pretty sure this is not possible but I thought I would ask. Is there a way to bold one record in a field in a query? Instead of having the maximum show up in the totals row, I would like to bold the maximum value in a column. Is this possible? I there some function out there that bolds text?
 

How To Caluculte the maximum values from the table and assingn to the textbox

Preview
For reading this thread.
I am a beginer of access programming.

I have a problem in doing a task with my form.

Actually I have a button to add a new record which opens a new form there I enter the values to the record. But when I press the Addnew record button I want to calculate the maximum of the Identity field +1 and open the new form with that new number which I have calculated. How can I do this
 

Find 2nd or 3rd highest record with a query

Preview
There are fairly simple queries to find the maximum or minimum value for a field in a grouped by query that may have 2-3 or more groupings, but is it possible to find, say the 2nd and/or 3rd highest values and their associated fields in an ACCESS (2003) query? or must one resort to VBA programming. In either case, how is this done - if it can be done
 

Access Max Function

Preview
I am trying to find the oldest employee in a table using a simple query. I have already determined age, but, now whenever I try to find the maximum age using the Max Function, it still shows all of the ages instead of the single field.
 

Performing Function on a Row of data

Preview
I want to do something similarly to what I do in excel which is to find the minimum or maximum in a row or particular range of a row.

Example:

Name | 2008 | 2009 | 2010 | 2012

Fred | 4 | 7 | 9 | 11

Joe | 11 | 22 | 3 | 323

I want to be able to calculate the minimum or maximum number for Fred. for all 4 years.
 

Set the Maximum Characters for a Text Field

Preview
Before setting the maximum characters for a text field, you must understand database tables and be able to navigate Access 2003. Think about who will access the data and how they will use it as you plan your database table's design. Then follow these guidelines.
 

Add unbound row to form

Preview
I have created a continuous form bound to a query (X-Tab) where the detail row is a series of unbound text boxes. I then wrote some vba to populate the detail row from the query recordset.(The vba code also populates the heading row which are also unbound text boxes.)

Everything works fine except I do not know how to add or reference a new detail row when a I move to the next record in the recordset, and as a result my form shows me one row for eachrecord repeating whatever data was in the ending record.

So my question is: How do I populate the detail row so that one detail row matches one record from the recordset.

Some background. Each unbound control in the detail section is named "Col" and then a sequential number. So I have Col1, Col2, Col3, etc to Colx (the maximum field the query can return.

I have done the same with the heading being Hed1, Hed2, etc to the maximum. Now I need to be able to reference Row1Col1, Row1Col2, Row1Col3, etc and then Row2Col1, Row2Col2,Row2Col3, etc to the maximum number of records.
 

Find 2nd or 3rd highest record with a query

Preview
There are fairly simple queries to find the maximum or minimum value for a field in a grouped by query that may have 2-3 or more groupings, say the 2nd and/or 3rd highest values and their associated fields in an ACCESS (2003) query? or must one resort to VBA programming. In either case,
 

Maximum number of macros, queries, reports etc.

Preview
I am using Access 2003. Is there a maximum number of Macros, Queries, Reports, Tables, etc that I can have in a database? Is it a maximum by type of object or is it one big lump sum?