Recent content by hgus393

Thank you very much. The final result if someone is interested: SELECT Table1.Name_, [Table1].[Value]-[Table1_1].[Value] AS ValueDiff, Table1.Date_ FROM Table1 INNER JOIN Table1 AS Table1_1 ON Table1.Name_ = Table1_1.Name_ where Table1.Date_ > Table1_1.Date_ ORDER BY Table1.Date_; Cheers BOB

Hi, Sorry for the title of the thread. What I am trying to do is the following I have three columns Name, Date, Number What I need to do is find the difference in the number column where the Name is the same but the date is not ex: Bob 2013-12-12 123 Bob 2013-12-15 456 Jane 2013-12-14 789...

Ahem..figured it out had defined datediff variable as integer ...

There are several ways to import exceldata ignoring the field names. I use a method defining excel as an object and then tell it to import to a table which already exits. My way is perhaps not the best, but it works for me. Check code below: Sub ImportBlood() Dim sPath As String, sFile As...

Hi, when running a custom function finding the number of days between two dates I use datediff. However I get overflow when the date is too far away in the future. Is there a maximum or a limit on the number of days (or date) that datediff can return? Cheers Bob

Hi, don't know if ot helps you but check out this link: http://www.access-programmers.co.uk/forums/showthread.php?t=37245 Cheers Rob

The spreadsheet comes from a batch system. The spreadsheet will be dynamic in rows but the headers will be the same. Yeah I guess that going to the source system will be my best bet. Cheers for the insights Rob

Hi all, I get a report in excel that is formatted quite strangely. I would like to import this file into access. The problems are the following: The file itself has headers -which is good. However, the file itself contains a lot of merged cells which need to be unmerged. The second problem is...

Of course :o....Cheers mate!! //Rob

My own database (exclusive), changing from text to double. However I have a startform which has several subforms which have the table a control source...

Hi all, Is it possible to temporarily close down bound objects in table as I need to change the data type for a column? SQL Alter will no work, opening the table in design view does not work either.. Cheers Rob

Hi all, I wonder if this is possible? I have a database that keeps track of the cash balance. In the database I also have some securities that can be used as collateral. What I am trying to do is when the cash balance is negative then I would like to be able to use the collateral to offset...

Awesome!! Thank you very very much!! :D Cheers Rob

Hi, Sorry for being unclear. All this is in Access. I have posted a sample database. There are two tables: MainTbl that contains dates and a text field . Buckets contain dates and an indicator D1 to D65 that correlates with the first working day to the 65th working day. What I am trying to do...