Search results

Can you help me add a format to the Sql select for currency :banghead: This is just a section of the full code before Function RunLWSCA() Dim cnn As ADODB.Connection Dim rstUplo As New ADODB.Recordset Dim rstDiag As New ADODB.Recordset Dim rstTemp As New ADODB.Recordset Dim SQL...

Thanks. Why did that make the difference?

Can someone help me with this query issue. The SQL below allows me to merger a column in to a single cell based on FacID, only if there is more than 1 provider. How can I get it to also return FacIDs with only 1 provider? Example FacID Provider 1 Jane Smith 1 John Doe 1...

But how do I get it to show a single business name and address with an inserted table with many lines of data?

Does anyone have any idea how I can do this?

Hi There, I was wondering if you can help. I need to take data from a form with many sub-forms. The letter has to be in word to allow for edits. Its an appointment letter, however is has a table with 1-100 lines. I need to be able to add the name, address, date of appointment and table with...

I Created a form and linked it to a ODBC table with no data. Set the Allow Additions property to Yes. It shows fine if there is data in the table but not when there is no data. Please help:confused: