Getting the info out (1 Viewer)

[DavidRS]

I originally posted this in the reports section following an earlier post. This section may be better:

Thanks guys,

I'm getting really frustrated - I want to produce a report of files associated with an individual. The name should be picked from a list and a sub-form would list all the files. A report would then be produced based on the results.

The tables I have got so far are:

tblGroup

GroupID
Group

tblStaff
UserID
FullName
Group
Unit

tblUnit
UnitID
Unit

tblUsersFiles
FileID
UserID
FileName
NA_Files
FullName (this is name of staff member)
SizeUsedMB
Modified

The report needs to contain the following the detail:

Staff Name
Group
Unit
The list of files
Total Mb used

I have no experience using coding and although i can see what the examples are doing, I can't replicate them on my db. Given that I don't understand the code I cant see where I'm going wrong and I have a load of information which i can't report on. I am going mad and spending all my time trying to do this. I'm trying to learn but can't get my head round it.

Can anyone help me - pleeeease

Cheers

David