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

print only some reports?!"

P: n/a
Hi all

I'm currently trying to setup an invoicing system, anyone know how I can
choose to only create+print a report for jobs which are not paid for, this a
number field bascially IF paid=cost then no invoice else print invoice?

I hope I've explained that ok :S
Thanx in Advance
Dan
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Use that as a criteria in the Query that you use as the Reports'
RecordSource.

Larry Linson
Microsoft Access MVP

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:HA*****************@newsfe1-gui.ntli.net...
Hi all

I'm currently trying to setup an invoicing system, anyone know how I can
choose to only create+print a report for jobs which are not paid for, this a number field bascially IF paid=cost then no invoice else print invoice?

I hope I've explained that ok :S
Thanx in Advance
Dan

Nov 13 '05 #2

P: n/a
Dan Kean wrote:
Hi all

I'm currently trying to setup an invoicing system, anyone know how I can choose to only create+print a report for jobs which are not paid for, this a number field bascially IF paid=cost then no invoice else print invoice?
I hope I've explained that ok :S
Thanx in Advance
Dan


How about using:

Report.Filter = "Nz([paid]) < Nz([cost])"

or

Report.RecordSource = "SELECT * FROM tblJobs WHERE Nz([paid]) <
Nz([cost]);"

Why not use a Currency field for these?

You're welxome a posteriori,
James A. Fortune

Nov 13 '05 #3

P: n/a
Thanx!

I wasn't sure if I was on the right path but I am just using queries wrong

Dan

<ji********@compumarc.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Dan Kean wrote:
Hi all

I'm currently trying to setup an invoicing system, anyone know how I

can
choose to only create+print a report for jobs which are not paid for,

this a
number field bascially IF paid=cost then no invoice else print

invoice?

I hope I've explained that ok :S
Thanx in Advance
Dan


How about using:

Report.Filter = "Nz([paid]) < Nz([cost])"

or

Report.RecordSource = "SELECT * FROM tblJobs WHERE Nz([paid]) <
Nz([cost]);"

Why not use a Currency field for these?

You're welxome a posteriori,
James A. Fortune

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.