Search results

I don't understand what you mean by asking if the menus are on the table? I have compacted and repaired and this has not fixed the problem but I don't understand why you are asking about autonumbers as the reference?

So, I have several menus in one of my databases, all nicely arranged with groups that contain shortcuts that run macros, run queries or open tables. When I began to run through one of my daily processes today I double clicked the first item and I realised that it was attempting to run a...

The solution that I have posted is working fine. Thanks for caring, plog.

Ok, I think I am going to revert to using the Top 1 record selection in the properties, sort on the Auto field and then remove the first function. This should work as the data that I need to extract is always in the first record. edit; yes, this has worked. Thanks guys 'drum

Thanks for the quick response. Why is the First function not valid? I am using it to extract from the first record in the table, specifically the word before the first occurrence of the character ":"

Ok, this is driving me absolutely mad. Background is that I am importing a text file invoice into my database. The table that I import the text file to is deleted before the import takes place. The table has a field called Auto (Autonumber data type) which is sorted into ascending order. This...

Thanks for the heads up but I can't really find a simple solution. I have decided to approach this a different way and say that if the call log day is a Friday and the difference between date of contact and the call log date is greater than 3 then it is late (return a value of 2) and if the...

Hello, I am trying to deploy the datediff function to return the number of working days between 2 dates. Nice and simple so far, I want to exclude Saturdays and Sundays. I have a Call Log Date and Date of Contact and I would like to return the number of working days between the 2. If I use...

Ok plog, here is the actual code for the query (AVFinal); SELECT TOP 3 AVBase1.Month, AVBase1.Criteria, AVBase1.[Fitter Name], AVBase1.MTD, Round((AVBase1!MTD/[Current Month Position]![nth Trading Day])*Month![Trading Days],0) AS Projected FROM (AVBase1 INNER JOIN [Current Month Position] ON...

I attach the query as a text file. The points would be added as column on the end giving 3000, 2000 and 1000 points. Thanks 'drum

Hi there, This is a real situation that I need a bit of help with please. Where I work the salesman that sells the most of a particular brand of tyre gets 3000 points, the second highest gets 2000 points and the third gets 1000 points. I have a few very basic queries that calculates the number...

Brian, thanks very much for your help but I couldn't get it to work. I went with the Top n Value example on the AllenBrowne website in the end - thanks very much jdraw. 'Drum

Good Morning, I am designing what is in theory a very basic set of queries but I am stuck on the "Top Values" element. The scenario; Basically I need to list the top 20 selling products by brand. There are multiple brands and I am leaving this field blank in order to capture all of them. Problem...

Ah, sorry yes - Dunlop would be the second word

Hi jdraw, Yes these are tyres. My 2 examples are how I am receiving the data and I need to extract the manufacturer name. In each case the manufacturer name is the second "word" in the string. As more brands will be introduced I don't want to build a static table that lists the manufacturer...

Ok, thanks sir :rolleyes:

But I'd appreciate some help with my particular example? Come on guys, I know you want to help.......

Bonjour, I need to select the second word from a product description. Here are two examples; 2156015 Dunlop SP-30 1756514 Goodyear Sport I found the correct code on another website to do this in Excel; =MID([field], FIND(" ",[field],1)+1, FIND(" ",[field],FIND(" ",[field],1)+1)-(FIND("...

Well Paul I have rebuilt the query from scratch and it works. I can do it all in one stage rather than two and for the life of me, I cannot see what the problem was but thanks for your help anyway :)

Thanks Paul. I understand what you are saying but there are no zero turnover or profit values. In my "base" query I have 72 records. The turnover figures are all positives and the profit values are calculated by subtracting the cost from the turnover. All of the profit values are above zero too...