Lisa has attended:
Excel VBA Intro Intermediate course
Report - query in access
if you have to produce a report. all of the data is many to one.
One "project" has many "stage dates" - how would you do a report to show what "stage" is due weekly per "project"?
RE: report - query in access
Hi Lisa
Thank you for your question
Can you clarify the table structure for me. Do you have a stage date table that lists the stage dates for each project, and is this table then linked to the main projects table.
If this is not the structure, could you describe it for me
Thanks
Stephen
RE: report - query in access
Hi Stephen,
I have, for Example,
a project table - - one item
a programme table - many dates
Each item has many programme dates for each stage - eg
stage 1 - accpeted date, revised date and achieved date
stage 2-8 as above.
What I would like to do is run a report so that it shows say in Stage 1 all of the projects which are due between X and Y dates. But only to show the projects which are due nothing else.
Would i have to do this per stage as there are 3 dates which will need to be shown? How do I do this in general really.
Many Thanks
RE: report - query in access
Hi Lisa
Thanks for the clarification
You could try building your query with the three date fields included, and then entering the parameter for each date on a different row. The syntax for the parameter would be :
BETWEEN [Enter First date] AND [Enter second date]
The only problem would be that you would have to enter the start and end date three times when the query runs; once for each date. This could be tedious.
It is possible to solve the problem by writing a VBA procedure which would simply prompt for the start and end date and then would embed the variables into the sql statement. We actually carry out just such an exercise on the Access VBA course. It is however too invloved to be detailed here.
Hope this is useful
Regards
Stephen
