User filled field in report

[gcomp]

I have created a report that will act as a purchase order. I want to have a field that will act as a point to put a reference number. This number does not need to be stored anywhere.

One criteria for the query that the report is based on is vendor name. When you run thew query or report, it asks for vendor name. I would also like it to ask for reference number. The only place this will appear is on the report. Again, it doesn't need to be stored for later use. Any ideas or words of wisdom?

 

[HiTechCoach]

I have created a report that will act as a purchase order. I want to have a field that will act as a point to put a reference number. This number does not need to be stored anywhere.

One criteria for the query that the report is based on is vendor name. When you run thew query or report, it asks for vendor name. I would also like it to ask for reference number. The only place this will appear is on the report. Again, it doesn't need to be stored for later use. Any ideas or words of wisdom?

You can have it ask for the reference number in the query using a parameter similar to the way you ask for Vendor.

You could create a new column:

RefNUm: [Enter Reference Number]

Note: I find it better to use a form to collect the criteria for the report. This would allow you to use a combo box to select the vendor

Examples: Report Dialog Examples