Recent content by dching

It appears that the data you have contains amounts for each hour of the day. This makes it very hard to transpose the data into 2 separate columns without having to write multiple queries to extract the data from each control. What I would do is to create 1 make-table query for the first...

Thank you so much for the code. It works great. I've placed it in my library for future use. Thanks again. Derek

It sounds like your sub-form is not linked to the parent form. If the sub-form is linked (parent-child relationship) it should sync up correctly.

Your question seems very confused. Can you rephrase what you are trying to do. Also, are the table fields correct, i.e. peak_price off_peak_start??

I have a database that contains two fields: Excel file name File location I'm trying to create a click button on a form that when clicked, it uses the [file location] and [excel file name] to launch excel and open the existing workbook ([excel file name]) at the file location ([file...

Thanks for the lead. I'll check it out. Derek

I normally would, however, the entire db is built with multiple reports, queries and forms, sub-forms and sub-reports. Not that I'm lazy (nah, I am lazy) but to go through it at this time would be quite challenging; unless there is a way to change all of the names in all instances. If you can...

Found the Answer! Pat, Found the answer. "Section" is a VB command. Therefore, once you use it in a concatenated string, it will produce an error. The workaround is to create a query and create an expression using the [Section] field, i.e. SectionX:[Section] Whereby SectionX is the new...

Greg, You can also put an "if" statement in your query to translate the "yes" to a catagory item. For example: If you have a check box field for Engine and a check box field for Transmission, then, in the query you would create 2 selections of: CatEngine: iif([Engine]=-1,"Engine","")...

Pat, Thanks for the reply. I've looked at the report and also created a quick and dirty just using the two table fields. There is no duplication of the bound and unbound fields. To provide you with additional information. Table 1 Fields. Index Section Table 2 Fields Index Index Link to...

From the View menu item, select Sorting & Grouping. From the sorting and grouping window, select the field (location) and turn on the footer. Once you close this window, you will then see the new footer (location). Go into the properties of the location footer and under the "All" tab, change...

I'm concatenating two text fields using the following string: ="Total " & [Section] & " Tests:" However, when I run this report, I get a #Error for the object. I also have another concatenated field using the following string: ="Total " & [Subsection] & " Tests:" When I run the report using...