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

-- 
Message posted via http://www.accessmonster.com

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" <u55943@uwe> wrote in message 
news:a527580da9c9f@uwe...
> 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
>
> -- 
> Message posted via http://www.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..

Jeff Boyce wrote:
>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

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1

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

mls wrote:
>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

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1

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


"mls via AccessMonster.com" wrote:

> 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
> 
> mls wrote:
> >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
> 
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1
> 
> .
> 

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

KARL DEWEY wrote:
>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]
>> >>>
>> >>> Thank you very much

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1