Form to Report

[psyduck1085]

Hi All,

I have some issues on ms access report.

Example: I have a query that give me result A:1234 B:2345, so what i want is to divide the two data into two seperate report which same format (letter).

or

Example: from Form, i print a report (based on my template). And I'm using below VBA.

Dim strReportName As String
Dim strCriteria As String
strReportName = "Query1"
DoCmd.OpenReport "Query1", , , _
strCriteria = "[Counterparty]='" & Me![Counterparty] & "'"

but issues here is my report is nothing but blank!!!

Any solution???

 

[Thisismyprofile]

Can you post your query 1? And how does the program know strCriteria is associated with Query 1?

Have you tried building the query first to get the results you are looking for?

 

[psyduck1085]

Hi,

Yes... I did, from my query.. I transfer it to FORM and I need a report on it.

this is my query

X-1: Conc("T24 Reference","Counterparty",[Counterparty],"XX4-Testing")