Search results for query: *

Thanks Duane, I have 2 tables, 1 query, 1 form and 1 report. I'm happy except for the hide aspect. I believe everyone wanted the one on the Mixes table and the many on the packages table but when I went to set it up it didn't work the way I want it to. Another aspect that I questioned before I...

Hi everyone, okay I've changed the structure radically from where I started and even from the suggestions made. I now have a one to many relationship which works great and I think its kind of normalized, albeit different from what everyone recommended or probably expected. I've put the one...

Hi everyone, this is similar to what I want I just don't know how to get it to work for my problem. Here is the thread: thread702-953540 I have the form working well for everything else except this one problem. Thanks.

Hi everyone! I believe I did what has been suggested. I created a table of packages and linked it to the mixes. Then I developed a query as alvechurchdata suggested but it isn't quite what I want. I also created a crosstab query to show the data as I want to see it but that didn't allow me to...

Thanks PHV and dhookom and especially for the link PHV - it was excellent. Some of the terms are a bit above my knowledge or memory. Everyone seems to be directing me to change the structure so I'll look at that as I can't get my brain wrapped around what alvechurchdata suggested I do without...

Thanks alvechurchdata for your suggestion. Agreed. I will create and link the Mix table later. The database isn't that large - at the most it only has about 25 records so I'm not that worried about it getting too big or cumbersome. I have one table, one query, and plan to create a form in order...

I'm a wannabe developer & programmer. I have a very simple inventory database that keeps track of how many packages of chocolate chip cookies are in the refrigerator and how many are empty. The FIELD NAMES and Data Fields look something like this: MIX MADE MX1 MX2 MX3 MX4...