reports in Access

[mahsa]

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.

 

[Trevor G]

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]

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]

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]

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]

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.