Year 12s: what will be the first way you research your future options? >>

Forums
Microsoft Access Report

This discussion is now closed.

Check out other Related discussions

It service delivery
How can I recover my microsoft account email?
Unit 14 IT Service Delivery Part A Question
Zoology at Exeter University Penryn Campus
Kingston University Email
Submitting wrong file format for an exam --- penalties?
Graduates of LSE, do you still have access to microsoft word and/or the economist/FT?
DWP EO Work Coach Training
Which ACCA Distance Learning provider is the best at the moment
Can't reply to a thread
Laptop
Free excel/microsoft courses
Health and social care Level 3 is stressing me out.
Microsoft apprenticeship 2024
MSc dissertations
Laptop and software
[Request] Need Assistance Accessing an IbisWorld Report for University Project
Unit 2 creating systems to manage information
student finance issue message
Trouble getting access to Aula

Microsoft Access Report

Foulish

Edit: Don't worry, I looked at the lecture notes and realised I had to create a query first :rolleyes:

I'm creating a database for a DVD rental shop and I need to create a report.

I need to create a report which shows overdue items. How on earth do I do this?

When I create the form I can make it show all the information, but not a selection of the information :frown:

So how on earth do I create a report which only shows the overdue items?

Reply 1

Stonebridge

Create a query that selects the overdue items.
Create a report using this query.

Reply 2

Reue

Create a query which queries if the 'Return by date' is < current date. Then create a report from that query. Easy stuff.

Related discussions

It service delivery
How can I recover my microsoft account email?
Unit 14 IT Service Delivery Part A Question
Zoology at Exeter University Penryn Campus
Kingston University Email
Submitting wrong file format for an exam --- penalties?
Graduates of LSE, do you still have access to microsoft word and/or the economist/FT?
DWP EO Work Coach Training
Which ACCA Distance Learning provider is the best at the moment
Can't reply to a thread
Laptop
Free excel/microsoft courses
Health and social care Level 3 is stressing me out.
Microsoft apprenticeship 2024
MSc dissertations
Laptop and software
[Request] Need Assistance Accessing an IbisWorld Report for University Project
Unit 2 creating systems to manage information
student finance issue message
Trouble getting access to Aula