Search results

I am looking for Distinct values in only one of the lists

SELECT DISTINCT and then a field list. can I apply to only a certain field?

I have used DISTINCT in the sql straight after select. However the search is not showing sales of the same item price when I only wanted distinct order dates. Can DISTINCT be applied to certain fields only?

Hi, I am typing in a query and ran it. Getting error message "cannot find the name entered in expression" I can see my typo but the message will not close down Anywhere i go its "musical" Any ideas? I dont want to lose all the work on the SQL

Thanks for the concise explanation MajP Can the mid function, Seems very handy, be used to split and extract any part of a string?

Thanks CJ, This has worked perfectly once I sorted the text numbers out!

Hi Maj, It is displaying exactly the same as the referenced column. But when sorted it is correct order. Thank you My Friend

Also, for future reference and to keep within rules etc. should I keep all my problems in the one thread or start new threads for every problem. I don't expect CJ to be a personal tutor but he has set me on a path.

hello MajP, thank you for trying to assist. I am stuck with the data as presented in the table and have no opportunity to rectify it. HOW? I am a complete novice so need an idiot guide.

Hi CJ, Apologies for not being in touch, we have been away a couple of days. I have stared to dig into this a bit and have hit a snag. My "sale" column data has a pound sign in front of the sale figure; £200, £75 etc When listing the sale rank it is going 75,50,25,200,100 etc It seems to be...

Thanks, I take pride in the fact that I am still capable of learning something new despite the daily cramming of my brain over the last 59 years. Your advice is the way that I always try to proceed, I just cannot move forward until I understand what I am doing. Sometimes I wish that I was just...

Thanks again, I am new to all this so what you are doing in minutes could take me weeks, because I need to try to understand whats going on.

Thank you so much CJ, I will try to wrap my head around that!

Bob 20/5/24 13/4/24 7/2/24 10/12/23 14/1/23 sales rank 1 1 2 3 1 for the dates thing, I need to pull out the five most recent dates that bob worked for us and his sales rank on that date "MAX" can only get me the most recent. Helen and Rupert may have worked totally different dates, but for...

my bad addition! you get it though?

Thank you CJ for trying to assist! I will attempt to clarify 20/5/24 Rep Sales Bob 100 Bob 200 Bob 75 Bob 50 Bob 25 Helen 250 Helen 50 Helen 75 Rupert 75 Rupert 25 Rupert 40 Rupert 50 Rupert 50 This is the output I need Sales...

Hello everyone, I found this forum through research on working with dates where I found information on "MAX". It didn't quite meet my requirements so I thought to myself why not join the group and try to contribute in some small way. I have a huge database with some 50 tables and it goes...

Thank you all for the warm welcome!

I am not new to access as I have a quite large database, I do however have difficulty extracting the information that I need from it. I have previously used hired help but now feel its necessary to man up and learn it for myself. I have very limited programming experience, some machine code and...