S
Sammy
Hi, I have a database (called Change control) which records changes that need
to made to a system. I have a main form with about 5 subforms within it. What
I am trying to is the following:
I have a CC form with fields:
Request ID
Requestors Name
Requestors Dept
RO Contact
ICT Contact
Date of Request
Brief Description
Reason
Deadline date
change type
Priority
Downtime required?
Downtime date
One of the subforms within the main form is:
Stage of Request, which has the following fields:
ID (linked to Request ID in CC form)
Stage (this is a drop down)
Date
On this subform it lists each stage for one record (there could be 5
statuses for one CC record) I am trying to create a query that returns the
latest stage (eg: if there are 5 different stages with 5 different date, with
'Completed' as the last date (31/07/07), the query should only return this
stage for the related request)
Please can someone help
to made to a system. I have a main form with about 5 subforms within it. What
I am trying to is the following:
I have a CC form with fields:
Request ID
Requestors Name
Requestors Dept
RO Contact
ICT Contact
Date of Request
Brief Description
Reason
Deadline date
change type
Priority
Downtime required?
Downtime date
One of the subforms within the main form is:
Stage of Request, which has the following fields:
ID (linked to Request ID in CC form)
Stage (this is a drop down)
Date
On this subform it lists each stage for one record (there could be 5
statuses for one CC record) I am trying to create a query that returns the
latest stage (eg: if there are 5 different stages with 5 different date, with
'Completed' as the last date (31/07/07), the query should only return this
stage for the related request)
Please can someone help