dlookup based on two criteria

I have a database with multple projects. Each month each project status is
updated.

I have a project report that I want to have display the 'Percent Complete'
for each month for each project. Imagine a row of month names sitting above
a row of %%s.

For data entry, rather than have a field for each month's % complete, I have
an update table where both the reporting month and the % complete are stored.
For example, in October, the user will select 'October' in the month field
and enter whatever percent complete the project is in the 'Percent Complete'
field.


For my report, I need to have 12 fields (one for each month) that will each
populate with the particular project's percent complete as reported for that
month. I believe this requires the field in the report to be based upon a
lookup based on two criteria. Is this possible or another method available?



--
QWERTY

I think you could use a crosstab query or multiple column subreport. It would
have been helpfull if you had provided some sample records with real table
and field names and the format you wanted to display in your report.

--
Duane Hookom
Microsoft Access MVP


"John" wrote:

> I have a database with multple projects. Each month each project status is
> updated.
>
> I have a project report that I want to have display the 'Percent Complete'
> for each month for each project. Imagine a row of month names sitting above
> a row of %%s.
>
> For data entry, rather than have a field for each month's % complete, I have
> an update table where both the reporting month and the % complete are stored.
> For example, in October, the user will select 'October' in the month field
> and enter whatever percent complete the project is in the 'Percent Complete'
> field.
>
>
> For my report, I need to have 12 fields (one for each month) that will each
> populate with the particular project's percent complete as reported for that
> month. I believe this requires the field in the report to be based upon a
> lookup based on two criteria. Is this possible or another method available?
>
>
>
> --
> QWERTY