Search results for query: *

Don, Thanks for the reply. I followed your instructions and the report works as before. I had sent you an e-mail also, so please ignore it. Thank you so much and take care!

I have a job cost crystal report that I wrote to use in Peachtree 2002. The report uses the GetPeachRowAmount to pick up inventory costs. Now we are upgrading to Peachtree 2005 and Crystal reports uses a different version of this additional function. This is the new format: GetPeachRowAmountv2...

Tom, thanks for your reply. I have checked the detail section and no extra space at the bottom in design view. I have normal page setup with it set to 1 column but actually the report prints 8 columns,(date, type, id#, hours, date, type, id# and hours). However when I change page setup to 8...

Maybe I should add some more info to my request. The query produces records which print correctly, but between where the good data prints and the page footer prints, there are two pages with blank detail sections. Please I do really need someone to take a look at this problem. Thanks

The report has seven pages for a particular service order number. Pages 1-4 and page 7 have data in all sections. Page 5 and 6 are blank in the detail section. The report is 7" wide with left and right margins of .5". I am printing to 8.5X11 paper. The report is based on a query that gets data...

Hello Duane, Thanks for the help. Sorry I have been away. I do not have group headers and footers on the NSEW field. I only have group headers and footers on SONUM and PE_DATE. I have not had a chance to filter the amount of data but I hope to do that in several days. Hello PH, Thanks for the...

Hello PH, Thanks for the help! I changed all the record sources to tables and the write conflict was no more. But what happens if you need to use a SQL query as the record source like I was doing initially. Do you still not use .edit and .update, but how does the record get changed and how do...

Hello PH, Thanks for the help! For the record source, I am using a SQL statement SELECT * FROM ACCCODES. ACCCODES has two field names NUMBER AND DESCRIPT. Are you saying to put the table name ACCCODES on the record source line in the properties? Also, should I not use a recordset and the .edit...

Hello Duane and PH, Thanks for the help. I am just using this field to sort. My sort sequence is STREET NAME, STREET NUMBER, NSEW, SONUM and PE_DATE. I am grouping on SONUM AND PE_DATE. PH, could you give me an example of using Nz Function? Is it possible with a SQL statement? Thanks, Francis

Hello Duane, Thanks for your help! I ran the query to get a count of the various records for the NSEW field. I discover that the field that I thought was spaces is, in fact, NULL values. None of the rows have a space in the NSEW field. The count for rows with a NULL value in the NSEW field is...

Hello and helpppppppppppppp!!!!!! I am having a problem when I try to change a data field on a form and have tried most of the fixes contained in the write conflict keyword search, but none seems to work. I open a form to see the rows in a table using the query as the record source: SELECT *...

Hi George, I am having the same problem and have tried most of the fixes contained in the FAQ, but none seems to work. Here is my code and I am trying to edit data on a form: Private Sub Form_AfterUpdate() Dim db As Database Dim rec As DAO.Recordset Dim strOldDescript As String...

Hi Roy and Duane, Yes I get the error 3464 (data type mismatch in criteria expression) when I include the "NSEW" field in the select for some of the reports. It appears to me that bad data in this field is affecting these SQL queries. The "NSEW" field is text of one character and should be...

Hi Roy, I rebuilt the query from scratch leaving off the "Order By" and did not select the "SO_MAIN.NSEW" field. This worked but since I had the "NSEW" field as part of my sort on the report, I always got a prompt for the value of "NSEW". I just hit the enter key and the report ran okay. Could...

Hi Roy, Yes the "SO_MAIN.JOBCODE" is a string. I used the single quote because it was enclosed with other SQL statements in double quotes while I was inserting the dates for the report. I am able to run the query as a query and get the expected results. I get the same records whether or not I...

Hi Roy, Thanks for your help. I tried using the "wherecondition" on the DoCmd.OpenReport {DoCmd.OpenReport "MonthlyActivityReport_Maintenance", acViewPreview,,"(SO_MAIN1.JOB_CODE) Like '7*' AND (SO_MAIN1.COMP_DATE)<=#11/30/1903# AND (SO_MAIN1.COMP_DATE)>=#11/1/1903#"} as you suggested and...

Hi Roy Thanks for your help. I tried leaving the filter ("MonthlyActivity_Maintenance") off the command and ran it like the following: DoCmd.OpenReport "MonthlyActivityReport_Maintenance, acViewPreview I get an Error 3464 Data type mismatch in criteria expression. What would you suggest? Francis

Please help with the following: First I am not using any aggregate functions! I am using the following query to populate a report: SELECT SO_MAIN.STR_NAME, SO_MAIN.STR_NUMBER, SO_MAIN.NSEW, SO_MAIN.SONUM, SO_PE.PE_DATE, SO_PE.PE_TYPE, SO_MAIN1.COMP_DATE, SO_MAIN.REPORTED, SO_MAIN.REP_BY...