Search results

Very Good point vbaInet! and thanks a bunch folks..

HOw would i do that?

I am having a bit of trouble returning the average creation date for open items in my database.. I thought it easy to create a query where i select "AVG" on the "DateCreated" field. But instead of returning a date, it returns a number...

Thanks! you guys always come through in the clutch..

I am trying to drop the last 6 characters in a column... for example: I would like to make this: 123456-123456_12345 This: 123456-123456 i tried using "concatenate(Right(A1,6))" in excel but that returned the last 6 characters and trim did the same. Could someone point me in the right...

i dont follow your solution.. "Val()"

trust me this is not the most shocking thing that i've seen since i've been working with this group..

no i am not...

No clue.. not my databases.. i asked the same question..

Yes it does.

Can i link a text field to a number field? I have to linked tables. In one table I have a field, lets call it "Example", which is populated with a 6 digit number and defined as a number.. In the other table the same field exists but it is defined as text.. The 2 tables are linked so I can't...

Comments wasnt at first a date field but i made it a date field.. It had text and a date in the field. I removed the text to leave the date and changed the type to date.. Basically the 3 date fields are installation dates for a piece of equipment. unfortunately because of bad record keeping we...

Function ReturnEarliestDate(strInput As String, strDelimiter As String) As Date Dim varSplit As Variant Dim i As Integer Dim dteHold As Date varSplit = Split(strInput, strDelimiter, , vbTextCompare) dteHold = varSplit(i) For i = LBound(varSplit) To UBound(varSplit)...

Still throwing errors..

Question: if there is a null in one of the 3 columns will the it produce in an error?

Ahhhhhhh i see!

Thanks so much sir! However I get an error at this line: dteHold = varSplit(i)

I have a table. In this table is 3 different date columns. Is there a way that access can look at the dates in those columns and output the earliest date of the 3 into another column within the table?

Thanks sir! Yes it was the grouping.. Worked like a charm.. much appreciations..

In my table i equipment dates for the last 5 years failure. I would like to create a query that groups the dates by month and year and then counts the number of failures in that period (i.e. 01/2006 57, 02/2006 66, 03/2006 90 etc)