Use Query to Summarize Data by Date

[HotelierDream]

Hello All,



I have been working with a plan to streamline some reports for a hotel, well part of it is that I have a XML import to do on a specified period of time. What I would like to do is take my table [G_TRX_CODE] and first move specific fields and records to a new table. Example:

[G_TRX_CODE]	TransLog
TRX_CODE	TransCode
TRX_DATE_CHAR	TransDate
TRANSACTION_DESCRIPTION	TransDescr
Quantity	Qty
GROSS_AMT	Total
TC_Group	Group

I am wanting to do this as this table is the master list and will be updated nightly. I am sure this is easy to do but I cannot remember how.

Once the new table is made I would like to make another one named [Monthly] that summarizes all the transactions. The records in TransCode, TransDate and TransDescr repeat daily so I am unsure how to do this. Could I also make the TransCode list reference a Table that has the master list of TransCodes,TransDescr & Group?


Sorry to ask so many questions I am just trying to figure out the best way without making a million Queries..


See attached DBTransV1.zip

[June7]

Doesn't matter if table is 'master' table and updated nightly, use a query. Same for the 'Monthly' table - don't - just build a query. I doubt a 'million' queries are needed. Use filter criteria to restrict record selection. Apply filter to forms and reports when opened.