Search results

  1. Z

    Using query in a field

    One more quesiton, sometimes while calculating a formula access is throwing "File sharing lock count exceeded. Increase MAXLOCKSPERFILE registry entry" error messsage. Any help?
  2. Z

    Using query in a field

    Thank you guys, I found the way. I just used update command using inner join and it behaves like a vlookup :)
  3. Z

    Using query in a field

    Just a question, is it possible to use a query as a field? For example whatever I change in a field in a table, it should dynamically run the query by relating a table and populate the output in a field of the current table?
  4. Z

    Using query in a field

    Thanks for your guidance. Apparently we deal with plenty of rows, hard formulas etc. Excel is not responding properly so we thought of shifting from Excel to Access. I understand that every tool will have their own limitations but just wondering if something can be done to do all those excel...
  5. Z

    Using query in a field

    But that doesnt serve my purpose. I need to bring the data from another table. Typically how you do vlookup.
  6. Z

    Using query in a field

    Hi, I am new to MS Access so pardon me if my question looks so basic. :o I am creating a table (Example : A) consisting 20 fields. One of the field has to pick value from another table's (B) field, if the value of the unique fields in both the tables are the same (Typical vlookup in...
Back
Top Bottom