First vs. Group by - Sum....or DSum - without clipping Memo field

[arpeggione]

Hi All:

I have a query with a Sum in it. Maybe for me, DSUM works the best, but I have heard it is slow so I'm trying other options.

So now, I've got a Sum field in my query, and tried using First for all of the other fields (instead of Group By as I have a memo field), but in my Continuous Form View - only the First record shows up - so I think I have to use Group By (which will cause my Memo field to be truncated for some records).

Is there a way I can use the aggregate SUM function, show all records and not truncate any memo fields?

thank you in advance!

Karen

 

[dhookom]

Can you share why you need "Sum" and "show all records"? You can try use FIRST on the memo field. You might want to share your sql view and some information about your table(s).

Duane
Hook'D on Access
MS Access MVP

 

[arpeggione]

Duane: Thank you for your reply...So...for 1 project I have 11 change orders (need to show all of them in a continuous form). When the user selects a change order, the form for the selected c/o shows up in the subform. This c/o may have 4 contracts with 4 costs (which need to be summed) - in a subsubform. The summed cost shows up in the c/o record.

For the c/o records, I am "hearing" that I could use "group by" for most of the fields and "first" for the memo field - is that what you are saying? In any case I'll try it....

I hope what I've written isn't too convoluted. Let me know

thank you again for your time,
karen

 

[dhookom]

This is still a bit hard for an old guy to digest. I don't know what table contains the memo or sum field. It would certainly help if you provided table and field names and relationships.

Duane
Hook'D on Access
MS Access MVP

 

[arpeggione]

Duane: Let me try a couple things first, then I will post accordingly....thanks again for your ideas karen

 

[MajP]

May want to read first

http://allenbrowne.com/ser-63.html

 

[arpeggione]

Thank you MajP - this is good information...Karen