I need to run an update to increment an ID number, starting at a certain value and adding 1 for each record.
Currently I have a separate table (named fCallID) that contains the starting number in a field called newCallID. The current value is 131200
I need to update the CallID field in the fCalls table. The CallID field is blank for all 50000 records. I want to start with the newCallID value of 131200 and add 1 for every CallID in the fCalls table.
I want to run this one time from a query. Note: the primary key of fCalls is mid.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …