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

is the data stored as a string, number, or date?

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

fix(now() - [table1]![date]) will truncate the decimal (int will round) therefore: dayslate: fix(now() - [table1]![date]) - 365 criteria: >0

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

I got the rolling sum figured out: RollingSum: DSum("([CUT_LENGTH_FT]*[QUANTITY])","[TableA]","[DETAIL_ID]<=" & [TableA].[DETAIL_ID] Now I have another problem I will post in a different thread.

very easy way of doing this in your query do an expr1: now() - [table1]![date] then in your criteria do a >365 for 1 year this will give you just the records that have a date over 1 year. you can modify the number accordinly.

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