Recent content by ggoosen

hi the data is in the correct format now... so all i need is the sql query that will return my data as desirted... thanks

Hi Fofa I have the data in the tables as desired now... i am just looking for a way to retireve the data via the query?

Hi fofa if you take a look at the original post there are 2 tables the first is the original data and the second is the desired outcome thanks

Hi Guys I am having a bit of a delimma and am wondering if there is someone out there that could suggest how i could write a SQL statement that would alow me to return data in a certain way, I have data as follows... FIrst problemi is the Date in the LogDate COlumn is of Text Type not Date...

The rows are inserted by a third party system which is used for a access control clock.. it writes to the access file and i have no control over that.. my need is to write an applicatin that manipulates the data for a report (my application is a java application)... i cannot do that becuase the...

Query OK So whaat would the queries be and how would i create the macro.. also i dont have an on update trigger... is there any way that i can create a "listerner" for when something is inserted into the row.

Hi Guys I have a quick question? In MS Access i have a need to do the following I have one table that has and ID column and a Date Column so something like this Table1 ============= Id : AutoNumber Date : Text what i need to do is create some sort of macro that will do the following when a...