Search results

Thanks guys

Hi guys is it possible to automatically update the name of a field in every access object (Queries-Forms-Reports-Vba Codes) ? if i change that field name in a table , I have a field name i need to change in one basic table in my database which mentioned in like 100 query, report , form , vba...

Works like charm thank you so much for your help and your patience

Hello , Sorry for late reply Please find attached my original table TblPoDtls with big variety of data , You will find a table named Result this table has the desired result for 6 machines not all but still covering all conditions . You also will find a remark in MyRemarks Field in table result...

Sorry for your troubles , I will put something together with expected result for each condition , But tomorrow because i will black out right now :D

Thanks for your reply , there are actually two tables one for machines numbers with some relevant information , and the other for Po’s related to the machines , About my example it is just example the original database is way complicated than this and no duplicated tables don’t worry about that...

Thanks for reply , For Every unique machine in table one i need the smallest priority if there are any differences in priority number , it could be the same priority if it is the case the result should be the latest date , if the case is the same priority with the same date then the identifier...

Hello guys thanks for having me here , I have 3 Access queries , The first query (Q0) filters a table to get specific data : SELECT Table1.ID, Table1.Machine, Table1.Po, Table1.Priority, Table1.Zdate, Table1.Status FROM Table1 WHERE (((Table1.Status)<>"Not Needed")); The second query (Q1)...