Search results

pbaldy - Thanks again for the advice. Just to clarify you recommend 1 table for products, 1 table for doorstyles and 1 table that combines the other two with prices? When editing is necessary I could filter by doorstyle? Would you please show me how you would build the relationships? Would...

pbaldy - I'm not sure I follow you. Just three fields - product, doorstyle and price? There are 158 products, 8 doorstyles and 1,264 prices. Are you suggesting a unique product for each doorstyle within the same table as Niroth mentioned that contains 1,264 records? I would think this to...

I am using Access 2003. I am trying to create a pricing utility for a cabinetry line. I have 158 products that all have 8 different price groups depending upon the door style the user selects. I am at a loss as how to structure the tables. Once the user selects the door style and looks up...

I have a query with the following fields: Category >> Date >> Description >> Amount There are only 4 possible choices for Category which I defined using a lookup. These categories are "Improvements", "Maintenance", "Operating Cost" and "Startup Cost". I have a form with 2 checkboxes. If...

I got it to work.... I'm not 100% sure how it works, but I am going to study it.... Thanks, Kevin

??? I'm starting to understand. Should this new Expr1 field replace the Yes/No Field I had previously? Thanks, Kevin

??? I tried your suggestion and now it shows either all records or none. Please explain what this expression is meant to do. Does YourTrueFalse refer to the field on the form in all instances? I appreciate any help as I have a deadline of tomorrow.... Thanks again, Kevin

I am trying to create a form based on a query that has a yes/no field. If the user checks a box on the form it will return all the records regardless of whether they are "true" or "false". If the box goes unchecked only the "true" records get returned. I have tried the following and many more...