Search results for query: *

I have a table "Invoices" that has 20 fields named item1Cost, item2Cost, etc. This table also has 20 other fields named item1Type, item2Type, etc. These types are looking up 1 of 7 values in another table "Costing_Types". Now I would like to get the total sum of all items per each different...

Depending on which ID is being referenced in a subform, I want to restrict the list of values in a Combo Box using a query: • I have a subform [Bonus Subform] that is linked to Table!Bonus. • I have a query [Bonus ID to valueList] that associates each Bonus ID to a list of values. The way...

I'm not even sure how to structure this. I have a main form Forms![User Master] which references Tables!Employees. In this form is a the subform object subformPromotions which in linked to Forms![Promotions subform] which references Tables!Promotions. The relationship from employees to...

Hello, Depending on the value of combo box #1, I want to restrict the range of text box #2. Combo box #1 will reference a table; each row in that table will have, in addition to an ID and Name, a minimum value and a maximum value column. Text box #2 will be limited by the values of the min...

In trying to create a database that will be used by someone who knows nothing about access, I want to place a sort button on my forms where when the user has their cursor in a field, this button will sort that field accordingly. Currently I have a macro that simply runs the command...

I am new to Access, so thanks to anyone who can reply. Problem: I want a field in a form to reference either one source in one table or another source in another table, depending on the results of evaluating another source as IsNull. My code for my control source looks like this...