Search results

I have a simple table "InfoTable" with the following fields: "SetID", "Itemized", "Qty" Try to run a simple query that create to the following statement from the QBE: SELECT InfoTable.SetID, DSum("Qty","InfoTable","SetID=" & [SetID]) AS TotalQty FROM InfoTable; But it produces error: "The...

I have tables with the following relationship: 1. tbl_RecipeList with recipeID as PK 2. tbl_MasterRecipe with recipeID as PK and ingredientID as PK 3. tbl_PriceList with ingredientID as PK 4. tbl_CostVersion with CostVersionID as PK and ingredientID as PK and costnumber as one of the field My...

Just wondering on how a good form is being created.. A bit confused to differentiate a form that will show the result of a query in the subform and how to differentiate a form that would allow edit or new record of the said subform. Looking at northwind databases, one can understand from the...

Hoping to learn more of the beauty of MS Access here! (and making friends along the way) I am pretty much a newbie on Access. Have been looking at some videos over youtube this past month(particularly learnAccessbyCrystal and PC Learning Zone -by Rich). Used to learn SQL many years ago, but...