how do i creat a report from Form

V

var

Hi

i have a Form with 2 commands ok and cancel, when i say ok it runs my
query and display the results. The query is a crosstab query. When i
tried to create a report to give a better look by using wizard the
'Available Fields' the left hand box (when selected the query), where
usually you can pick some of the output headings to be diplayed in the
report.....is showing nothing, it is just empty...

why the 'Available Fields' shown empty, when the query runs and gives
the output

how can i create a report with desired presentation

is there anything wrong in my working procedure or something else

i am very new to Access, pls give me your valuable suggestions

thank you

var
 
B

BoniM

I think your subject line is telling us the problem. You want to create the
report from the query the button runs, not the form that has the button. I
think this is why you are seeing no fields.
Good luck!
 
V

var

Hi BoniM

thanks for reply.
yes, you are right

so how i can go further to generate a desired report........is there
any possibility for me to accomplish this or do i need to change the
current procedure

var
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top