Search results

Thank you very much Caz for taking the time :) Ah yes I see, use the JobTrade in the Join... I will play with this and report back!

Hi Caz, Yes to trades, one or more needed per job. Yes, on any one job any trade can be supplied by any different SubCon and for instance on job X, trade = electrics, we could have different SubCons doing the work; especially if it is busy or we have a deadline, quite common for us to have 3...

Hi Chris, I have a table called TblClient and this is indeed "One Client:Many Jobs". The TblSupplier is material suppliers; So a job may need many suppliers just as a supplier delivers materials to many jobs. I understand this is similar to subbies which is why I did the union query on them...

Good Morning Experts, I have a DB with some many to many relationships for which I have used "join" tables. I believe I have done this correctly although I am quite new to normalisation and many to many relationships! I've attached a simplified version with test data of the area I'm having...

Oh Caz you are a genius, I couldn't see the wood for the trees! Worked a charm :) Thank you!

Good Morning Experts, I have a continuous form sfrmAddress which is based on my table tblAddressList. What I am trying to achieve concerns the date fields DateFrom and DateTo. DateFrom is a bound text box txtDateFrom I am trying to put an IIf function in the Control Source of unbound text box...

Hi experts! Today I have come across a little problem which I think I understand but am not sure how to approach. I have a report rptAllCSCS which is based on a query qryCSCS2 [ Thanks Nigel ;) ! ] This has a filter which is based on the Status field, [Status]="Current" The filter works...

Hi All, With many thanks to Nigel for showing me the way, I now have my query and report acting perfectly. I made a few tweaks and managed to cut the process down to two queries and include any blanks (A blank DateFrom in the Address and those Employees with no Address at all)...

Nigel, wow, thank you for taking the time to do this! I've just had a little look at home and you've hit the nail on the head! I can also incorporate this with all my other one-to-many tables and it isn't completely baffling, just logical. I will set this in my DB when I get to my desk in the...

Well, I found this http://stackoverflow.com/questions/2111384/sql-join-selecting-the-last-records-in-a-one-to-many-relationship which appears to show a solution for what I need but when I try to incorporate my own names into the SQL screen: SELECT tblEmployeeDetails.EmployeeID...

OK I think I understand. Is there a way to to pull up the address based on the MaxOfDateFrom column? i.e. a query inside a query or something similar. I know Access can do pretty much anything, you just have to know how to tell it!

Also, I do need to see the address? How can I add this without showing all the records again? (I just tried adding AddressLine1 and it shows all addresses again)

Hi Dale, Yes! That works?? So why doesn't it work when I have the other fields in there? If you could explain I can hopefully avoid this in future.

Hi Dale, OK I've put this: DMax("DateFrom","tblAddressList") in the criteria row of DateFrom on the query design screen and it only returns the most recent DateFrom (1 Employee, 1 Record) and ignores all of the other Employees. I tried using SELECT Max(... but it was giving me errors...

Hi Experts, I've been Googling for a while and have found a lot of opinions/versions of an answer but as this is the first time I have delved into query SQL I thought I might ask if anyone would be kind enough to help me. I have a "parent" table: tblEmployeeDetails And a child table...

Hi CJ, I agree, I built this DB a few months ago when I first started learning Access. It has one large table and no normalisation! I am now on a mission with a blank database and am following the proper procedures. Up to 8 tables already! I think with all the errors I was getting I had to admit...

Hi CJ, I didn't know that, thank you :) I am using UK and have changed the ending back to <Date() but still no joy with the Control Source or Text Box beginning.

Hi All, I'm about tearing my hair out so thought I would ask the experts. It's something I've done before but for the life of me I don't know why it isn't working this time... I have a text box on a report from the Control Source CSCS Expiry Date. The format in the table and query and report...

Hi James, Thank you for your suggestion but I found a workaround. I changed the first record in the table to 0000 and left all of the other fields blank... Hey Presto, when the form loads all of the boxes are blank and I can type in my JobID :) I don't know how to change this to solved?

Hi Experts! I have a form which is for searching for and then viewing a record based on a text box and pressing enter. This is working fine. My ID field is 4 digits and when I change the 4 digits and press enter it shows me the details for the record in all of the other boxes: Private Sub...