I need printer recommendations. I'm interested in a laser, but...I'm wondering if the price is prohibitive. I have an oldish compaq all-in-one printer right now and it is okay, but it isn't very quick printing.

I would love a legit copier/printer combo that didn't look too ugly.

Anyway, I looked around the internet for an hour+ and I can't find any good recommendations.

Brother makes good, cheap laser printers. (Assuming you're just interested in B&W).

At this point, that might be the case. I don't print in color enough to justify the extra cost.

I've had the previous generation of this Minolta PagePro [link] for about 18 months and I'm pretty happy with it, particularly considering the price. The paper tray isn't very well designed, but it works.

I have another Access/Filemaker question:

I have students who are paying for a class, sometimes with two payments. I need to calculate, for each student, the total they have paid, and then the total they owe.

This is what I did in Filemaker:

I would create a calculation field which added them together. I could then put this on a report, and it would show me who owed what.

There doesn't seem to be an equivilent of a calculation field in Access, and I am not sure I know the right terminology to use the help.

I tried, in a report putting in a text box that said "= [Payment 1]+[Payment 2] in the details section. It doesn't show up on the report if there is anything entered in either the Payment one or the Payment 2 fields. It shows up as $0 if they haven't paid.

Any clues?

Sophia, calculations in Access are done either in queries, or in controls on forms or reports. For example, if you have two numbers in the table, say [payment1] and [payment2], you would create a control on the report with the control source equal to "=[payment1]+[payment2]".

You could also do the same as a field in a query, and just use the query as your data source for the report.

For example, if you have two numbers in the table, say [payment1] and [payment2], you would create a control on the report with the control source equal to "=[payment1]+[payment2]".

You could also do the same as a field in a query, and just use the query as your data source for the report.

So, I did this, but it just shows as blank, even if there are numbers in Payment 1 and Payment 2. I used the expressions builder, so I doubt I spelled anything wrong. Does it matter that I am adding 2 currency fields?

Shouldn't. At worst, the third control will show a decimal without the dollar sign.

I will say that Access does have a lot of hidden gotchas, and the help files suck, especially in 2000.

Although now that I say that, if you're doing it the calculation in a report control, the references shouldn't be to the fields, but rather to the controls the numbers are in on the report. For example, if you look at the properties of a control, there are both a control source (the field name), and a control name (usually also the field name, but can be different). If they are different, you have to use the control name. Also, if they are the same, the report will often get confused as to what you're referring to, so it's better to change the control name to something other than the field name and use that.

Well, I have learned that the help files suck.

I tried what you suggested, but it still just shows up blank on a report. I REALLy want this to work, because otherwise I will have to type the information twice, once into excel for the accountant and once into the database for the teacher.

I am going to cry now.

But thank you.

For anyone else's information, I sort of figured it out. My problem was that it won't add it if there is nothing entered in BOTH the fields used. So if I put a 0 in the fields used, the expression will add.

It seems like there should be a cleaner way, but....