Recent content by Winnipeger

Thank you all. I am learning a lot of things from you guys :) In response to plog and jdraw. Sorry for not giving the whole picture, yes it does includes orders,assigning of work and tracking them. I now understand your point, I do have to restructure my database to be able to come up with the...

I am in a manufacturing company who deals with train rail plates. What we do is we machine plates according to customer needs/orders. Basically, for every job order there is sequence such as cutting, then milling,then inspection (some plates does have more than 3 sequence). With this, i just...

Thanks for the response. I got your point. It's just this is the only way I know to track the status deoending on the sequence selected thru lookup dropdown. I can include Status field on the table however I have no idea how to meet the criteria since it depends on the sequence selected. :(...

Thanks guys for all your inputs! and sorry for the confusion being a newbie in access, i am really overwelmed with so much info. Going back to my problem, I have attached a sample db of my project. I just wanted to add two more columns in my JobOrderTracker query: STATUS Not Started = if...

Hi there, Can you give me an example or lead me to a thread about changing the Yes/No datatype using a parameter/condition. I cant seem to find it anywhere :( the problem goes like if the number of quantity is met, the NO should be changed to YES. Should it be done in a table, query or both...

Thank you Adam and Cronk I will try it out. :) Have a great day!

Sample db please. :) Appreciate your assistance!

thanks guys for the prompt reply! However Adam, can you please elaborate more. Im new to Access and needs more guidance . :) thanks in advance

Im a NEWBIE here! Would appreciate your help I do have two tables (Job Order and Production) I would just like to keep track of the production quantity of each job orders based on the production table summing up according to sequence number. And at the end answers YES to Completed? if all...

Hi Guys, Sorry to confused you. I will try to give as much information needed. My problem is there is a current default table (Parts) which the user needs to select the "Side" then enter the new "Job number" and "batch qty". And save everything in the existing Jobnumber table so for example...

Hi there, Newbie here. Just need your help on how to autogenerate jobnumber using an existing table where enter the new job number in a form. please refer on the attached picture/files for reference. Thank you

Hi Guys. I'm Arvin, Im a newbie and want to learn more on access. It's a pleasure to be in this forum.