Search results

My favorite kind of music is mostly guitar related, but to just list a few The Beatles Queen Steve Vai Eric Johnson Tommy Emmanuel Not directly related to this but here's something I read about the quality of music on CDs not being as good as they used to be. YouTube - The Loudness War...

I wish you a speedy recovery, Bob!

Maybe this might help? - 'Conditional Formatting' of controls in a continuous form

Are you trying to do this in a query or a report? Since you are asking in the query section, here's how to do it in a query. SELECT Product, Type, Sum(Qty) AS SumOfQty, Cost, [SumOfQty]*[Cost] AS Total FROM tblData GROUP BY Product, Type, Cost;

Previous Date & Sum of Month/Year to-date using a correlated subquery Hope this helps!

Glad to be of help. :) I will try to incorporate your suggestions. I appreciate your thoughtfulness! There really isn't anything in the code that is unique. It's more of an example of - how I would create cascading comboboxes - how I would bind them to a field - and how I use the AfterUpdate...

It might help if you could post an example file with some data in it so that I know what you are going for. My example is only meant to show how to limite the available options in comboboxes based on options in a "higher" combobox. You can just bind those comboboxes to the fields in the table...

mab9, How about setting the conditional formatting to Field Value equal to DMax("[lngValue]","tblData","[lngValue]<(SELECT Max(lngValue) FROM tbldata)")

Assuming we have a table called tblData with a number field (LONG) called lngValue, here are two ways to go about it. Using DMax() SELECT DISTINCT DMax("[lngValue]","tblData","[lngValue]<(SELECT Max(lngValue) FROM tbldata)") AS SecondHighest FROM tblData AS a; Using SELECT DISTINCT, TOP, and...

Maybe this might help? - Cascading Comboboxes

I have Office XP Developer Edition installed on my Windows XP computer. Through my company, I got the chance to buy a copy of Office 2007 Enterprise Edition for use on my personal computer. Has anyone ever installed Office 2007 over Office XP/2002 or any other older versions? If so, I was...

Thanks, EMP! Doh, I missed that! :o So the Switch() should be changed to Switch([Fails]>0,"FAIL!",[CountOfStatus]=[Passess],"PASS!",[WIPs]>0 And [Fails]=0,"WIP!") Also, I should point out that you can use DCount instead of a Select Subquery. Just that I am used to not using Domain Aggregate...

For the 5 records that were given there wasn't anything to concatenate by (see below). My example only concatenated those records where the combination of ID, Name, and Status were the same. ID - Name - Status - Comments 1120 - One - Pass - uniquecomment1a 1120 - One...

I assume you mean the fConcatenateFldGroupBy() function from Concatenating unique field values for records matching a query's GROUP BY clause. (Old link) Please find attached an example Access 2000 file. The SQL statement is as follows SELECT DISTINCT ID, Name, Status...

Thanks! This is the first Access forum I joined and I am glad that I did. I've learned the most from people here helping me when I first started to use MS Access. :)

My congrats to the three as well! There are more great posters on this forum that deserve recognition as well! They all make this truly a great MS Access forum! :D

Not that I know of... :( You're sad and cool/happy about my moving? :confused: :eek: I've haven't come accross come any adult content yet, but I do have my adult content filter on.

I do like stumbling upon pages that I might not have found or thought to find on my own. But it does seem like a waste of time sometimes to sit there and keep hitting the "Stumble!" button till something interesting comes along. After awhile, I found some people's stumbleupon blogs that are...

Like the title says, does anyone here use StumbleUpon (http://www.stumbleupon.com)?

I assume you have something like this in a table Product ID, Reference, Description 2211, C1, 10uF 15V 2211, C3, 10uF 15V 1392, C6, 22uF 15V 0100, R3, 10K 0100, R4, 10K 013, R2, 4K7 And you want to end up with a query that returns something like this Product ID, Reference, Description 2211...