Recent content by bigcraigie

Hi, thanks! Yes the table will build up records until the client stops reporting. I have the 'Name' column as the primary key - but do I have to introduce a 'Client ID field'? if it is any help the client names will be unique throughout their history. BigC

I have to import from excel updated info 2 or 3 times a day. Client Latest Report A Bloggs 01/02/12 B Smith 01/02/12 So if I update the report from excel, and run the report based on the query, how can I get it to run the report and show only the latest report? ie A...

Re: Only Yes to show in report part 2 Ok guys, I've managed to filter it using Yes or No instead of a tick box, I've even managed to save an import path from updated information on Excel - now, if I have one client, and an updated payment, I only want to show the client once with the last...

Hi, I was trying to create what i thought was a simple query in Access- in a list of objects (some duplicate) with dates, I added an 'Active' column. In the report I only want to show 'active' objects which will be checked in the check box. I have tooked through the forums but none of the...