Insert data based on a previous query

[que4life]

I have a query that works fine...What I want to after the query is insert the Sum(LoungeTotalSales) Into another table. Below is the query that works fine...

SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And [@EndCalDate]));

Thanks for any help...

 

[PHV]

INSERT INTO AnotherTable (AnotherField)
SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE L_Date Between [@BegCalDate] And [@EndCalDate];

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

Not that it really matters, I'm just curious, but do you have a valid reason for breaking normalization rules?


Leslie