Recent content by srbooth

I'm using the following code in the event On Format of a report. If Me.SalesTargetUsed = 0 Then Me.SalesActual.Visible = False It works except for the fact it makes all the fields hidden after it finds the first one that meets the condition above. I want it to only apply to the fields that...

Never thought of that one. Thanks

Wouldn't that just average the values in a column? I'm looking for the average of the values in the row

I have a table that stores Salesmans sales results by type. What I want to do is calculate the aveage sales by salesman and show results in a query. The fields in the table are [Salesman] [New] [Used] [Gap] in a table called results -----------New-----Used----Gap----Average...

Thanks managed to work it out the DateDiff did the trick

Hi Can anyone help me with this? I want to be able to calculate the number of months between certain dates held in a table. ie StartDate and CurrentDate. Thanks

Thanks for that, I understand the logic bit I am struggling with the macro. I get the error: Microsoft Access can't find the form 'Table1' referred to in a macro expression or Visual Basic code. The string in the SetValue Item field is [Table1]![random] Is because you cannot update with...

Thats works great, but it gives the same random number to all the records that have been querried. Is there any way to issue a different random number to each record in the queery? Thanks

I would like to add a field in a querry with a random number of 1,2 or 3. I have looked at RND function but it doesn't seem to let you specify a range of numbers to use. Thanks

The first bit sounds straight forward for randomizing the records, but how do I assign the operator number to each record making sure each of the three operators gets an equal amount of records. The operator field is left blank waiting for it to be completed. Thanks

You could drop the Code Field and used Group by on the Invoice field and Sum on the Item field

Is there a way where I can take records in a table and split them by dividing them among three users. In other words, issue a unique operator number 1,2,3 to a field in the records table that would share all the records by the three operators, randomly. Thanks

Does Access 2000 support the Replace function?

This is the SQL code UPDATE tblSpecOptions SET tblSpecOptions.[Option] = Replace([Option],"Electric","Windows"); but I keep getting a compile error!!!

I am trying to use an update query to modify some text in a specific field using the REPLACE function without much luck!!! I have a field called "Option" and I want to replace the word "Metallic" with "Paint" and the word "Electric" with "Windows". Could someone please point me in the right...