UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Insert Incrementing Number Into Query Result, Access 2013    
 
   
gint32
post Mar 7 2019, 02:10 AM
Post#21



Posts: 368
Joined: 8-May 09
From: Australia


Thanks for your suggestions, I will give it a go
Go to the top of the page
 
theDBguy
post Mar 7 2019, 11:12 AM
Post#22


Access Wiki and Forums Moderator
Posts: 75,710
Joined: 19-June 07
From: SunnySandyEggo


Hi. Pardon me for jumping in... I may be too late to the party but maybe take a look at this one as well when you get a chance. Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
gint32
post Mar 30 2019, 11:43 PM
Post#23



Posts: 368
Joined: 8-May 09
From: Australia


Re-As <June7> points out, using a report's Running Sum property would be simpler. Is there a reason you need to have the 'running sum' ONLY in a query?

Hi

Still trying to figure this out, do you have an old report where I can look and see where it and how its done with Running Sum properties or samples I can tweek

Gerry.
Go to the top of the page
 
gint32
post Mar 30 2019, 11:47 PM
Post#24



Posts: 368
Joined: 8-May 09
From: Australia


Hi, I have downloaded the sample from the link, but I have had a look previously at serializing before but I am just to thick to be able to get my head around how it works thoroughly, so i'd like to try going down the report avenue if I get a working sample to play with as this is the only way i learn. is by chopping up already established methods, thanks
This post has been edited by gint32: Mar 30 2019, 11:47 PM
Go to the top of the page
 
June7
post Mar 31 2019, 12:31 AM
Post#25



Posts: 648
Joined: 25-January 16



See item 2 in this article https://accessexperts.com/blog/2015/07/28/w...ring-in-access/

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
gint32
post Mar 31 2019, 02:31 AM
Post#26



Posts: 368
Joined: 8-May 09
From: Australia


thanks I will give it a try ..cheers for your help
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2019 - 09:28 PM