jlf
Last Activity: Jan 9 '07, 02:26 PM
Joined: May 17 '06
Location:
-
I did exactly what Neopa suggested and it is working fine. This is not a multiuser environment. I chose this method because of past experiences with autonumber and this also gives us the option to assign a year to each ticket and not starting diirectly with 1, we are starting with 20070001. This is per request of management, but thank you again for your assistance. -
Thanks for your help, but I got it working.Leave a comment:
-
I apologize, but I am a complete newbie, so not really following along on your suggestion....Leave a comment:
-
I want a unique number every time I want to create a new ticket. No number will be reused. A good example of what I am trying to do would be when someone creates a new purchase order request and it gets assigned a unique purchase order number. I just want an automatic number to pop into the helpdesk ticket control box. Hope this helps....Leave a comment:
-
Alternative to using Autonumber
I would like to know the code to use in an Access form that would be an alternative to using autonumber. My source table is called tblHelp Desk Tickets and my number table is called tblNextNum. The field I am using to for the next number to be pulled from is NextNumber. The control box on the form is called Helpdesk Ticket No, txtHelpdesk Ticket No.
Would apprecaite any help in this area, I am not that familiar with creating codes.... -
No worries.....you 're great. JLF...Leave a comment:
-
Resolution for anyone interested
=Sum([qtyproduced])/((Sum([qtyruntime]+[timedown])*[piecesperhour]))
The suggestion from Wendy was actually still giving me incorrect data, but still appreciate the suggestion. The above formula fixed the issue completely.Leave a comment:
-
Resolution for anyone interested
=Sum([qtyproduced])/((Sum([qtyruntime]+[timedown])*[piecesperhour]))
Works great.
jlfLeave a comment:
-
IIf issue
I am attempting to get a total of production per each shift of work, which there are 3. The below expression works fine for Shift 1, but Shift 2 and 3 are showing blank values. I rearranged the expression, but then Shift 2 and 3 show the same duplicated value as Shift 1.
=IIf([Shift]="1",(Sum([qtyproduced]))/((Sum([qtyruntime]+[timedown])*[piecesperhour])))
=IIf([Shift]="2",(Sum([qtyproduced]))/((Sum([qtyruntime]+[timedown])*[piecesperhour])))... -
Wendy,
Thank you, this worked great.
jlf...Leave a comment:
-
Need Help with an Access Calculation in a Report
Need serious help with a calculation. The fields are based on a query that has linked many different tables. The calculation I currently have is:
=sum([QtyProduced])/(([runtime]+[downtime])*(Piecesnum]))
It is giving a calculated outcome, but an incorrect one. I am basically trying to get the QtyProduced to divide into the combined runtime+downtim e*piecesnum to get a sum of efficiency. I've tried many different combinations... -
Need Help with an Access Calculation in a Report
Need serious help with a calculation. The fields are based on a query that has linked many different tables. The calculation I currently have is:
=sum([QtyProduced])/(([runtime]+[downtime])*(Piecesnum]))
It is giving a calculated outcome, but an incorrect one. I am basically trying to get the QtyProduced to divide into the combined runtime+downtim e*piecesnum to get a sum of efficiency. I've tried many different combinations...
No activity results to display
Leave a comment: