Recent content by lifeis

Hi penguino29, Thank you for your reply. I would do this if it was possible, the problem I have when doing this is that my two tables don't have a unique identifier (or primary key, whatever access calls it), so when I try to merge the tables into one, it assumes each value is related to every...

Hey All, Unfortunatly I seem to have hit a brick wall with an application I am currently developing. I have tried everything I can think on, but just cant get my head around how to acheive what I need. Basically, I am using Pass-Through queries to query a remote SQL Server, the application has...

Just thought I would post my solution to this problem incase anyone ever encounters this same problem in the future. The reason why DateDiff was returning a crazy amount of hours was simply because of the time format. It was formatted to MM/DD/YYYY - as that is what I had read everywhere, when...

Thanks for your reply. I have managed to pass through the dates and times and receive an output. I am using DateDiff("h", 04-01-2011 02:49:00, 04-05-2011 07:50:05) However, it is returning 2885 hours! I dont have a clue where it is getting that from. Any ideas? Thanks again, this is much...

Thanks, I believe that is my problem. I now have to figure out how to seperate the Date value from the Time value, then format them and finally concatenate them back together. Then with that value, I can use DateDiff to figure the amount of hours between. My first problem though is how to...

Thanks for your reply. I have already had a look at the site that you linked to, but I couldnt see anywhere about using a Date and a time, all the examples use only date. When I try to run two of my dates and times through DateDiff, I get 'Type mismatch' error. Should DateDiff accept this...

Hey guys, Any help with this would be really appreciated, I have looked around on Google for ages, but amnt having any luck. I have found pages about using DateDiff() to calculate the difference between two Date values, however my values are Date and Time Values, for example, 03/14/2011...

Yes, the last characters after the letters at the begining can be either Numerical or Alpha Characters. They can also be at varying legnths. If I could just split the String into two, splitting at the point where the first number appears. So: CV2112 would become: CV & 2112 SV2011B Would become...

The first few characters are always a letter. What I want is to seperate so that: When the code gets to the first character which isnt a letter, it splits. So examples: CV2010 >>>> CV & 2010 MGH2136 >>> MGH & 2136 C2510 >>> C & 2510 I will read up on those functions tonight. Thanks alot for...

Hey Guys, This could possibly be very complicated that im trying to do and I am certainly not an expert in VB. But I know that it must be possible so I figured I would ask you guys and give it a shot. I have uploaded a picture of the table that I wish to extract data from. Basically, there is a...