Recent content by vvariety

thank you for the response, due to the amount of meters each purchaser has and the potential to grow I found exporting it to a spreadsheet and giving the user the ability to format accordingly is a better avenue to take.

Here is an example found in the Help File of Access... SELECT CategoryID, Sum(UnitsInStock) FROM Products GROUP BY CategoryID HAVING Sum(UnitsInStock) > 100 And Like " You can try HAVING dCount([comment1],"Table Name","[comment1] = Pass") >= 6

if your report is based on a query you can put the >=6 in the criteria of the Passed column

Ok needing some help with my report, I have a crosstab Query as the source for my report, of course the issue is the column headings on the report. I have Purchasers as a row heading, Year as a row heading, Month/Year as a row heading, Meter as a column heading, PaidMCF as Value and, a total as...

Thank you that worked much better :)

in a query Field A: Acctno Field B: Space(6-len(wellid)) If I create the Make Table and then use that to export I get the same result. That is why I am Stumpped. By the way thank you for the assistance.

yes, i am referencing the wellid I have tried the space() functions will still the same results. Function ExportLabor() On Error GoTo ErrHandler Dim db As DAO.Database Dim rst As DAO.Recordset Dim intFile As Integer Dim strFileName As String Dim strAcctNo As String * 4 Dim strWellID As...

thank you for your response, but I have the export strictly in VBA, Since this is coming from a make table which is temporary. So VBA builds the text file from this make table and I would like to format it on the Export. Acording to what I have been able to read the RSet and LSet functions...

Hello Everyone, I have a table I need to export most fields are left align but there are two that are right align, I have tried to use the Space Function but it does not work well, I have also tried using the Rset in a vba module and thought it was working but now it is not. I'm stumped and...

Hi my name is Eileen and I go by Leenie, been an access developer since version 1.0.