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

Chapter 5. What Every Developer Needs to... > Practical Examples: Building Queries...

Practical Examples: Building Queries Needed by the Time and Billing Application for the Computer Consulting Firm

Build a query based on tblTimeCardHours. This query gives you the total billing amount by project for a specific date range. The query's design is shown in Figure 5.38. Notice that it's a Totals query that groups by project and totals by using the following expression:

BillAmount: Sum([BillableHours]*[BillingRate])


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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