Possible to pull a query into a form design?

[accessmatt]

Hello



Is there a way to pull data into my form so that I can see current stats about my table in the same box as where I'm entering new data?

Thanks!

[June7]

What do you mean by 'current stats about my table'? What information do you want to show? What kind of 'box' - combobox, listbox?

[accessmatt]

Thanks June7, basically I want to query my table, it's a project tracking database, to see how many hours I've spent that day on each of my projects. It would be useful to see this information in my input form...like on the right column.

What do you mean by 'current stats about my table'? What information do you want to show? What kind of 'box' - combobox, listbox?

[June7]

That sounds like an aggregate query or a DSum() domain aggregate function. Can't be more specific without knowing data structure. What is the 'right column'?

[accessmatt]

Hey June,

By right column i simply mean the right hand side of my input form...just where I wanna place this. Could you be more specific about how I would use DSum to get the data to show on my input form? Here's a link to my DB:

https://onedrive.live.com/redir?resid=D8D255DA4B632417!33049&authkey=!ABkCH1 RX5W8OZzM&ithint=file%2c.accdb

[June7]

Elapsed time will never cross midnight?

You are using multi-value field. Do not recommend - I NEVER use multi-value field.

You have a record with no brand or date, only time. That record will not be included in any day's summary.

Expression in textbox: =DSum("Field1","Table1","[Date]=#" & [Date] & "#")

Access Help has more info on domain aggregate functions.

Date is a reserved word. Should not use reserved words as field names.

[accessmatt]

Appreciate your input so far June7 but instead of summing all records, do you know of an Access formula which would show a break down of entries over course of a day (start time, end time, duration)?

Thanks,

[June7]

Break down to what - each Brand/Indication entry? This is a multi-value field. How should Access 'know' how much time to assign to each selected value?