• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Advanced Query Concepts > Practical Examples: Applying These Techni...

Practical Examples: Applying These Techniques in Your Application

The advanced query techniques you have learned will be used while you're creating the Time and Billing application. Take a look at several practical applications of these advanced techniques.

Archive Payments

After a while, you might need to archive some of the data in the tblPayment table. Two queries archive the payment data. The first, called qappAppendToPaymentArchive, is an Append query that sends all data in a specified date range to an archive table called tblPaymentsArchive. (See Figure 12.43.) The second query, called qdelRemoveFromPayments, is a Delete query that deletes all the data archived from the tblPayments table. (See Figure 12.44.) The archiving is run from a form called frmArchivePayments, where the date range can be specified by the user at runtime. (See Figure 12.45.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint