Find Jobs
Hire Freelancers

aggregating data for reports in Access 2007

$30-50 USD

Completed
Posted almost 14 years ago

$30-50 USD

Paid on delivery
I have created an Access 2007 database to track interlibrary loan requests. I need to select data from two tables using date range, then aggregate by several other values. I have workable tables, queries, and reports, but need assistance with forms in order to run dynamic queries and generate monthly statistical reports. ## Deliverables I need data from two tables: Borrowing and Lending. I have created two queries--Borrowing_stats_query and Lending_stats_query. Both queries have corresponding Report (same name as the query). The reports include all the data, but I want to aggregate totals for all YES and NO items. I need one query that can search the date range in BOTH tables and aggregate the results. I also have a form (frmDateRange). I want to use this form as my primary place to enter the date range for BOTH Borrowing and Lending and then get a report which shows the aggregated data. I have also included a spreadsheet which shows how I need to have the data aggregated.
Project ID: 3371311

About the project

6 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$42.50 USD in 15 days
4.4 (23 reviews)
5.4
5.4
6 freelancers are bidding on average $41 USD for this job
User Avatar
See private message.
$42.50 USD in 15 days
4.8 (174 reviews)
7.0
7.0
User Avatar
See private message.
$38.25 USD in 15 days
4.9 (87 reviews)
5.3
5.3
User Avatar
See private message.
$42.50 USD in 15 days
3.8 (27 reviews)
5.2
5.2
User Avatar
See private message.
$42.50 USD in 15 days
5.0 (9 reviews)
3.7
3.7
User Avatar
See private message.
$38.25 USD in 15 days
5.0 (2 reviews)
0.2
0.2

About the client

Flag of UNITED STATES
United States
5.0
3
Member since Mar 20, 2007

Client Verification

Other jobs from this client

XSLT conditions
$30-5000 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.