Topics Search

Increasing values

Increasing values
Views: 0
I have a field with number values

id_field contains numbers like 1,2,3,4.(some of them are repeated)

In a form the user introduces for example 2, then all the values >= increase by 1, how I do that?
1-1
2-2
3-1
4-1
5-2
6-3
7-4
8-5

the user introduces 4 then.

1-1
2-2
3-1
4-1
5-2
6-3
7-5 (change id +1)
8-6 (change id +1)
9-4 (new)

or just tell me, this is possible in access or not?
Sponsored Links:

More topics

 

Update query for numbering the records

Preview
Could anyone Pls. help me to form an expression in the update query which will be using to update the numbers in increasing orders for a set of records in a table. For example, a table contains fields like (Customer Name/S.No/Items Description/Unit/Price/Invoice no.). The update query shall be used to enter the Invoice no. in increasing order for the set of Customer name in the fields
 

Specific autofill in form

Preview
I have a form in Microsoft Access with barcodes for every single product. First I enter the barcode and other values for one product.

Then I enter a new row and my next barcode should be +1 from the first one. Example: the first barcode is C2025540 and the second should be C2025541, the third C2025542 and so on.

Can I somehow enter just the first, and then the next ones (second, third .) fill in automatically by increasing it by 1.
 

Calculate if number of records is increasing or decreasing

Preview
I have a database with a table of every client (current and cancelled clients) and a query just showing the current clients.

I want to show if the number of clients is increasing or decreasing, but I'm unsure how?

I was thinking maybe calculating the average number of records for this month, and then seeing if the current client is above or below this average.

In VBA I have CRecords = ("*", "qCurrentClient")
TRecords = ("*", "tblClientDetails
 

Macro for increasing table values

Preview
We have a list of students, all their information, and the grade that they are currently in. There is a field(called: Grade) in a table (called: students), and at the end of the year, i need a macro that increases their grade by 1.
 

Query to select only records with certain values

Preview
I have a large database with over 1MM records. It is a database of reservation records, with 15 separate tables. I am attempting to do two things: find records containing ONLY certain field values, and none of the other possible values, and find records that do NOT contain those values.

Example: I need to find records that contain one of three values, and also contain one of 3 other values, but no additional values. The record needs to contain one of these 3 values - UO ADM, UO ADM FL or FLEX ADM, and it also needs to contain one of three other values - CW INCLUSION, TP TRANS or EPA. I don't want records that include any other values
 

Similar to countif

Preview
I have a current dataset that is in excel however has become to large. Currently in that data set I have a key associated with each record for lookup purposes however that key is not exclusive. For instance multiple records will have the same key. For lookups I have used the formula =countif($B:B2,B2)&B2. The result as I copy this formula down to the next row is each new occurrence of the same key will have an increasing value associated with it. This allows me to set a vlookup to pull the 1st record the 2nd and so forth.

I am going to pull all of the data into access and need to be able to recreate this key so I can put it back in excel as values and then perform the lookups. Because of limited use of Access in my corporation I can not do all of the work in Access
 

chart using variable values

Preview
I have some code behind a form which calculates some simple values and places them in unbound boxes. All these values are stored in variables such as a1, a2, a3 and b1, b2, b3, etc

I would now like to make a line graph with those values on the same form, but when I try to use the "Graph" icon it asks me for a query to get the values from. How can I create a graph using known values instead of a table/query
 

Problem with Listbox update via Combobox and Field Values

Preview
I have a listbox(includesA) which works via combobox(sel_mac) update sort and the field values that were selected prior, however, the values it posts are numeric ID values and not theactual field values I want to be shown in the listbox.
I have some code below that pushes the updates from the combo to the list.
 

How to transfer values from forms to table

Preview
am having problems with values on my forms in access.the thing is, in my form i change some values by using control source and put some formulas to control source like =date+102 . then im wondering why the values are not reflecting to my tables.
 

Need to calculate a number of values and display values to user

Preview
I'm working a project where I need to calculate the EVM for each project in the db. I need to query a table for the values I need and do some calculation with the values then display these values.

I'm thinking I should be able to use a listbox for display if I could figure out how to gather all the data I need and calculate the values.

The challenging part is I have to perform 14 different calculations for each project. So my question is how do I do this when I have to perform a different query for each calculation?