Search results

I am looking for some help with inserting a graph in a report. The report I have displays the agents details and their results, in the footer section it displays the totals and it is here I want to display the graph. I had the graph working but its now decided it wont any more.... The graph...

Hi, I have a table which shows fraud order Nos accepted and fraud order No's denied and I would like the system to give me one random number from accetped(Per Agent) and 3 random order numbers denied (Per Agent). Is this do able in Access or am I clutching at straws?????:eek:

Can anyone help me please!!! I receive a csv file in which I need to import it into a table. It contains a date feild which looks like this '2007-06-15 12:17:54.953000000' and I would like it to look like this 'ddmmyyyy 00:00:00'. I have tried importing the data then changing the imported field...

This seems really silly but I cannot get this query to work. In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to...

We have recently upgraded our systems from 97 to 2003. A lot of our main info is kept in our Data db and we link our tables to this main db from all our other databases. When I try and link these tables after converting them to 2003 i get a ' Disc or Network error' and then all the queries...

We have recently upgraded our systems from Access 97 to 2003, I am trying to amend the import module so that it recognises the excel sheet we use to import. The old code is : DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, ImportTable, _ HostDir & ExtractFilename, True This...

HI there, sorry a bit of a newbie to access. I am trying to do an append query, or should I say I have done an append query. I am trying to build a database. The first query pulls data from a server with four tables linked into this, when you fnally get the ODBC to connect the data comes...