i have some existing data and have to add a new field which increments from 1 for every 10 records in the table, is there any way to do this using...

Apologies for posting this again, but I was hoping someone who didn't read this last time could shed some light on this for me. For various reasons I have a...

Is there a function that would allow me to add a incremented # to a select query? For example, a query returns... Name ------ Fred Joe Barney .... and I...

I want to be able to insert a whole bunch of records from one table into another table using a query. I need to be able to set/increase the value of a field...

How do you add an increment number to a Make Table query such that each record in the new table can have a unique number? (Other than concatenating multiple...

Hi, I am puzzled and can not figure out how to generate an incrementing number and insert it into a table. I have a static table, which I create...

I need to see if there is a way to assign a sequence number to a particular record within a query. For example...If an employee was hired multiple times...

I am trying to create a field in a query which produces an incremental number for each duplicate record and then starts again. For example: Student ID ...

I would like to have an incremental ID Number created by a query EG.: ID product R1000-1 xyz R1000-2 fre R1000-3 abc Thanks

When appending batches of records into a master table, I want ID numbers automatically created to start with the next available record number after the...

In Column A I have an ID #. Column A Column B 1 1 1 2 2 1 2 2 2 3 3...

I wish to create an Incremental Number field for this Make-Table Query which is based on the records from another table. So each line of records in the new...

Good Day, I currently use three tables for my products, all of which have "custom" order id's. tblStock - orderid = "NW-" 0000 -- Autonumber tblcustom -...

Hi, I have a table, which contains Last Name of the customers I have a form, which contains a "textbox" and a command button. The textbox will take last...

I've got a listbox which operates off a query: SELECT FileName.fn_Filename, FileName.fn_Filepath FROM FileName WHERE (((FileName.fn_Filename) Like "*" &...

Could someone help me tweak my below function (that can be run via query expression) so that it incrementally adds 1 to each row in a given group? I...

Working with the following: SELECT JeffC_A_Dates., JeffC_A_Dates., JeffC_A_Dates_1.Admit AS InitialAdmit, JeffC_A_Dates_1.Discharge AS InitialDisch,...

If I have a table with one column containing the following records: FieldA A A A A B B C

Hello, There is a line number in a detail form for a list of an employee's expenses. As far as I can see I cannot use the "auto" number feature as the...

Hi everyone, I have two records in a table (for example 25/01/05 and 30/01/05) Is there a way I can write a query which will return those two days and create...