Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Custom Counter in microsoft.public.access.queries
Started 1 month, 3 weeks ago by AccessIM
I have a table that tracks employee attendance records. In the table, I am calculating an accumulative total column for points. This took me quite some time to figure out but I finally did it and it works perfectly but now I am seeing that using an autonumber field for this purpose is not the best practice. Currently, I ...
Site: Discussions in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile
Forum: microsoft.public.access.queries  microsoft.public.access.queries - forum profile
Total authors: 2 authors
Total thread posts: 6 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

KARL DEWEY replied 1 month, 3 weeks ago
>>an append query that re-enters the records in the correct order of EmployeeID and IncidentDate Why do you care the order they are in the table? Try this select query --- SELECT qryTotalDetail.EmployeeID, qryTotalDetail.SSN, qryTotalDetail.INCIDENTDATE, qryTotalDetail.TYPE, qryTotalDetail.POINTVALUE, (SELECT Count(*) ...
Size: 2,900 bytes
Customize:  Customize "<b>Reply 1</b>: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

AccessIM replied 1 month, 3 weeks ago
Thank you, Karl. I guess I thought the order of the table mattered to get the results I wanted. Here is how I would like the results to look and I have accomplished this with the extra manipulation and autonumber: EmployeeID SSN INCIDENTDATE TYPE POINTS ACCUMTOTAL 10 ...
Size: 5,747 bytes
Customize:  Customize "<b>Reply 2</b>: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

KARL DEWEY replied 1 month, 3 weeks ago
>>The first thing I noticed was that my desired results does not include the incidents that don't generate points for the employee. There is nothing in what I posted that would eliminate records that have zero as POINTVALUE or that POINTVALUE is null. The reason the sequence number field that is consecutive from one record to...
Size: 7,188 bytes
Customize:  Customize "<b>Reply 3</b>: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

AccessIM replied 1 month, 3 weeks ago
Oh my... I am going to do a little more testing from home tonight but I think that is it! I cannot thank you enough for that knowledge, Karl. I have been struggling with that for days and you were able to help me within hours of my first post. I will also be able to carry this over to another database I created in which I used the ...
Size: 8,440 bytes
Customize:  Customize "<b>Reply 4</b>: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

KARL DEWEY replied 1 month, 3 weeks ago
It is just a 'typical' 'Ranking in a group' query. -- Build a little, test a little. "AccessIM" wrote: > Oh my... I am going to do a little more testing from home tonight but I think > that is it! I cannot thank you enough for that knowledge, Karl. I have been > struggling with that for days and you ...
Size: 9,285 bytes
Customize:  Customize "<b>Reply 5</b>: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

 

Top contributing authors

Name
Posts
AccessIM
3
user's latest post:
Custom Counter in...
Published (2009-11-03 13:39:00)
&nbsp; Oh my... I am going to do a little more testing from home tonight but I think that is it! I cannot thank you enough for that knowledge, Karl. I have been struggling with that for days and you were able to help me within hours of my first post. I will also be able to carry this over to another database I created in which I used the same procedure of deleting and recreating a table over and over. I appreciate all your help and...
KARL DEWEY
3
user's latest post:
Custom Counter in...
Published (2009-11-03 14:09:00)
&nbsp; It is just a 'typical' 'Ranking in a group' query. -- Build a little, test a little. &quot;AccessIM&quot; wrote: &gt; Oh my... I am going to do a little more testing from home tonight but I think &gt; that is it! I cannot thank you enough for that knowledge, Karl. I have been &gt; struggling with that for days and you were able to help me within hours of my &gt; first post. I will also be...

Related threads on "Discussions in microsoft.public.access.queries":

Custom Counter Question (Repost) in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Custom Counter Question (Repost) in microsoft.public.access.queries
Custom Counter Question (Repost) in microsoft.public.access.queries
Function for a counter in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Function for a counter in microsoft.public.access.queries
Function for a counter in microsoft.public.access.queries
Want a counter for Access Query results in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Want a counter for Access Query results in microsoft.public.access.queries
Want a counter for Access Query results in microsoft.public.access.queries
Value Counter - Please Help in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Value Counter - Please Help in microsoft.public.access.queries
Value Counter - Please Help in microsoft.public.access.queries
Need a Dynamic Record Counter Function for Query...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Need a Dynamic Record Counter Function for Query Records!!!! in microsoft.public.access.queries
Need a Dynamic Record Counter Function for Query Records!!!! in microsoft.public.access.queries
Custom Function? Another Method? in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Custom Function? Another Method? in microsoft.public.access.queries
Custom Function? Another Method? in microsoft.public.access.queries
Goup Data by a Custom Week in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Goup Data by a Custom Week in microsoft.public.access.queries
Goup Data by a Custom Week in microsoft.public.access.queries
Parameter Query Using A custom form in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Parameter Query Using A custom form in microsoft.public.access.queries
Parameter Query Using A custom form in microsoft.public.access.queries
Use of a custom commandbar in 2007, created in 2003 in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Use of a custom commandbar in 2007, created in 2003 in microsoft.public.access.queries
Use of a custom commandbar in 2007, created in 2003 in microsoft.public.access.queries
Custom Order By in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Custom Order By in microsoft.public.access.queries
Custom Order By in microsoft.public.access.queries

Related threads on other sites:

Custom Counter in Replica Database in...  Discussions in microsoft.public.access.replication - site profile microsoft.public.access.replication - forum profile Custom Counter in Replica Database in microsoft.public.access.replication
Custom Counter in Replica Database in microsoft.public.access.replication
Creating samples for a custom counter cloths. it's the...  Twitter / lushacat - site profile lushacat - forum profile Creating samples for a custom counter cloths. it's the same as a floor cloths but made to fit a kitchen counter. Fleur de lis design 8:06 AM Sep 10th from web
Creating samples for a custom counter cloths. it's the same as a floor cloths but made to fit a kitchen counter. Fleur de lis design 8:06 AM Sep 10th from web
The requested Performance Counter is not a custom counter...  www.oracle.com - site profile Oracle Providers for ASP.NET - forum profile The requested Performance Counter is not a custom counter...
The requested Performance Counter is not a custom counter...
The requested Performance Counter is not a custom...  Forums - ASP.NET Forums - site profile ASP.NET 3.5 Extensions Preview - forum profile The requested Performance Counter is not a custom counter, it has...
The requested Performance Counter is not a custom counter, it has...
Counter Strike Source - de_matrix: Author: xXTopGamerXx...  bananafancy - Identi.ca - site profile bananafancy - forum profile Counter Strike Source - de_matrix: Author: xXTopGamerXx Keywords: DE THEMATRIX A Superb Custom Counter Strike So.. http://bit.ly/cmlan
Counter Strike Source - de_matrix: Author: xXTopGamerXx Keywords: DE THEMATRIX A Superb Custom Counter Strike So.. http://bit.ly/cmlan
Custom Saved LDAP Queries Like in ADU&C?  404 Not Found - site profile Reporting, Exporting, and Printing - forum profile Custom Saved LDAP Queries Like in ADU&C?
Custom Saved LDAP Queries Like in ADU&C?
2006 Road King Custom Ape & Seat Queries  Harley Davidson Forum - Enthusiast Forums for Harley Davidson Motorcycles - site profile Touring Models - forum profile 2006 Road King Custom Ape & Seat Queries
2006 Road King Custom Ape & Seat Queries
Custom sales/Supplier queries required  Shopping Cart Software Forum for Ecommerce Templates - site profile ASP Mods - forum profile Custom sales/Supplier queries required
Custom sales/Supplier queries required
Custom SQL Search Queries  Web Software and Webware Solutions by Interspire - site profile SendStudio Code Hacks and Customization Discussion - forum profile Custom SQL Search Queries
Custom SQL Search Queries
Backward compatibility in kernels + custom kernels + more...  LinuxQuestions.org - where Linux users come for help - site profile Linux - Kernel - forum profile Backward compatibility in kernels + custom kernels + more queries
Backward compatibility in kernels + custom kernels + more queries
Thread profile page for "Custom Counter in microsoft.public.access.queries" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Custom Counter in microsoft.public.access.queries", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity