Create a new field with order number and their total orders...

[mls via AccessMonster.com]

How can I create a field that shows the values as Order 1\3, Order 2\3 etc in
my form\table.

My table has..

ID Order
234 Order 1
234 Order 2
234 Order 3
345 Order 1
345 Order 2

Thank you very much

 

[Jeff Boyce]

Forms display data, tables store it.

Are you trying to do this on the form? You certainly shouldn't be trying to
do this in the table, as that "value" could change as there are more/fewer
orders...

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[mls via AccessMonster.com]

I want to display this on the FORM. As of now my form shows Orders in
sequence, as they are indexed by ID numbers and OrderNo.
One way I can do this is.. I can create a subform and shows all the order
details for that particular Orderid. But What I want to show as immediate
solution is Order1/3 on the existing form so that people will not get
confused by looking at the first record and forgetting about second or
subsequent records for that ID.

Hope this helps..

Forms display data, tables store it.

Are you trying to do this on the form? You certainly shouldn't be trying to
do this in the table, as that "value" could change as there are more/fewer
orders...

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

How can I create a field that shows the values as Order 1\3, Order 2\3 etc
in

[quoted text clipped - 10 lines]

Thank you very much

 

[mls via AccessMonster.com]

I could only complete half of the query..SELECT [orders]. OrderID, (Count(
[orders].OrderID)) AS Total_Orders
FROM [orders]
group by [orders]. OrderID;

but need to add one more field which has the value of orderno\Total_Orders
and also not sure what event will be approritate for this

I want to display this on the FORM. As of now my form shows Orders in
sequence, as they are indexed by ID numbers and OrderNo.
One way I can do this is.. I can create a subform and shows all the order
details for that particular Orderid. But What I want to show as immediate
solution is Order1/3 on the existing form so that people will not get
confused by looking at the first record and forgetting about second or
subsequent records for that ID.

Hope this helps..

Forms display data, tables store it.

[quoted text clipped - 14 lines]

 

[KARL DEWEY]

Post the SQL of the query you have that feeds the form.
--
Build a little, test a little.

I could only complete half of the query..SELECT [orders]. OrderID, (Count(
[orders].OrderID)) AS Total_Orders
FROM [orders]
group by [orders]. OrderID;

but need to add one more field which has the value of orderno\Total_Orders
and also not sure what event will be approritate for this

I want to display this on the FORM. As of now my form shows Orders in
sequence, as they are indexed by ID numbers and OrderNo.
One way I can do this is.. I can create a subform and shows all the order
details for that particular Orderid. But What I want to show as immediate
solution is Order1/3 on the existing form so that people will not get
confused by looking at the first record and forgetting about second or
subsequent records for that ID.

Hope this helps..

Forms display data, tables store it.

[quoted text clipped - 14 lines]

Thank you very much

--



.

 

[mls via AccessMonster.com]

Form is based on a table and I don't have any queries so far.

Post the SQL of the query you have that feeds the form.

I could only complete half of the query..SELECT [orders]. OrderID, (Count(
[orders].OrderID)) AS Total_Orders

[quoted text clipped - 19 lines]