Search results for query: *

Very cool. I think I'm almost there. I've added the new module and added the line: =Concatenate("SELECT FruitField FROM tblNoName") with modifications for field and table names. How do I now group the concatenated values? In my original example, it would have been somethig like: [Name]...

Thanks for your response Dhookom. Are you suggesting that I copy PHV's concatenate code into a new module and call it "Concatenate", then use the line: =Concatenate("SELECT FruitField FROM tblNoName") Thanks.

Thanks PHV! I'm still new at coding so I'll have to review this. I'm not sure I understand how to integrate it into my report...

Hello Forum, I've been searching for days about this one and have been coming up empty-handed. Perhaps it is because I don't know what key words to search for... I have a report with a field (let's call it [FruitField])that returns records in the following manner: Apple Orange Banana Kiwi I...

Thanks for your reply dhookom! After I made a small adjustment to account for null values, it worked like a charm.

Hello Forum, I have a field called "Locations" that returns data in the following fashion: Head, Head, Leg, Arm, Head, Arm, Leg, Torso, I am trying to create an expression that will trim the comma at the end of the data. The "Trim" function removes spaces but not characters. Does...

Thank you both for your help! I really appreciate you taking the time to assist. CMP: Unforunately, I kept getting "#Error?". I even tried creating a form and table from scratch and continued to get the error. Very weird. Keun: Your suggestion worked! Thank you!

Thanks CMP. I'm still not seeing the sequential numbering. Questions: 1. Can the field Key be a date field? 2. Can you explain the different parts of the DCount expression? Maybe I'm misunderstanding something there. Here is what I have: - Form name is "frmSurgery". - Form Default View...

Hi keun, There is an Autonumber field on the table that the subform stores its data, however, it does not correspond to the subform. I could not get DSum to do what I wanted. Can you help? Thanks!

Hello there. This seems like an easy task but I've been searching forums for two days and have not found a solution... I have an Access form with an embedded subform. The subform returns multiple records based on the main form. I want to number these records returned in a sequential fashion...