Search results

jdraw, That is very helpful - thanks a lot for all those links. Yes I have been trying to map out the processes and relationships etc. but I probably still need to think it all through again after reading up a bit more about it! Ive been mocking up the system with colleagues in excel and...

jdraw, Thanks for taking the time to read my posts and reply. Yes we have got a fairly clear picture of the processes that are required and the information that needs to be captured at each step. We are a joinery company producing completely bespoke items such as stairs, windows, cabinets...

Plog - Thanks a lot indeed for all your help with this. I have now just about got a report in the format that I want... so I'll stop pestering now and try and work out the rest myself ;) Thanks again. Kieran

With my initial IIf statement - it was obviously outputting it in one field, which allowed me to then run a report on the query and group it by this field. Therefore this produced a report grouped into the processes required and listed under each process the items that needed that process done...

Ok yes I guessed it would need to be in VBA... I'll have to play with that a bit. I now haven't yet actually got to what I was initally trying to do... ie having a single field to allow grouping per department on a report... I guess now the process of doing this will be totally different to the...

Ok excellent - this is coming together - so thanks a lot... However - just wondering, is there any way to work it so when you create a new item, it as default applies all the processes, and then you can remove the ones that are not needed? Partly the reason I was trying to use checkboxes...

Ok Thanks for that - I think I just about get the idea. Due to the nature of how we operate - I don't think this could be automated... we receive drawings from customers by PDF and have to analyse them and input them into the system from there! Now I have a table listing the types of...

Plog - Thanks for the reply... however I'm not entirely sure I understand what you mean by these values being stored in the table itself. Basically - Each item that needs to go through the factory will be looked at and someone will decide which processes it needs to involve, and I was wanting a...

Hello, I'm currently working on a database to track items through a manufacturing plant, so have multiple checkboxes that are ticked once a process is complete. I have created a query that has a calculated field, that I want to return a text value depending on what stage it is at, however...

Hello there... just decided to join as I am needing some help with access after being tasked by my company to create a full database system to track jobs! :rolleyes: I have got a bit of previous experience in Access, but I think the task ahead of me is going to involve quite a bit of learning...