Search results

The data is all there, not sure what do you mean by B data. Since the data are all over multiple tables, I am trying to query the following records: - tbl_RecipeList.RecipeID, - tbl_IngredientList.IngredientName - tbl_MasterRecipe.Qty_Kg, even when the following records are null or empty...

Hi June7 and plog Thanks in Advance for your help. I have attached the databe scrubbed from all the confidential data.. Only Tables and the only Query left.. The SQL may have changed from my original posting since I have been playing around with the QDE and unable to get to the statement that...

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...

I got confused from this possibilities, and your ideas are very clear and concise. Thanks!

Thanks for all the responses. What Micron said is what's on my mind. Reading from all the responses here, I think there won't be such distinct line. It maybe depends on the original intent of the application, and those itself can change as the application has been built. Maybe the analogy...

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...

Hi strive4peace! (just a note: I truly enjoy your youtube videos) Now, going to your question.. I am pretty sure you can. I haven't played with regex for quite a while now, but what you are looking for is \w+ should work in your case. Gasman linked to the website, I pasted your sample and it...

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...