Search results

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

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

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

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

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

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

Hoping someone can help. I want to remove the word "Metallic" and the word "Pearl" from a field called "Options" in a table called "Specification" and be left with everything else. Thanks

I have created a linked server in SQL 2000 to a database on a Unix server and all the tables show in SQL enterprise manager Linked Servers. The linked server in called Kpay Is there any way to directly link to the tables on the Kpay linked server directly with Access 2000 so querries can be run...

Is there any way to send the contents of a query by email other than using the SendObject. I am having all sorts of problems with security since upgrading form exchange 5.5 to 2003. I used to be able to send without any problems using Outlook 2000. I thought there might be away to do it...