Search results

In my database I have tblStations and tblProcesses. The Primary Key for tblStations is StationID. Every Station has many Processes. However, there are two fields that link tblProcesses to tblStations. CurrentID and ProposedID. For example. I could have a form which displayed Station 1 with...

You are quite correct Bob that getting these prompts tells you that something is wrong or at the very least not ideal. When I tested this problem a few times, I thought that the only way to have my footer equations work would be to have my query set up so that the query would not draw from...

Thanks guys, that did the trick. :) I appreciate it, Bill

Well, Bob I want to thank you very much. I had actually tried that interim query approach, but I put all my equations within the subquery whereas you left out OptionMixDSTSum: [OptionMix]*[SumofDSTTime] and OptionMixStdSum: [OptionMix]*[SumofElementTime] from the subquery. Once again, wish I...

BaseSum: DSum("ElementTime","tblElements","OptionID = BASE") I'm getting an Error from Access when I thought I was inputting information in correctly as per the help file on DSUM. I want to Sum up all the records of the ElementTime field from the Table tblElements, when those Records' OptionID...

As I said on the other forum: To get to where I'm talking about: On frmWelcome Form, click the Combo Box below the Command Button "View LS and RS Stations Together" and choose Station 1, 2, or 3. On the Database that's called Double Click, just press Ok several times, don't type anything...

This is a repost of a question at http://www.mrexcel.com/forum/showthread.php?t=381639 I'm adding an attachment of my current database attempts for the benefit of Bob Larson trying to help me (my sincere thanks Bob :D) Any help is appreciated. Sincerely, Bill

Thanks for the reply Alc, The Process Names will not always be the same, or start with the same 4 words, but thanks for the attempt. Let me show you a little bit more, and perhaps you can understand my dilemma. In the Design view, as you can see, there is only 1 field for SumOfElementTime...

Thanks for the reply Alc, My problem isn't the syntax in this case. It's that my usual way of thinking of working with queries won't work with DSUM. In a normal query option, tblElements, and tblProcesses would be connected. And when my query asked to total up ElementTime, then ElementTime...

I've been trying to change my form to be based off of a query that uses DSum rather than Sum. There are 2 tables, tblProcesses and tblElements. Each Process has many Elements. However, I'm confused on how to reference DSUM to get the same results that I did with using Totals and Sum...

Wazz and pbaldy thanks a lot for responding. Your solution worked great. My knowledge has increased. :D Sincerely, Bill

I have 2 tables, tblProcesses and tblElements. Each Process has many Elements. I want to add a new Record to tblProcesses, and then add a new Record to tblElements that belongs to the new Record I just added to tblProcesses. Here is my code. I used Do.Cmd to go to the record I just created...