Find Jobs
Hire Freelancers

Access 97 Query

$30-5000 USD

Completed
Posted almost 22 years ago

$30-5000 USD

Paid on delivery
I have an Access 97 database with two tables, and I need assistance with creating a specific query. The first table ("Family") has the following fields: "AutoNum" (PK), "Last Name", "Street Address", "City", "State", "Zip Code", and "Phone Number". The second table ("Family Members") has the following fields: "Family Key" (related to AutoNum above), "First Name", "Middle Name", "e-mail Address", and "Nick Name". I need a query that will display the query's result in one row (record). The information (record) to be displayed is "Last Name" (from the "Family" table) and each "First Name" (from "Family Members" table) that is related to a specific last name. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. An Access 97 Query that will display the query's result (described above) in one record. For example, if the "Family" table is populated with the "Last Name" values of "Doe" and "Brady" and related to these values the "Family Members" table is populated with the values "John" and "Jane" (related to Doe) and "Mike", "Carol", "Greg", and "Marsha" (related to Brady), I need a query that will display two records. The first record would be "Doe", "John", "Jane". The second record would be "Brady", "Mike", "Carol", "Greg", "Marsha". ## Platform Windows 98
Project ID: 2854005

About the project

17 proposals
Remote project
Active 22 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.
$1 USD in 14 days
5.0 (1 review)
0.0
0.0
17 freelancers are bidding on average $16 USD for this job
User Avatar
See private message.
$25.50 USD in 14 days
5.0 (107 reviews)
6.2
6.2
User Avatar
See private message.
$8.50 USD in 14 days
4.1 (49 reviews)
6.3
6.3
User Avatar
See private message.
$21.25 USD in 14 days
5.0 (3 reviews)
4.7
4.7
User Avatar
See private message.
$42.50 USD in 14 days
4.9 (50 reviews)
4.6
4.6
User Avatar
See private message.
$4.25 USD in 14 days
4.6 (22 reviews)
4.3
4.3
User Avatar
See private message.
$4.25 USD in 14 days
4.6 (19 reviews)
3.7
3.7
User Avatar
See private message.
$25.50 USD in 14 days
5.0 (4 reviews)
3.2
3.2
User Avatar
See private message.
$8.50 USD in 14 days
4.7 (8 reviews)
3.1
3.1
User Avatar
See private message.
$21.25 USD in 14 days
5.0 (3 reviews)
0.2
0.2
User Avatar
See private message.
$10.20 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$21.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$21.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$4.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$8.50 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$21.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$25.50 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jun 3, 2002

Client Verification

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.