Search results

Hi ByteMyzer, This is the very reason, I posted an alternative (even though you had posted the answer), so that you or some one else will comment on it technically ( advantages / dis-advantages ). I usually (perhaps always) use the method I have posted, for the kind of problem that the OP has...

An alternative, perhaps : SELECT qryDisinctRMNamesA.RMName, Table1.RMName, Nz([AUM],0) AS AUMNew, Nz([AUA],0) AS AUANew, Table2.RMName, Nz([MNA],0) AS MNANew, Nz([REV],0) AS REVNew FROM ( ( SELECT RMName FROM Table1 UNION SELECT RMName FROM Table2 ) AS...

"Why are we surprised when politicians play politics? It's not like they are supposed to be real adults... they are, after all, politicians and don't have real jobs and aren't playing around with their money." - Max Happened to come across above today & was surprised when I replaced the word...

Glad you found it helpful. Thanks:)

Just see if below gives some guidelines : The table myTable TheName TheItem Jane Widgets Jane Widgets John Gadgets John Gadgets Rob Widgets Rob Gadgets Joe Bangles Joe Gadgets Joe Widgets The sub-query qryA SELECT DISTINCT myTable.TheName, myTable.TheItem FROM myTable WHERE (...

Hi, Thanks for the confirmation. Thanks

Hi, Thanks for the confirmation on SWITCH(). Not sure, but I think the IIF() will also work along the same lines. Thanks

Hi, http://www.techonthenet.com/access/functions/advanced/switch.php "The Switch function will return the value associated with the first expression that evaluates to TRUE." Based on this, should not the logic work ? Thanks

Was wondering, what if we used the reverse logic ? TheNewReverseSwitchGrade_1: Switch( [ThePercentage]<40,"F", [ThePercentage]<45,"D", [ThePercentage]<50,"C", [ThePercentage]<55,"C+", [ThePercentage]<60,"B-", [ThePercentage]<65,"B", [ThePercentage]<70,"B+", [ThePercentage]<75,"A-"...

Degrees Awarded: Replace(Replace([Discipline #1],"Copy HS Diploma","-"), “GED”, “-“) Think, above should work. Just check the enclosing quote marks for ..................................................................................................., “GED”, “-“) Edit : I have done it again...

Check out if below gives some guidelines " TheNewSwitchGrade : Switch( [ThePercentage]>=80,"A+" , [ThePercentage]>=75 AND [ThePercentage]<80,"A" , [ThePercentage]>=70 AND [ThePercentage]<75,"A-" , [ThePercentage]>=65 AND [ThePercentage]<70,"B+" , [ThePercentage]>=60 AND...

To my eyes, Galaxiom has been supporting his replies with reasonable discussion whereas, I find that, you are only quoting the scriptures. He appears to have looked at all sides of the coin. Your response shows no analysis from you as an un-biased individual.

General, Not in reference to any particular post. Believe nothing no matter where you read it or who has said, not even if I have said it, unless it agrees with your own reason and your own common sense. ---- Buddha Don't just teach your children to read .... Teach them to question...

http://www.baldyweb.com/OverLap.htm Thanks

And modern ignorant men fall prey to it.:banghead:

Do not know if this is the problem that you are facing ? Just check if below gives some guidelines : The tables : Table1 ID Field1 Table2 ID Field2 Table3 ID Field3 The sub-query : qryAllIDs SELECT [ID] FROM Table1 UNION SELECT [ID] FROM Table2 UNION SELECT [ID] FROM Table3 The...

Glad you found it helpful. Thanks. :-)

Just check out if below gives some guidelines : SELECT myTable.theQuarter, myTable.theYear, IIf([theQuarter]="Q1",3,IIf([theQuarter]="q2",6,IIf([theQuarter]="Q3",9,12))) AS TheMonth, DateSerial([theYear],[TheMonth]+1,1) AS TheNextMonthFirstDate, DateAdd("d",-1,[TheNextMonthFirstDate])...

Somehow, not comfortable with the way the tables are structured ( though what you want can also be possible with the present set-up ). Let us just wait for someone to come along. Thanks

Sorry about that Brian. Although we do not know each other, please accept my condolences. Looking forward to you posting, that you have almost the whole world if not the whole world, on the plaque. Thanks