Search results

Thank you. Let me take a look at this and I'll get back to you. It may be a day or two. I really appreciate this.

Not at all. Whatever is going to get me to my goal.

That is correct. If I hit the Next button, it should take me to the AECI203-Clntn161-Clinton, and so forth. A Back button would be nice but I didn't want to complicate matters too much.

CJ_London - For some reason I am unable to see your reply in this thread. Do you think you can repost?

Here is a stripped down version of the database. The form to get everthing started is frmEnterParameters. I do so much appreciate the help!

I figured out how to do it. I had to do another query where i did just the Min function the matched that query to my original query to get what I needed. I just couldn't do it all in one query like i was trying to do.

Yes I am saying, when I click the button I want to display the next set of data. Which with the code you gave me takes me to the next record, record #2. Thats not what I want. I want a completely new set of data based on the field "Checkout Order". It's going to take a requery of the data to...

I have provided additional details in the attached file. Please let me know what else is needed.

Well I'm certain I'm going about it the wrong way. All I want to do is get to the one minimum value in the Checkout Order field (which in this case would be a 1, there are other cases where it would be something like a 17). If are multiple low values, pick the first one. See attachment to see...

I have searched high and low and I can't for the life of me figure out how to find the Minimum value of a column. This is my SQL: SELECT * FROM tblFinalMaster WHERE (((tblFinalMaster.OperatingDay)=[forms]![frmEnterParameters]![Combo13]) AND ((tblFinalMaster.[Checkout...

I have a form that I want to auto populate with some data based on a query. First off a form pull 4 pieces of data from a master table and passes them to a query which then auto populates another form that shows a lot more of the information from the master table in a more user friendly way...

Thank you, thank you, thank you! This solved my problem!

This is what the table that feeds my form looks like (attached). As you can see, I expect the On Peak total to equal 1271 (based on null values in the OffPeakDay and OffPeakHour columns). I expect the Off Peak total to equal 318 (based on the non null values in the OffPeakDay and OffPeakHour...

The Sum field is in the footer. The table that feeds this has 24 rows each time based on some previous data entry/selection criteria. It has hours 1-24. The OffPeakDay may or may not be populated based on what day of the week it is. The OffPeakHour may or may not be populated based on what...

That didn't work either, only this time, I didn't get any kind of error message. When I entered that into the Control Source for the field on the form, it just goes away.

It didn't accept that. When I built it through the Expression Builder, it says the expression you entered has a function containing the wrong number of arguments. I entered exactly what you had =Sum(IsNull([OffPeakDay]) And IsNull([OffPeakHour]), [Import]-[Export],0)

What is wrong with this query? =IIf(IsNull([OffPeakDay],IIf(IsNull([OffPeakHour],Sum([Import]-[Export]),0))) What I want is to sum the field (Import minus Export which are numeric) on the form if the OffPeakDay AND OffPeakHour fields are null.

I have a report that I want to add some hand keyed data to. When I run the report, I want it to prompt me to "Enter Something". After I enter that information, I want that information to show in my report header. I feel like I've tried everything :banghead:.

Let me back up a little bit then. And I'm quite sure I've gone about this some backwards way so feel free to offer suggestions. First off, my overall goal is a cross-tab query result that I can put into a report. My starting table is a giant log of daily information. This table contains...

Ok. So this should really be simple but for some reason, I am not getting the result I want. I have the following fields: Incomplete: Nz([Incomp],0) - my original field name was "Incomp". I renamed it to Incomplete and defaulted it to zero. Complete: Nz([com],0) - my original field name...