Report or query FOR

[fnofal]

Can anybody help me with this.
I need a report, but not with this data.
That was a sample data that i receive when i preview a report.
TableA TableB TableA TableA TableA
Id Id NumProyect NameReference TechName
5 5 ODN-04-024 RULLAN JOHNNY fnofal
5 5 ODN-04-024 LUKAS JORGE fnofal

Total NumProyect for ODN-04-024 (2)

6 6 ODN-04-025 VERTRAN MICHAEL fnofal
6 6 ODN-04-025 NATAL DIEGO fnofal
6 6 ODN-04-025 RULLAN JOHNNY V fnofal

Total NumProyect for ODN-04-025 (3)
Total TechName Work With (5)

I need receive from the Id#5 and the NumProyect ODN-04-024 the total of (1) and in the Total TechName Work With (1)

 

[ptpaton]

I'm not really understanding your question...can you rephrase what's going into the query and what you need to get out of it? That might help...



-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[fnofal]

ptpaton
Thanks for tryin help me...
Ok my que question was... I need to receive a sum of the NumProyect but..if you see....it have a several items for thesame num; because I use a sub-form Table-A atach to the form Table-B.

 

[tgr430]

Are you trying to sort the fields?

 

[fnofal]

No tgr430...
Im tray to take a report when I view something like this
with the example data in the up of this question.

Technical Name:
fnofal

TableA TableB TableA TableA
Id Id NumProyect NameReference

5 5 ODN-04-024 LUKAS JORGE
-------------------------- RULLAN JOHNNY
6 6 ODN-04-025 VERTRAN MICHAEL fnofal
-------------------------- NATAL DIEGO
-------------------------- RULLAN JOHNNY V
The Technical Name fnofal have (2) projects