|
 |
access thread: Counting Query Results
Message #1 by "enZo :-\)" <enzaux@g...> on Tue, 20 Aug 2002 17:16:44 +0800
|
|
Suggestions on how would I do the following :
1.) How can I number my query results? for example I'll query all the users of the
that are logged in and then I want to show them in this format:
ID Name
--------------------
1 02-23 Enzo
2 02-79 She
3 02-98 Joop
4 02-43 Aikee
The ID and Name field are in the database. How would I create an auto incrementing
number just like in the example? Would I do this on SQL query?
2.) For example in a cargo business, I want to get the count of boxes a particular
sender/customer has per container van. and produce this sample output:
CustID Name Qty
----------------------
02-001 Enzo 1-1
02-002 She 1-1
02-003 Joop 1-2
02-003 Joop 2-2
02-004 Aikee 1-1
As you can see from the example the Customer Joop has two items on the container, how
would I make the the "QTY" part in the report.
Thanks,
Enzo
YahooID: onestepcloser2insanity
Message #2 by "Nikola" <Nikola@B...> on Tue, 20 Aug 2002 14:56:58 +0300
|
|
Hi enzo,
for your question No 1.)How can I number my query results? if is in report
the make like this :
on Desing view create new text field (txtNo) IN txtNo propertis:
Control Source : =1
Running Sum : Over All
tip if you want to look like this :
1.
2.
3.
4.
put label of txtNo on right side and in label Caption just enter Dot(.)
Fule
-----Original Message-----
From: enZo :-) [mailto:enzaux@g...]
Sent: Tuesday, August 20, 2002 12:17 PM
To: Access
Subject: [access] Counting Query Results
Suggestions on how would I do the following :
1.) How can I number my query results? for example I'll query all the users
of the
that are logged in and then I want to show them in this format:
ID Name
--------------------
1 02-23 Enzo
2 02-79 She
3 02-98 Joop
4 02-43 Aikee
The ID and Name field are in the database. How would I create an auto
incrementing
number just like in the example? Would I do this on SQL query?
2.) For example in a cargo business, I want to get the count of boxes a
particular
sender/customer has per container van. and produce this sample output:
CustID Name Qty
----------------------
02-001 Enzo 1-1
02-002 She 1-1
02-003 Joop 1-2
02-003 Joop 2-2
02-004 Aikee 1-1
As you can see from the example the Customer Joop has two items on the
container, how
would I make the the "QTY" part in the report.
Thanks,
Enzo
YahooID: onestepcloser2insanity
Message #3 by "enZo :-\)" <enzaux@g...> on Wed, 21 Aug 2002 10:04:50 +0800
|
|
Thanks Nikola/Fule for the tip
Enzo
-----Original Message-----
From: Nikola [mailto:Nikola@B...]
Sent: Tuesday, August 20, 2002 7:57 PM
To: Access
Subject: [access] RE: Counting Query Results
Hi enzo,
for your question No 1.)How can I number my query results? if is in report
the make like this :
on Desing view create new text field (txtNo) IN txtNo propertis:
Control Source : =1
Running Sum : Over All
tip if you want to look like this :
1.
2.
3.
4.
put label of txtNo on right side and in label Caption just enter Dot(.)
Fule
-----Original Message-----
From: enZo :-) [mailto:enzaux@g...]
Sent: Tuesday, August 20, 2002 12:17 PM
To: Access
Subject: [access] Counting Query Results
Suggestions on how would I do the following :
1.) How can I number my query results? for example I'll query all the users
of the
that are logged in and then I want to show them in this format:
ID Name
--------------------
1 02-23 Enzo
2 02-79 She
3 02-98 Joop
4 02-43 Aikee
The ID and Name field are in the database. How would I create an auto
incrementing
number just like in the example? Would I do this on SQL query?
2.) For example in a cargo business, I want to get the count of boxes a
particular
sender/customer has per container van. and produce this sample output:
CustID Name Qty
----------------------
02-001 Enzo 1-1
02-002 She 1-1
02-003 Joop 1-2
02-003 Joop 2-2
02-004 Aikee 1-1
As you can see from the example the Customer Joop has two items on the
container, how
would I make the the "QTY" part in the report.
Thanks,
Enzo
YahooID: onestepcloser2insanity
|
|
|
View Cart
