Recent content by buecker

Thanks everyone! NZ worked great. Ben

The expression you entered has a function containing the wrong number of arguments." Without the zero at the end it just doesn't do the math. I'm trying to figure it out right now.

Golom's code worked. Unfortunately, this brings up a different issue that I wasn't prepared for. If this part: DateDiff("y",[Fileonhold],[FileReactivate]) is null (which should be most of the time), Access won't assume its a zero and therefore won't do the calculation will it?

Thanks for the quick responses....I have another field that was the datediff for tocredit, submitdate. It stopped working for some reason. I need to figure that what happened with that to test these choices. Ben

I'm currently using the datediff command to find the # of days between two dates...however I want to be able to subtract that from the datediff of two other numbers. Ofcourse, to no avail, I can't seem to get datediff to work with embedded parenthesis? Expr2...

Was it a short at all or did the mobo just die?

Sounds like your jumpers are backwards. Make sure you have your master and slave drives set properly. Your bios won't read anything if your drives have the wrong jumpers.

Don't forget that you can also go into disk management. Rick click "My Computer" and then choose manage. While I do have more than 160 GB on my main drive I would be suprised if you are really using 160 GB of programs. Spare hard drives are quite cheap these days. Just add another one either...

Ah. Okay, that makes sense. Thanks

Can you use the COUNT function with criteria? For Example: I want to count all dates(same field or multiple fields) that are two weeks old. Can't seem to use COUNT if I have something in criteria?

Wow. Thanks for the info. I will try it out tomorrow.

I hate to ask for help but I'm running out of time to research this. I have a report that needs to show records that were entered for the past 14 days grouped by individual. That's the easy part. The sticking part for me is counting each date entered that is within the past 14 days. There...