Search results

I have a report that has a group within a group. The interior group has a footer with a textbox calculating an average. I would like the Outer group to then SUM the averages. I tried doing a =sum([TextBoxWithTheGroup Average]), but access prompts me for the value of this box when I run the...

I am trying to have a button run an update query using code only. Currently it works great by setting up an update query and then code a DoCmd.openquery line on the buttons code. I was trying to learn on how to not have a prebuilt query. I have tried: Dim strsql2 As String...

is it possible to have a query that makes several records from a single record? Example: [TableA] ID:1 Quantity:3 Length:10 [QueryA] ID:1 Length:10 ID:1 Length:10 ID:1 Length:10

This is a tough one: I am sending records to a table that feeds a cutting machine. I need a field updated when the rolling sum gets to 1100 ft, and then reset the sum. I do not know if this can be done in a query, but that is all I know what to do. Example: id:1 job:1 quantity:10 length:20...