Recent content by Apt
-
A
Guidance needed - Retrieving a number based upon two inputs
Hi Minty, Thanks for your advice. I have tried it and it works well. I found that DLookup does not update automatically, but automatic update can be achieved by placing the code in the "after update" properties of the controls. A very elegant solution. Thanks a lot. Much appreciated. -
A
Guidance needed - Retrieving a number based upon two inputs
Hi Minty, Yes, I think your solution would work. When I had been experimenting with DLookup I was fixed on the idea of needing a table that was much like a spreadsheets. I was trying to use DLookUp to select the "row" and "column". However, in your suggestion the table only has one field... -
A
Guidance needed - Retrieving a number based upon two inputs
Hi Uncle Gizmo, I think your Team1 example is pretty much the same as my situation. Using that as an example, what I want is enter into a form a LastName and a Firstname - which in my case would be a unique combination - and have the system return the matching score. Sounds too easy. There... -
A
Guidance needed - Retrieving a number based upon two inputs
The tables are quite different. For instance, - there is a "Client" table which has detail about clients - there is a "Property" table that has details about properties owned by the clients - there is an "Asset" table that has details about the assets in a property. Such tables have IDs... -
A
Guidance needed - Retrieving a number based upon two inputs
Hi Uncle Gizmo, I don't really want a spreadsheet solution. My prototype actually has 11 tables. I have no problem joining most tables by the ID in one table and a corresponding field in another. I can create a query and specify criteria and it will give me the record with the... -
A
Guidance needed - Retrieving a number based upon two inputs
Thanks Minty, Yes, I understand about Year. I actually called it Year_bought. Potentially there could be a different rate of depreciation for every combination of Asset_Type and Year_bought. Thus, the user needs to specify both the Year_bought and the Asset_Type to get the right depreciation... -
A
Guidance needed - Retrieving a number based upon two inputs
Hi Uncle Gizmo, thanks for your suggestion. I have read the information you recommended and I understand that a relational database is not like a spreadsheet. I only thought of using a table with a column for each year after coming across Dlookup. I originally started with what I think is a... -
A
Guidance needed - Retrieving a number based upon two inputs
Hi, I am looking for an elegant way to retrieve a number from a table and display it in a form, where the number is determined by two values that will be input by the user to the form. In particular, I want to be able to enter into a form: - a date; and - a class of asset and have the...