Very quick question

dk · Nov 8th, 2009, 08:47 PM

If you have totals in your first query then you will not need to recalculate for other queries (assuming that you are wanting to use the same "total" value in your other queries). You can think of a query as a "virtual" table - it will behave the same way as if you were querying a table directly more or less.

HTH
DK

nancybrown · Nov 9th, 2009, 09:57 PM

Many thanks DK

Nov 8th, 2009, 08:47 PM	#1
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,569	Re: Very quick question If you have totals in your first query then you will not need to recalculate for other queries (assuming that you are wanting to use the same "total" value in your other queries). You can think of a query as a "virtual" table - it will behave the same way as if you were querying a table directly more or less. HTH DK

Nov 9th, 2009, 09:57 PM	#2
nancybrown Join Date: Apr 2005 Posts: 374	Re: Very quick question Many thanks DK __________________ Buck

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode