Search results

hmm... i'm not sure why. I created this using Access 2016 if that helps.

Hi everyone, I'm trying to create a particular query (so as to output it as a report). But before I describe the query (Current Issue), let me describe my database first (attached). (note: dummy data is fed into this database) Tables: Analyst_Availability: Each record has a date, analyst_ID...

thanks arnelgp, i'll look at it and get back to you soon.

Thanks, I'll look at it and get back to you soon.

Dear Pat, Thanks for your reply. Ideally, what my user wants is that after keying in Test-Info and Test-Date on the left subform, 2 records will be entered into the table. The first record will have the information as entered. The second record will have Test-Info and Test-Date will be 3-5...

Dear June7, Thanks for pointing out the issue with both forms. I had originally set them in Data Entry mode. But it was turned off in the version that I had uploaded. I have uploaded a revised copy of the file where both subforms are in Data Entry mode. Yes, Info 2 was supposed to represent...

Hi everyone, Before I ask my question, the following is a bit of context. I'm tasked with creating a database that tracks the testing of samples (tasks) in the QC lab of a factory. The overall database will be managing the availability of lab analysts, analytical methods, test records...

Hi everyone, I first learnt about Access 10 years but it is only now that I'm beginning to use it to create a database to manage some tasks at work. It has been challenging and I haven't got it fully worked out. I look forward to learning from everyone here.