Search results

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.

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

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

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...

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

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

Numeric for sure

I also tried [WW Price] <> """ but no luck with that either

Thanks again! I thought of that one, tried it and no luck as well.

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...

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...

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()...

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...

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...

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...

Can you offer an example of "changing the record source"

Thanks Gents. I've looked at the Allen Brown example but I can't determine if it really addresses my need. It's using multiple boxes to filter. What I'm trying to so is set an "Account Name" filter so the form shows all records for Account "A". Once Account "A's" records are showing, I want...

My database is a large dataset that contains RFQ data for my part numbers from multiple customers for multiple years. I have a form (with subforms) that displays one record at a time and subtotals calculations in the header (like total value of the RFQ). I would like to apply a drop down combo...

I found another error which I didn't expect. Sometimes, some of the fields I'm using for my Task may be blank (maybe nothing in the body). It seems if there is a blank field, MS Access is returning an error. For example in the below, if WBStatus has nothing, I get the error- Run-time error...

The_Doc_Man- I did as you suggested and found the Microsoft Outlook nn.n Object Library and checked it. Is there anything else I should add to my code? Should I add the Option Explicit in my declaration area too?