Recent content by eschrob
-
E
DSUM Criteria to exclude a null field
Yep, I had other filters in my working database that I wasn't accounting for in Dsum. I think I'm set. I have a lot to learn and continue to look for tutorials on line. Thanks for your suggestions. Using Nz was a big help. -
E
DSUM Criteria to exclude a null field
I actually think I got it. I had other filters in my working database that were confusing the results I expected. I think using the Nz function in my query is the way to go -
E
DSUM Criteria to exclude a null field
I even now updated my query to use Nz function to make sure WW Price has either 0 or a price >0. But the Dsum still isn't giving me the result I need! Arghhhh -
E
DSUM Criteria to exclude a null field
Here is a stripped down version of the database. I know my control names are not appropriate- I'll fix that eventually. In the Detail section of the form, there are controls based on the query that provide the data such as a) WW Price b) BidNeg (price) c) Extended WW Price (which is WW Price... -
E
DSUM Criteria to exclude a null field
Appreciate the assistance. I need to strip away the sensitive info in the database which will take some time. I will upload eventually. thanks again -
E
DSUM Criteria to exclude a null field
That is great in That is great input- i've used $ in some of my names. I will fix that. I'll look at cdbl or cLng, thanks -
E
DSUM Criteria to exclude a null field
I also tried [WW Price] <> """ but no luck with that either -
E
DSUM Criteria to exclude a null field
Thanks again! I thought of that one, tried it and no luck as well. -
E
DSUM Criteria to exclude a null field
Thanks for the input. I set up my database as a beginner and have learned a ton. My table/query/control names were not set up properly when I started. I've taken an online class and learned of the proper way for naming. So far, things are working fine and I've been able to "get away with these... -
E
DSUM Criteria to exclude a null field
I am trying to use a DSUM function in a form that I've got working with a few critieria. But I want to add one more criteria (with an 'And' function) for a field that usually contains a price (Currency) but may contain nothing (null). I want the DSUM to exclude the Null. My function that... -
E
Applying one 'global filter' on a form that remains while I apply other filters
Arnelgp- I'm trying to adopt your code suggestion. Again, I'm a novice. Seems like you're defining a subroutine called "fncFilter" which is invoked when either (AccounSelect or RFQYear) combo box is updated. When I apply =fncFilter() to the Event I get Private Sub AcctSelect_AfterUpdate()... -
E
Applying one 'global filter' on a form that remains while I apply other filters
Isladogs, Thanks for the examples. Since I'm a novice on VBA it will take me some time to interpret your example and apply it to my database. It seems promising. I will be playing with it over the next few weeks as I have time. And will report my results. Thanks again to you and all for the... -
E
Applying one 'global filter' on a form that remains while I apply other filters
arnelgp- Thanks So, first I select the account name in the AccountSelect combo box drop down. Then I type a part number in the PNSearch box and hit enter. The code below filters the records on the Account name in the AccountSelect combo box and then filters on the PN in the PNSearch box. Do... -
E
Applying one 'global filter' on a form that remains while I apply other filters
June7- I want to be able to select a dropdown to pick the account I want to work on. Once set, I want to do a bunch of filtering and sorting on the records associated with that account. (Ideally I'd like to also select the 'RFQ year" too, but I'm happy to start slowly. Example, pick Account A...