Recent content by rogers5293

I have a problem I can't figure out. The users want to enter in multiple invoice numbers and then have that record set returned and be able to enter in deposti information on each of those invoice records via a datasheet view. How do I go about processing taking multiple field values and then...

I GOT IT WORKING!!!! Yeah! Thanks SOOOO much! (From the last post I realized I had a table name mispelled in the calculation. Thanks again for responding so fast!

Thanks so much for taking the time to reply! It is really appreciated!! I tired the IIF (duh!) on a simple expression and that worked but I am still having problems with the complicated one: cASADistFee...

I have several calculated fields in a query that work fine. I have two that have conditions on them and was wondering if you CAN'T have IF statements in a calculated field query. If not, how do I do this? I have two tables. One is a product table and one is a rates table. If the calcuated...