Search results

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...

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?

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...

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])...

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 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...

I work with a couple people who do some programming in Access. They both have queries that reference other queries. To me it seems like spaghetti code. What's the scoop on that? Is it acceptable or bad form?

I'm getting "syntax error - missing operator" with the following code. I think the problem is in the GROUP BY part. I copied it out of the ROWSOURCE on a Chart and it had "MMM \'YY" but the double quotes won't work in a SELECT statement so I had to change them to single quotes which I think...

Im having a problem similar to Nancy's back on 8-7-2000. I did a search for "Chart" and her's was the closest to my problem but the solution wasn't there. I created a chart on a report and on a form and associated each to a query. When I double click either I get a prompt to enter the begining...

I have a textbox on a mainForm called TotalTime in which I'd like to sum the total of the [Time Spent]textbox on all the subForm records, but just for the ID # of the mainForm. I tried: =Sum([Sub Table].[Time Spent]) (afraid that I would get the total for the entire table, not just that ID#) but...

I need to get a count of all the records where the BillName <> 'Landfill' but I only want to display the records where the weights are over 14020 pounds. I'm not sure how to do that. I ran a query that gets all the records that have both requirements but then all the records show. Do I have to...

I have the following formula in a textbox in the page footer of a report: =Sum(IIf([Prod_List] Like '*Compact',[Weigh_Net]/2000,0)) the result is 694 beneath it I have another textbox with the following formula: =Avg(IIf([Prod_List] Like '*Compact',[Weigh_Net]/2000,0)) the result is 5.46 I...

I'm trying to write a query that finds any category that is not on of the ususal ones. so I have: SELECT Crinc.CENTER FROM Crinc WHERE (((Crinc.CENTER) Not Like "ER" And (Crinc.CENTER) Not Like "WR" And (Crinc.CENTER) Not Like "SE" And (Crinc.CENTER) Not Like "RO")) OR (((Crinc.CENTER) Is...

I have the following code in a texbox called "Compact" : =IIf([Prod_List] Like '*Compact',[Weigh_Net],0) Thanks to Pat it's working fine. But in the [Date] footer, I tried to sum that textbox with =Sum([Compact]) but I get an 'Enter Parameter Compact' box. I know I've done this before...

I have the iif statement listed below in the ControlSource of a text box in the detail band of a report, and I keep getting a Runtime error 3075 syntax error (Comma). I've used iif statements before and I pasted this one in a query and it ran and gave me the correct results. What's the secret to...

is there a way to change just the last four digits of a date? I just need to change the year on several records.

I can import a text file using the following code: Docmd.TransferText , , "Crinc Temp", "C:\Access\Rec_1019.txt", False but I want to be able to place a textbox on a form and have the user be able to enter the textfile name they want to import (the text file is always the date so it will...

let me see if I can reword my question or better express what I need. I have a report grouped by [Product] and I set the select statement to ask for 'Wood' or 'Veg', but I also need 'Vegr'. However When the grouping shows up on the report I just need to group by Wood and Veg and show the...

I have a report that I have a group for the [PROD] field. I have a query that says: ((tblScaleData.PROD)='Veg1' Or (tblScaleData.PROD)='Wood1') Or (tblScaleData.PROD)='Vegr') but I need Vegr to not show up in the group, but I need to add the weight associated with it and then subtract that...

I have a database that, when created, someone made one of the fields by concatinating two fields from anotehr table as it was imported into Access 97. Now someone else needs one of the columns to be data from the right field 'before' the concatination. Is there a way to say exclude the left...