By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Printing only the last....

P: n/a
Hey

I have a lil problem.

I have a db to follow material break. I have a button to print a
selected ID, (i can enter the ID of the one i want to print), but my
problem is that it prints every break (report) of the selected ID.
exemple:

ID 123
Broke: 1 april (more info...like date)
.......
Id 123
Broke: 5 april (more info...same here)
Now, when i print it prints 2 page (1 for the 1 april and another 1 for
the 5 april.) BUT i only want to print the most recent 1

how do i do this, do i have to add a condition when i select which ID i
want to print?

thx for looking.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Based on the way you limited you report by ID, I would also limit it by
date.
Pachydermitis

Nov 13 '05 #2

P: n/a
On 8 Apr 2005 06:50:33 -0700, "No***********@hotmail.com"
<ug********@hotmail.com> wrote:

Base your report on a Totals query:
select ID, Max(Broke)
from MyTable
group by ID

-Tom.

Hey

I have a lil problem.

I have a db to follow material break. I have a button to print a
selected ID, (i can enter the ID of the one i want to print), but my
problem is that it prints every break (report) of the selected ID.
exemple:

ID 123
Broke: 1 april (more info...like date)
......
Id 123
Broke: 5 april (more info...same here)
Now, when i print it prints 2 page (1 for the 1 april and another 1 for
the 5 april.) BUT i only want to print the most recent 1

how do i do this, do i have to add a condition when i select which ID i
want to print?

thx for looking.


Nov 13 '05 #3

P: n/a
i just added a criteria for the user to enter the date. its fine. thx
for your help.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.