Getting fields filled from query

[HVtech]

Hi I have a fine working query. Now I want to set the results to some fields on a report based on another field on the same report.
I not getting it right, who can help me out here?
Thanks in advance..

 Dim StrSQL As String

StrSQL = "SELECT DISTINCT registratie.periode, " & _
"periode.Periode_startdatum, periode.Periode_einddatum " & _
"FROM periode INNER JOIN registratie ON periode.Periode_naam = registratie.periode " & _
"WHERE (((registratie.periode)=[Rapporten]![Rpt_Tot_Project_uren]![periode]))"

DoCmd.RunSQL StrSQL

Me!Pstartdatum = Periode_startdatum
Me!Peinddatum = Perode_einddatum

Me!eindweek = DatePart("ww", [Periode_einddatum], 2, 2)
Me!Week = DatePart("ww", [Periode_startdatum], 2, 2)

 

[dhookom]

I think you need to start at the beginning. The RunSQL will have no value since it's a basic select query. There is a difference between fields which are basically columns from your data source and controls which display values from fields and expressions.

Is there a report created?
Does it have a record source?


Duane
Hook'D on Access
MS Access MVP

 

[dhookom]

I should have also added that this question might have a better chance of being answered in the Microsoft: Access Reports forum.

Duane
Hook'D on Access
MS Access MVP

 

[HVtech]

Hm oke.. thanks for your answers.
I will start over I think..