Recent content by rschultz

Thanks - I'll try the suggestions - it's nice to have a couple alternatives

A fellow employee created a table that has ss#s. Different people have been entering the data. Some added the dashs others did not. How do I run a query that checks to see if the 4th character and the 7th character are dashs and if they are not insert them so all the ss#s will have the same...

thanks, we'll give that a try.

We just upgraded from Office 2000 to XP and when a user goes into a database he created he gets a message that says, "Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5" What is that and how do we fix it?

Ah, okay I will try that. Thanks

I tried to delete all the records in a table and then import new data froma text file. I tried: DoCmd.RunSQL "delete * from ZPAY6176" DoCmd.TransferText acImportDelim, , "ZPAY6176", "H:\Access\New Carpool\z_pay617.lis", False Which deleted all the records but then I got a: "Cannot Update...

okay, I found out why the subreport is repeating but I don't know how to stop it and I don't know how to get the total of the subreport. The subreport repeats for every record in the main report. That is, on 11/01/2001 there are 63 records on the main report, so the sub report repeats 63 times...

okay that wsa a good start<grin> at least I'm getting a number now, not just 0, but it's just giving me the last number total for the subreport. Also I have another problem because I made the subreport visible so I could see what was going on and the subreport repeats several times, even though...

I created a subReport called "Other Status:" In it I have a field called Weigh_Net and in the SubReport Footer I have a Text box called TEXT6 with =SUM([Weigh_Net]/2000) - that works. Then in the Main Report Footer I have a textbox with: =Sum([Reports]![MJs Report]![Other Status:]![Text6])...

KKilfoil:thanks for confirming what I thought I knew. I thought about your idea to have query that includes what I'm looking for but one of the things the query is doing is filtering out typos, among other errors. If the totals don't match they can run the "other" query and see that e.g...

>>If you are looking at your query on the design grid, I suspect you did not put [Center] <> "ER" on EACH criteria line << but if that's true, then the first one should work with the [Bil_Name] and the [Center] requirements on the same line shouldn't it? Why even have an OR statement then?

I have a query: SELECT Crinc.TRANS_DT, Crinc.CENTER, Crinc.BIL_NAME, Crinc.ROUTE, Crinc.PROD_LIST, Crinc.CARRIER, Crinc.WEIGH_NET FROM Crinc WHERE (((Crinc.TRANS_DT) Between [Forms]![Crinc Query Menu]![startdate] And [Forms]![Crinc Query Menu]![EndDate]) AND ((Crinc.CENTER) Not Like "ER" And...

I remembered than Pat has said not to reference the Control but to sum the formula so I also tried: =Sum([Reports]![MJs Report]![Other Status:]![Weigh_Net]) in a textbox in the Report Footer of the main report but I still get 0

okay, sounds like a good idea. I created a subReport called "Other Status:" I have a field called Weigh_Net and in the SubReport Footer I have a Text box called TEXT6 with =SUM([Weigh_Net]/2000) then in the main Report I have a textbox with: =Sum([Reports]![MJs Report]![Other Status:]![Text6])...

I have a select query that finds the records in the "Other" category but they want to have a line on the report that shows if there are any.