Search results

CDbl is the function. ? CDbl(Date()) 42173 ? CDbl(Now()) 42173.6818402778

Thanks spikepl. That worked, I was thinking a bit funny yesterday ! It is all good now. :D

Okay, in simple terms. SELECT all records whose MonthAndYear(StartDate) <> MonthAndYear(EndDate). I am working with MSSQL, so Access' Format might not come in handy. The Period I am running is between 01 May 2015 and 31 May 2015

I am having a fry up day. I am trying to figure out a logical WHERE condition. I have a Query that gives me data, Name | Start | End --------+-----------------+------------- Paul | 30-May-15 | Eugin | 21-May-15 | 28-May-15 Francis | 04-Mar-15 |...

So in other words, they are not really Date and Time type but simply Text type. Try casting the text to a proper date format, using the CDate function.

So try a HAVING or WHERE clause.

I am not following you. It seems to return exactly what you asked for. Maybe not what you wanted. Could you show the SQL?

There is one funky way to get the last date of a Month, this will make use of the DateSerial function. Something along the lines of, SELECT theListOfAllFieldsYouWant FROM yourTableName WHERE EndDate = DateSerial(Year(EndDate), Month(EndDate) + 1,0) OR ClosingDate =...

You will need a bit of VBA (Not Recommended). How good are your VBA skills? If you would not want VBA, then you should restructure your DB to achieved this (Recommended)

Most Welcome. Good Luck :)

Hello Mohamed. Welcome to AWF :)

You can use a TOTALS or a GROUP BY Query. Something like. SELECT Year(yourDateField) As YearNumber, Count(anotherFieldName) As TotalSales FROM yourTable GROUP BY Year(yourDateFieldName)

It is not Excel formatting, it is Windows Naming conventions. As per the name space convention windows does not allow certain characters to be a part of a file or folder name one of them is /. So the answer to your question Is it possible to do? is No, you cannot. mm-dd-yyyy is possible not...

Create a SELECT Query that will get you this information. Something like, SELECT addressLine1 & " " & addressLine2 & " " & addressLine3 & " " & postCode As fullAddress FROM yourTabelName

What are you SELECTing FROM the Table? Your SQL should be something like SELECT fieldName1, fieldName2, fieldName3 FROM yourTable WHERE someField = 'Some String' AND someNumberField = 10 AND someDateField = #05/31/2015#

You could use Functions in SQL could you not? translating the function using the Allen Browne's ConcatRelated should be easy (I guess)? How about this thread? http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

You seem to be missing the FROM clause. Then improper use of concatenation.

Explain. Is the Data Type of the column number? Not really :D

Try this, Private Sub Review_Invoice_Click() Dim tmpRS As DAO.Recordset Dim customer2 As Variant Dim PurchaseDate2 As Variant Dim VendorName2 As Variant Dim VendorInvoice2 As Variant customer2 = customer PurchaseDate2 = PurchaseDate VendorName2 = VendorName...

Show the code you actually have used so far.