Search results

Thanks, that is what I have done.... Nicky

Is it possible to save a copy of a report data only, I don't want the copy of the report to change when I change the query the original was looking at, I just want to save the data...is this possible?? The report shows Profit and it looks at a query that I change the dates of each month, at the...

I have created a report with a main report and 2 sub reports which show invoice information. THe main report is the customer info and the sub reports are sales and supplier invoice info. I want to create a sum text box which adds up info from teh main report and also the sub report, however...

Hi Pat I am obviously missing something here! (which doesn't surprise me!) I have tried this however I am still getting duplicates, I am presuming this is something to do with my relationships. What I have done is include an identifying number in both the deal table and the invoice's table...

okay Pat, thanks, how would I then join them together to see all the data in one report? I am bit of a novice!! Thanks for all your help!

Thank you but that still doesn't work, that is the format I want however I am still getting duplicates... for example, one deal has the 3 sales invoice numbers and 2 supplier invoice numbers and it is duplicating records from both the sales and supplier invoice tables... So for example: Jo...

Hi I am trying to create a query that will show invoice information. It is being drawn from 3 tables - a customer deal table, a sales invoice table and a supplier invoice table. I want to be able to show the invoice information for each deal, I have created a query for this and put into a...

Help Hi I have the same problem as this, can anyone help with how I create it? Many thanks

Hi I am trying to create a notes field in my database that will hold contact information, so I guess it needs to be a subform with an ID field, date field and then a memo field to hold the contact info. However I am struggling getting my head around how I link this to my database. When I open...