How to turn an Access form-based report into a table-based report

D

drewship

Hello all,
I have a very challenging problem I hope someone can help with.

I am going to convert our current non-standard database over to a standard
one using the Order Management Database from the Microsoft site.

The first change is I added a button under tasks to open the OrderDetails1
report. The second change is I included a copy of the OrderDetails1 report
which is a static document to mimic our current database report and this is
the sticking point for the conversion.

Basically, we have a report which has been manually drawn and saved in our
database with only certain information being dynamic. Those dynamic fields
are tied to a control source on the 'Add an Order and Details' form (I know
this is not the correct way but that is why I am trying to convert the
database). This allows us to print a report of the items selected on the
form.

I need to be able to use the same static report but retrieve the data from a
table instead of the form. Is this possible? Is there a way to change our
static report into a dynamic report created on the fly like what is normally
done? Any help is greatly appreciated.

Thanks,
Andrew
 

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

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Cross Tab Report Vs Dynamic coulmns 0
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Converting GPS coordinates to decimal in Report 0
Report printing multiple pages based on query 2
Insert Index into a Table 1
Can I save a sql statement generated by a search form? 1

Top