order number in query
in [General]
|
Prev: My Access 2007 Database does not display correctly in Windows 7
Next: Shop Product ?Search form/query Access
From: afshin on 14 Mar 2010 03:18 when accending the query by date field,i want to have a one field that show order number.in report by inserting (=1) in textbox and change the running sum property of that to YES i can to have a order number,but in query i can't to do this.
From: jero on 14 Mar 2010 06:35 Hello, If you understand french, you can see at : http://3stone.be/access/articles.php?lng=fr&pg=39 If no, I can try to translate... (but sorry for my english) "afshin" <afshin(a)discussions.microsoft.com> a �crit dans le message de news: 91592935-8F94-4512-8D25-11E9FA2CDFB0(a)microsoft.com... > when accending the query by date field,i want to have a one field that > show > order number.in report by inserting (=1) in textbox and change the running > sum property of that to YES i can to have a order number,but in query i > can't > to do this.
From: afshin on 15 Mar 2010 01:36
tank mr.jero,i thinck that what do you say.i used similar founctiones for ordering: DCount(" [DateReading] ";"table11";" [DateReading]<= # " & [DateReading] & "#" & ' And ' & " [Section] =" & "'" & [Section] & "'") but when i run that query,long time need to show the result.i will grateful,if you translate your sayes to english. "jero" wrote: > Hello, > If you understand french, you can see at : > http://3stone.be/access/articles.php?lng=fr&pg=39 > If no, I can try to translate... (but sorry for my english) > > "afshin" <afshin(a)discussions.microsoft.com> a écrit dans le message de news: > 91592935-8F94-4512-8D25-11E9FA2CDFB0(a)microsoft.com... > > when accending the query by date field,i want to have a one field that > > show > > order number.in report by inserting (=1) in textbox and change the running > > sum property of that to YES i can to have a order number,but in query i > > can't > > to do this. > > > . > |