What is the formula in Access if it is applied like in Excel (as shown). Thank you very much teacher.
Novice
Windows 10 
Access 2013 64bit
VIP
Windows 10 Access 2010 32bit
You want know if the value in one record is equal to the value in another record? Excel and Access are very different apps. Forget Excel concepts when working with relational database. Records in database table do not have defined order as rows in Excel. This sort of comparison requires a nested SQL or DLookup domain aggregate function.
Or do you want to carry forward the value to a new record?This requires code - macro or VBA.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 10 Access 2013 64bit
thank you for the answer, how to proceed in the form of macros?
VIP
Windows 10 Access 2010 32bit
I don't use macros. Review https://access-programmers.co.uk/for...d.php?t=167773
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 8 Access 2016
Btw, in Excel such formula in cell A2 returns an error (Circular reference!), and False/0.
Excel formula to access vba.
Translating Excel formula to Access formula (in query)
Posting Permissions
Reply With Quote