reports in Access

mahsa

New Member
Joined
Jan 10, 2019
Messages
5
Hello everyone!
I need to get a report from an Access file. The report must contain attendance days in a week that can be one or two. For example, Mr. A comes on Saturday and Thursday, and Mr. B comes on Monday and Thursday. I want the report to show me who comes when and how many people are working in that day.
At first, I tried using a multi-valued combo box but access didn't accept it. Then I deleted the multi-valued field and inserted two single-valued fields to get the two days separately. I want the report to show me a merged data of the two fields but I am new to access and I don't know how. I'd appreciate it so much if you help me with this.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,672
Office Version
  1. 2016
Platform
  1. Windows
You should set this up as a query in Access, you can set your parameters from there and if required create a report from the query.
 

mahsa

New Member
Joined
Jan 10, 2019
Messages
5
Thank you very much for your reply.
As I'm new to access, I don't know how to build such a query; would you mind helping me with the query?
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
842
You are going about this the wrong way.
You should have a table that would hold

ID Autonumber
PersonID or Name Number or Text
AttendDate Date

Then you have one record for each day attended, and can allow for more than two should that happen.

Then the report wizard can create the report for you very easily.
 

mahsa

New Member
Joined
Jan 10, 2019
Messages
5
I did it at first, but the report wizard didn't allow multi-valued record. As a result, I separated the two records but I need the report to treat them like they are just one record but I don't know how.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,518
Office Version
  1. 365
Platform
  1. Windows
I did it at first, but the report wizard didn't allow multi-valued record.
You shouldn't need multi-valued records, and I don't think anyone is recommending that you use one.
Actually, you should NOT use them, as they are problematic. I do not see any need to use one anyway.

Following the strucutre Welshgasman proposed to you, if a person came in on two spearate days, there would be two records in your table, one for each day for that person.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,545
Messages
5,529,458
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top