dynamic report

[bluesurfer]

how can i create a dynamic report
that looks like this

field1 | field2 | field3 | date1 | date2 | date3----->

 

[HiTechCoach]

There really is not enough information about this to help you.

In what was is this a dynamic report?
Are you using a Crosstab query?

What issues are you having on get the data onto a single row?

 

[bluesurfer]

tnx HiTechCoach....and sorry my reply is late


im using a crosstab query

***criteria from a form
begin date:3/1/2009
end date:3/31/2009

outlet---name----address----3/1/2009---3/2/2009----->

001-----xxx-----yyyyyy--------NB--------OS
002-----xxxx----yyyyyy--------NV--------OF
003-----xxxxx---yyyyyy--------SP--------NB

*nb,nv,os,of,sp are all remarks

my problem is how can i create a (dynamic)report base on crosstab query with a criteria from a form

 

[jdraw]

tnx HiTechCoach....and sorry my reply is late


im using a crosstab query

***criteria from a form
begin date:3/1/2009
end date:3/31/2009

outlet---name----address----3/1/2009---3/2/2009----->

001-----xxx-----yyyyyy--------NB--------OS
002-----xxxx----yyyyyy--------NV--------OF
003-----xxxxx---yyyyyy--------SP--------NB

*nb,nv,os,of,sp are all remarks

my problem is how can i create a (dynamic)report base on crosstab query with a criteria from a form

You may get some ideas here.
http://www.fontstuff.com/siteindex.htm#access