Search results

Thank you for explaining it clearly. I only had it working because I'd tried putting the NOT everywhere, but I wasn't understanding exactly why the one that worked, did. Now I do :D Thanks.

YAY! The parens wound up like this =IIF([SumCount]>0,(([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount]),0) and then it worked perfectly. Thank you! Jennifer

I have a calculation on my report that sometimes ends up dividing by 0 - and when it does, it comes up with a #Num! error. I tried to Nz it, but it didn't work, any suggestions? =([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount] is my control source. Thank you! Jennifer

Thank you! Of course, that makes sense now........ A great weekend to all! Jennifer

WHERE (Not ((tblIngredient.ItemNumber)="I077") AND (Not(qryFinalAvgCost.LastCost)="0")); This is what I have in the query, and if I take out the "not"s I can isolate the item I want to get out of the query (i'm not deleting it) but with the "not"s in the query doesn't apply the AND! It gets rid...

I checked the SQL and it does say AND - but it still first eliminates the "I077" and then eliminates the items that cost 0.00...............but I only want it to eliminate an item that is I077 AND costs 0.00.......... confused.

Hi! I have a query, and I want to eliminate a record that has an ID of "I077" AND a lastcost of 0. I thought that if you put the criteria on the same line, it would produce and AND result, but it gets rid of ALL records that have an ID of "I077" and then eliminates all records that have a...

Thanks for the congrats ( I LOVE being a Mom!) and thank you for the help! Jennifer

Thank you Jack! I have the front end and back end...........but I need to send them a backend already populated with data....do I do this in two separate installations? One front and one back? And any hints on where I can find the code to link them when I update? Thank you again! Jennifer

Hi all! I'm getting ready to distribute version 1.0 of my application and it has been packaged and deployed ........but I just realized that I don't know how to UPGRADE my users versions when I'm ready with fixes and enhancements! How will I get the new versions to them AND let them keep all of...

After I posted I thought of that too! And sure enough....it's a report that takes around 15 minutes to run. Thanks for thinking of it. Jennifer

It's very big, and complex and runs on dozens of queries and eight subforms. Each individual component runs fine on its own, but when run together they freeze. I've done everything I can think of in the way of simplifying the queries.......any ideas? Thank you! Jennifer

ARGH! Thank you.

Hi! I have an ID field that is user determined, and is a number. When the field is sorted, the numbers come up like this 100 110 1150 1160 120 1300 1310 140 etc. How can I get them to display in true numerical order? Thank you! Jennifer

Thank you Pat!

I don't need to order the existing records - I need the blank record entry line to come up on top of the page, instead of on the bottom.

Hi All, I have a form in continuous forms mode where a user enters information. Currently the new blank record line shows up at the bottom of the form, is there a way for is to show at the top of the continuous forms? Thanks! Jennifer:confused:

oh - and thanks! he's two months old tomorrow :D i'm a proud mama.

Thanks! I think I'll give it a try.......sounds like I can make it work. Jen

Hi Everybody! I have a query that averages some costs, but if the item hasn't come in, the result in query.lastcost will be 0. if it's 0, I need to get the result from another query for that item. How do I do this? ( I have the other query built already) Do I need to give more information...