Search results

i managed to figure this out using the wizard. .. turns out it was pretty straight forward. SELECT DISTINCTROW [q0032 mBuckets].mBucket, Sum([q0032 mBuckets].DV01) AS [Sum Of DV01] FROM [q0032 mBuckets] WHERE [q0032 mBuckets].[Result Currency]='MYR' GROUP BY [q0032 mBuckets].mBucket; thanks...

I'm actually working off of an existing access mdb created by someone else. I've identified one of the queries as a good jumping off point for what I want to do. Basically, that query takes multiple raw data of interest-rate durations from multiple portfolios and combines them in to one query...

can you please provide a sample code on how to perform the addition in a query?

yes, i'm only interested in the sum.

@wiklendt: the two dbs/queries/tables are to be made one. since they both have the same fields, I don't want to append. @rainman89: can you please explain how you mean to use queries instead of tables and how it explicitly applies to this case? To clarify, here are my two queries q1 and q2...

forgive my newbie question, but i'd like to know how to add numbers from two different queries. for the sake of discussion, I have two different queries q1 and q2, that extract the number of oranges, apples and kiwis from two different source files. how do i aggregate the number of oranges...