Search results

yup, its has been imported, so in the first field i am just left with "71665549mS CALL:2006/04/2512:09" and I need to get rid of "71665549mS CALL:" or just extract the date and time into seperate fields i just seem to be having problems putting the "InStr([start, ]string1, string2[, compare])"...

could you please explain how, I must be doing something wrong to be getting a message box every time i run the query instead of it just doing the calculation........ I wouldn't like to start dabbling in VBA

thats just what i need, cheers, but can I put these functions into a query, or does it have to be coded straight into the VB side, will have a mess with it now though, thanks access just keeps asking me to enter parameter value when i run the query.......

right, I tried that, but cant get it to work, in my query, I have just typed it in a blank field to the right, replaced the values with the appropriate data "TimeOfCall" is the field it is coming from at the moment, replaced the values with 16 and 10, but keeps giving me errors, looked on the MS...

Heres an example of my CSV data: 71600797mS == Tue Apr 25 12:09 [172.29.100.239] 71660381mS == Tue Apr 25 12:10 [172.29.100.239] 71665549mS CALL:2006/04/2512:09,00:00:00,013,055623412,I,349,287349,01123456700,,,0,,"" 71719967mS == Tue Apr 25 12:11 [172.29.100.239] 71779548mS == Tue Apr 25...

wow, fantastic, thanks a million!!! both problems solved:) :) :)

arghh, more problems just using the database on a different computer (still prints the switchboard) on the same database, i also have a form, date selection type form, the user selects two dates on the form, presses a button at the bottom which is set to print a report, this report is linked...

it was originally as follows: openreport printout close then I changed it to the following to see if it made any difference, this macro makes it so the switchboard isnt even open when the print command is given, but still it prints it close (switchboard) openreport printout close (report)...

just been searching the forums and thought Id add to this post rather than start another I have the same problem, but my macro runs from a switchboard, so there is not the option of adding a command button in and there is no option on the switchboard to print the report just open it, also...