Recent content by sunny8760

Thanks for the input. In that case, would it be against normalization to have tables that store basic product details and other joining tables that have sub-option data?

Hi Everyone, I need your advice on table design. My company has a price catalogue with about 15 products. It is only available in an awkwardly formatted excel or PDF file format. I would like to add this to an Access table and query what I need. Each product may have 1 to 15 sub-options...

Thank you for your help. So are you saying that a 'junction' table is unnecessary?

While reading another post I have determined that it most likely will be a MtoM relationship. Thanks for your help. Lots to learn... :-)

Thank you for the quick reply. I will combine the two tables, but I'm not sure how to reference two records from the customers table to one order form. The way I plan to create an input form is to use a query from the Orders table and from the Customers table. I will also use a subform for the...

Hi All, I’m new to MS Access. I am working on a project to improve an internal quotation process. My company is a manufacturer and reseller of products to the industrial sector. We often have customers from all over the globe asking for quotations on our products. A typical request may have...

CJ_London, thank you for the suggestion. I will try the date formulas and if I encounter any problems I'll start a new thread. Thanks

Hi Everyone, Thanks for welcoming me. I have learned a lot from reading previous posts on this form and am exciting about using access . I have addressed the problem I posted in this thread by splitting the query into two separate queries. The first query provides a value that the second query...

Hi Everyone, I'm a beginner Access user and have built a small database to track small projects and issues I need to manage at work. I have a query that retrieves a list of all "Open" issues/projects that I'm working on. I've added a couple of columns in the query to calculate the age of each...