Hi there, i'm going to try and explain this as best i can, but please forgive me if it sounds more complex than it is:
I have a database which is used for a project im working on, basically it keeps a record of issues with a system, and users needing trained for the system - and also the progress of the rollout of the system.
My database has a table:
tbl_locations
And any other table or query, that requires a location uses this table - mostly in look up format.
I have a training record in my database, which stores staff details, training requirements - and most importantly for my problem the location.
I also have a progress report for the project, this runs from a table called:
tbl_progress
Within this table, I have a record of all sites which are complete - so, say for example, all staff at "location 1" have been logged on, the site is cimplete - so i enter a record into this table, and mark the status as complete - this then shows up in my "rprt_progress_complete" report, which runs of a query.
But, within this report, i would like to include the number of staff at each location - so basically, i need to somehow, from my query that shows the complete locations, count the number of records in my "tble_training" table, filtered by location. But i am clueless as ot how to do this, and not the most advanced access user
E.g. - location 1 is complete, but how many records are there in my "tble_training" with "location 1" set as the location.
Any idea's anyone??
many thanks, and sorry for the speil.
Neil
I have a database which is used for a project im working on, basically it keeps a record of issues with a system, and users needing trained for the system - and also the progress of the rollout of the system.
My database has a table:
tbl_locations
And any other table or query, that requires a location uses this table - mostly in look up format.
I have a training record in my database, which stores staff details, training requirements - and most importantly for my problem the location.
I also have a progress report for the project, this runs from a table called:
tbl_progress
Within this table, I have a record of all sites which are complete - so, say for example, all staff at "location 1" have been logged on, the site is cimplete - so i enter a record into this table, and mark the status as complete - this then shows up in my "rprt_progress_complete" report, which runs of a query.
But, within this report, i would like to include the number of staff at each location - so basically, i need to somehow, from my query that shows the complete locations, count the number of records in my "tble_training" table, filtered by location. But i am clueless as ot how to do this, and not the most advanced access user
E.g. - location 1 is complete, but how many records are there in my "tble_training" with "location 1" set as the location.
Any idea's anyone??
many thanks, and sorry for the speil.
Neil