Search results

I have two tables, sales and assets. Sales has product code, name, sales figure and sales period (e.g. 01/01/2001 to 01/02/2001). Assets has product code, name, asset value and date (e.g. 01/02/2001). The product codes are linked and are the same in these two tables. I have also linked the...

Hi there, I am trying to put a page break/set the number of records per page for my report. I have two group headings (a and b) and the details section. I would like the page break to occur after there has been 2 records in the "group heading b" and for those records of "group headings of b"...

I am an access novice and need some help pretty badly. My problem is as follows: I have two tables of data like below Table1 TopCode SubCode Item ABC ABC FishA ABC ABCD FishB ADF ADFG PhoneA ADF ADFH PhoneB Table 2 SubCode Date ABC 01/01/2001 ABCD 01/01/2001 ADFG 05/02/2003 ADFH 04/02/2003...

I am trying to produce a report but struggling. My database is essentially as follows. Note: Tables are linked to Excel spreadsheets and can not be editted. Table 1 = Code, Assets Amount, Assets Date e.g. ABC 100 01/02/2003 ABC 800 01/03/2003 ADB 900 01/02/2003 ADB 750 01/03/2003 Table 2 =...