need access to second table value in report 1

[ProgramError]

Hello peeps

Stavros here ... only joking

I have a report based on a query created using the wizard and a little manipulation from myself. The query is based on one table and shows the correct number for a sum I did. I now need to subtract a value which is based in a totally different table from this sum created on the report. Any one know the correct syntax. I've tried the following...

=([NoProgs]-([notapes]))

=([noprogs]-([tblrecharges]![notapes]))

=([noprogs]-([tblrecharges].[notapes]))

noprogs is the calculated sum, tblrecharges is the other table and notape is the field I need the value from in the other table.

Thanks in advance.



Program Error
Programmers do it one finger at a time!

 

[Remou]

Hi
How about:
[tt][noprogs]-Dlookup("notapes","tblrecharges","SomeCriteria")[/tt]

 

[ProgramError]

Thank you. That works fine.

Ian M
p.s I gave u a star.


Program Error
Programmers do it one finger at a time!

 

[Remou]

Good. Thanks very much for the star.