Re: $$Excel-Macros$$ MS Access solution

2011-12-07 Thread Kishan Reddy, K
Hello Rohan, Even though Excel and Access are two products of MS-office, working with them is quite different. While in excel the core term is cell, which when culminated leads to rows, columns, worksheets & workbooks. In excel we work with formulas & functions, with relative or absolute cell add

RE: $$Excel-Macros$$ MS Access solution

2011-12-05 Thread Asa Rossoff
Hi Rohan, In Access you should build a query instead of doing a lookup. Your query can refer to various parameters from fields in forms, or the user can be prompted for parameters (Access treats all field names that don't exist in a table as parameters). The other time you might use vlookup in Ex