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!

  • Congratulations Chriss Miller 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: *

  • Users: 8track
  • Content: Threads
  • Order by date
  1. 8track

    Executive Members within a Grouping

    Hopefully this is my last big question for a while. This, to me is a bit of a problem. I need to extract the Members name and their executive position within each of their own group or Chapter. I believe it would be a select statement of some sort. GroupName = CommitteeMembers.Committee_ID...
  2. 8track

    Missing Data

    Data is missing when extracting from Access into CR for no apparent reason. @MembersName = {Members.LastName}+ ", " +{Members.FirstName}+ " (" +{Members.SpouseName}+ ")" shows most members, but then for no reason some data extracts do not show with no rhyme or reason that I can see. I have...
  3. 8track

    Canadian Postal Code & Phone number

    Hi, I am extracting data from an Access database into a CR v.8 report. The data field in Access is currently formatted with a Canadian Postal code as follows T5T_2N2. My question is as follows: The postal code shows in the CR report as T5T2N2 (there should be a space with no underscore) How...
  4. 8track

    Grouping lastname, firstname (spousename)

    Please help. My training is basic and has been about 5 yrs ago, so I am rusty. I am using CR v8. I need a formula to combine lastname, firstname (spousename). So to summarize it would look like this: LastName, FirstName (SpouseName) Sounds pretty basic, but as I said, I am pretty rusty...

Part and Inventory Search

Back
Top