Recent content by catssolutions

Hi all, I have a report that I want users to be able to change the groupings and or sorting of the report from a simple form. They would have a droup down list of all the report fields and they can select how to group it Ie data, ref 1 or ref 2. I tried doing a conditional grouping...

Hi all, I have a report that I want users to be able to change the groupings and or sorting of the report from a simple form. They would have a droup down list of all the report fields and they can select how to group it Ie data, ref 1 or ref 2. I tried doing a conditional grouping...

hi Thanks for your reply, What additional infomation would you need? I have a query that returns all customers orders sorted by there department code. I produce a invoice based on this query. I can save a single pdf with all departments starting on a new page and totals for each department...

Hi All, I have a DB that is used for sales. I have a report which is used to create an PDF invoice for a company which works fine. The problem is that we are taking on a new customer that wants to have a individual invoice based on departments, as a sepearte pdf. I could do this manualy for...

Thank you for your reply, Im sorry if I was not clear, I have worked it out now. What i needed was a many to many relationship and use a make table queries to create a new list from the default pricing list from this I can then do an append to add the new pricing to the tables. Initial test...

Hi all, Im Currently in the process of disigning a ordering database. Which is fine for a single price model. The problem is that we have multi customers each with there own agreed pricing model. (same products across the board). What I would like to do is have a single product list and a...