Question about Reports and choosing the records to be printed on it

[dirka]

ok, so I've hit the wall on my knowledge for VBA so I hope I can get some help here. Basically what I have right now is a table of request for funds for my dept. Those requests are then put into a report (5 items per report) and then printed. So all i could figure out was how to retrieve the last 5 entries into the table to the report, but sometimes I need to select random entrees to print. So then i created a couple checkboxes to try and keep track if something was printed...and now my report will display the 5 most recent transactions that have the Print chkBox set to True. So basically what i would like to do is enter my transactions in my form, ( i usually enter 3-5 per time) and then go directly to my report, print those 3-5 trans. and then after they are printed, have the chkBox for Print selected so they won't be displayed in the next report. Sorry if this isn't a good explanation, I'm very new to the DB world. also, im using access 2007 if that matters.

[nico5038]

Instead of a yesno field I would use a numeric field with a runnumber.
Just create a query to update max five records with:

UPDATE tblRequest a SET a.RunNumber =dmax("RunNumber","tblRequest")+1 where A.RequestID IN (Select top 5 b.RequestID from tblRequest b where IsNull(b.RunNumber) order by b.requestid)

Now for the report use a query like:

select * from tblRequest where RunNumber = dmax("RunNumber","tblRequest")

Getting the idea ?

Nic;o)

[dirka]

Instead of a yesno field I would use a numeric field with a runnumber.
Just create a query to update max five records with:

UPDATE tblRequest a SET a.RunNumber =dmax("RunNumber","tblRequest")+1 where A.RequestID IN (Select top 5 b.RequestID from tblRequest b where IsNull(b.RunNumber) order by b.requestid)

Now for the report use a query like:

select * from tblRequest where RunNumber = dmax("RunNumber","tblRequest")

Getting the idea ?

Nic;o)

Getting the idea?? good one, lol

i am really just learning this stuff so I need a little more help..here is a little more info and maybe you could clarify for me.
I have a table "requisitions" a query "requisition report query" and a report "requisition report"

Here is what i have for the query right now:

SELECT TOP 6 Requisitions.ID, Requisitions.Quantity, Requisitions.Title, Requisitions.Vendor, Requisitions.[Cost/Unit], Requisitions.Date, Requisitions.[Real Cost], Requisitions.RechNum, Requisitions.ReportID, Requisitions.Description, Requisitions.Print
FROM Requisitions
WHERE (((Requisitions.Print)=-1))
ORDER BY Requisitions.ID DESC;
 

Since I can't explain worth a damn, here are some pics of what I have so far...
http://img444.imageshack.us/img444/817/tblreqhd3.jpg
http://img213.imageshack.us/img213/2...reqinfooh9.jpg
http://img154.imageshack.us/img154/5246/qryreqnv4.jpg
http://img379.imageshack.us/img379/7650/repreqfr7.jpg

I hope these help, like i said, i just want to add new items, print them, and then not have them show up again in the report again when i add the next items. I really want to learn this stuff so i hope you can explain this in very lamen's terms...

thanks

[nico5038]

Start with changing the datatype of the Printed field into a number.
Next open a new query, ignore the table popup form and switch to SQL view.
There copy/paste:

UPDATE Requisitions a SET a.Printed =NZ(dmax("Printed","Requisitions"))+1 where A.ID IN (Select top 6 b.ID from Requisitions b where IsNull(b.Printed) order by b.ID)

Save the query named qryUpdate6 and to be sure copy/paste your table to have a backup, than try the query by running it to see the effect.

Finally use a query like the one proposed to select only the MAX Printed value.

Nic;o)