Search results

I now have the query doing exactly what I wanted it to, thank you so much for helping with this and with the general beginners' stuff as well. Much appreciated friend.

I was unaware of this. Not sure how else I'd be able to pull through the required data otherwise though. Generic database with any sensitive info removed is attached. Thanks for your help Mailman.

Yes, it's a lookup field in the "Product" field in "tbl_BlendlineProductionForm", joined on an autonumber primary key "ProductID" field from "tbl_Products". Is this a no-no? Would uploading a copy of the database help in understanding where I'm going wrong? "qry_ProductDurationsPerBulkLitre"...

Excuse my ignorance, but I don't fully understand what you mean. In the table ("tbl_BlendlineProductionForm"), "Product" is a text field based on the list of "Product" in "tbl_Products", which is also a text field. In the query ("qry_ProductDurationsPerBulkLitre") similarly, "Product" is...

Thanks, I've now realised what you were trying to tell me. Having made both fields the same type, the query posted by namliam (adapted to the new field names) now "works", but produces no results against all the fields from "tbl_BlendlineProductionForm" and "qry_ProductDurationsPerBulkLitre"...

Sorry for the delayed response on this. Thanks for the pointer, although will changing the names now affect the form I've built? I tried the code that you posted in a brand new query, and am receiving a type mismatch error. The "Product field" is a lookup of the corresponding field in the...

Thanks for the responses guys. To answer your question CJ, the Production Form is based on a table with the same name. I had done some research through these forums and Google, and had a thought that it might be an INNER JOIN but couldn't figure it out. I've tried to adapt the code based on...

Hello all, Been working on this for a while now and can't get it to work how I'd like after trying a few things. I have a form ("Production Form") from where users input start and end times for various processes against a particular product. Currently, I have (or had) a query (and linked...

I got it working in the query! Many thanks for the step-by-step, I now have a grasp on the process. Thanks again also to Galaxiom for the code!

Thanks for taking the time to create this Galaxiom, it looks like it could work. Question is, where/how exactly do I place this function in my form? I've tried entering your code above verbatim into both the Before Update event of the ProductionWeek field on the form, and in the ProductionWeek...

Thanks for the response Galaxiom. I've done a bit of research into this, and tried to modify examples I've seen, although I can't find anything that works for my particular fiscal year (beginning 1st July every year). See my previous post for the basic DatePart function I have. Any ideas on...

Thanks for your reply. I've tried various joins, although I think my failure to achieve what I require is more down to a lack of knowledge than anything else. I have written a query already: ... although this returns the week of the calendar year (as I expect). Unsure how to adapt this...

Hello all, I have a database with a main form (Production Form) which is based on a table that records timings for production processes. Within this form, I have two fields: ProductionDate and ProductionWeek. I also have a separate MasterDates table (based on DCrake's example table from this...

Hello all, I worked with Access at school to a reasonable level, although now find that I struggle to remember how to do certain things! Part of my job role is to create a database to calculate OEE by recording production timings. I am from Scotland in the United Kingdom, and look forward to...