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?
the user introduces 4 then.
7-5 (change id +1)
8-6 (change id +1)
or just tell me, this is possible in access or not?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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.
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.
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
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
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
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
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.
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.
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?