Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shortamericano

    Listing Records Horizontally, Rather Than Vertically

    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]...
  2. shortamericano

    Listing Records Horizontally, Rather Than Vertically

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

    Listing Records Horizontally, Rather Than Vertically

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

    Listing Records Horizontally, Rather Than Vertically

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

    Trimming Field with Variable Lengths

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

    Trimming Field with Variable Lengths

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

    Numbering Records on a Form

    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!
  8. shortamericano

    Numbering Records on a Form

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

    Numbering Records on a Form

    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!
  10. shortamericano

    Numbering Records on a Form

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

Part and Inventory Search

Back
Top