Print a report of just ONE record

[beckettlaura]

Wondering if it is possible to print a report of just ONE record and not ALL of them??? Thanks in advance!

 

[ColinEssex]

You'll need some criteria in the query that runs the report.

Col

 

[rainman89]

i.e.
report.recordID=me.recordID

It all depends on how you are printing the record off too. Are you doning this from a form?

 

[beckettlaura]

Yes, it's from a form. I'm using access as a database to create work orders. once recorded a record in a form, i want to print that work order out ... not the whole database!!!!

 

[rainman89]

can we see your query?

 

[beckettlaura]

sure...how do i do that?

 

[rainman89]

well there is an SQL view of the query that you can copy from. go to design of the query and then chose view>sql view

do you have a record number that is unique for each record and does your query contain that record identifier?

 

[beckettlaura]

SELECT DATA.DateReceived, DATA.Customer, DATA.Manufacturer, DATA.Description, DATA.GeneralInformation, DATA.[WorkOrder#], DATA.[OrmacExistingStamp#], DATA.DateLookedAt, DATA.DateFinished, DATA.DateApproved, DATA.[Tech'sIntials], DATA.[CustomerPO#], DATA.[PackingSlip#], DATA.[CustomerStamp#]
FROM DATA;




Yes, I there is a unique # for each record. Right now it's using autonumber but i have a specific # i want to start at not at 1. I still have to figure that one out!!

 

[rainman89]

You should use Autonumber for it since that makes each one unique. Its meaningless usually, and its used for searching mostly. you can create another feild to create your numbering that you want. if you need it to mean something.

what one is the unique identifies that you want to print based on? is it workorder#?

 

[beckettlaura]

yes, it's workorder#

 

[rainman89]

SELECT DATA.DateReceived, DATA.Customer, DATA.Manufacturer, DATA.Description, DATA.GeneralInformation, DATA.[WorkOrder#], DATA.[OrmacExistingStamp#], DATA.DateLookedAt, DATA.DateFinished, DATA.DateApproved, DATA.[Tech'sIntials], DATA.[CustomerPO#], DATA.[PackingSlip#], DATA.[CustomerStamp#]
FROM DATA WHERE (DATA.WorkOrderID = Me.WorkOrderID);

Me.WorkorderID could also be changed to forms!formname.workorderID <- changing formname to your form name and workorderid to your workorderid field

 

[Rich]

The problem with using the Query criteria method is that you can't then use the Query for anything else

 

[awagent]

Need to print just one report

well the problem is this:
i created a mask to do a certain kind of document (using a submask too)
i created a report
i put a key to print the report (just the one with the right id and date)
what i get are several copies of the report (the number of copies is the same of the number of items in the submask)
But i need to have JUST ONE document printed
What should i do?
Where did i do wrong?