Search results

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.

I need to find out if the totals are correct on a report so I have a class called "Other". My hope is to find out if there are any typos. I have a textbox called “Other” with the code listed below hoping to find any records that do not fall into the normal categories we have, but I seem to be...

got it. Thanks

I've already got this code in the Form_Load procedure of the form: If Len(Me.OpenArgs) Then Me!Graph0.RowSource = OpenArgs End If I also found this in a message in this forum which works great: Dim sOffice As String sOffice = Forms![swg Query].Combo17 Me!Graph0.ChartTitle.Text...

okay, if I run this query, and I enter June 1st as the starting date and December 30 as the ending date and Fire for the department I get the data totals, for Therms, for the Fire department, by month. But when I try to create a chart and reference this query I get nothing on the bar graph. If...

Pat: Thanks for the great explaination. pcs:I went to the Microsoft download page and searched for keywords "Qrysmp97" but I got no hits.