Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Confused on query definition for report generation

Confused on query definition for report generation

Confused on query definition for report generation

I have a table that has Division, Unit, Assigned to, Rank, cell number

Not all entries have a rank - for example a shared vehicle cell phone.

I want to create a report that shows all the cell phones, but listed in rank order.

Below is how the query is currently built.

SELECT Employees.[Assigned To], Employees.Division, Employees.Unit, Employees.[Mobile number], Employees.[Print on Report], Ranks.Rank, Ranks.[Rank Order]
FROM Employees INNER JOIN Ranks ON Employees.Rank = Ranks.Rank
WHERE (((Employees.[Print on Report])=Yes));

When it is run, it only shows records that have a rank - it does not show records that do not have a rank (i.e. the shared cell phones).

How can I generate a report that shows all the cell phones whether or not they have a rank.

Thank you.

RE: Confused on query definition for report generation

You need to double-click the join line between Employees and Ranks and set the option to include all records from the Employees table.

Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Confused on query definition for report generation

Amazing what one little tick box can do!:)
Thank you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close