data in different sections depending on data

[moorsey]

Hi there,

I have been developing a register type system, that stores who was not in attendance on any particular night

I want to put different members under different headings depending on if they were down or not

so if they have an entry in the attendance table for that night and they have a reason as well then they were absent with leave

if they have an entry but no reason then they were asent but not authorised

if they have no entry then they were attending

would this be best done in queries or vba and how can I pass this varied data to different sections on a report?

thanks folks

 

[shudini]

What do you mean by different sections of the report? Are you embedding multiple subreports? If so, just create 3 separate queries. If you are talking about 3 columns, you can build each column in a query using the iif() function. I would be happy to give you an examply, but I need to know what the various applicable field names are.

 

[moorsey]

ahhh, that would make sence, I never even thought of sub-reports, never used them

So I can put data from different queries in different subforms on the same form?

I have created two of the queries I need for that, the last one I'm not so sure how to create, I need the query to show all of the records in one table, that are not listed in another related table, i.e all of the members in tblMembers that do not have an entry in tblAttendance, if that makes sence

Not sure how to reference that in the query builder

thats for that!

 

[shudini]

You can put many subReports on a single report.

As far as unmatching queries, if you are using Access, go to Queries, click on New, and there is a Wizard called Find Unmatched Query. That should help you out.

 

[moorsey]

ahhh that cracked it, makes sence now, thanks very much for your help!!