Search results

  1. B

    Sum a count from a subreport in the main report

    :banghead: I'm giving myself a headache... If someone would be so kind as to point me in the direction of a solution, I would be grateful. I have a report which should count the number of students and provide the number of hours of service for each major, and then the total of each for the...
  2. B

    SWITCH expression using values from 2 fields

    Hi all - I've been poking around for something that will help me formulate an expression for this, and I've found some things that are very close, but not close enough for direct application... I expect someone will tell me if I'm going about the the completely wrong way, I am looking for the...
  3. B

    Adding 2 fields together - you'd think it would be easy, wouldn't you?

    Ok, I'm absolutely positive I'm missing something totally simple here... Someone give me a clue... I have a database whereby I track academic performance of students in our program. I am trying to use last year's table to calculate how many hours each student earned during all three semesters...
  4. B

    Instead of quote marks, what?

    I have a report listing certain information. Because that report is then exported to Excel format for distribution, the name field is concatenated, Last name, first name, preferred name on a new line. Looks something like this: =[LastNM]&", "&[FirstNM]& Chr(13)& Chr(10)&[PreferredName]...
  5. B

    Query to find students over 25

    Ok - I've been searching, but not finding, so I'll put it out there, and maybe one of you talented folks can give me the simple answer that's been eluding me all afternoon... I need to pull all the records from my db of students over the age of 25. I thought perhaps I could use a simple < or >...
  6. B

    Another Date Sorting Question...

    Happy New Year all! I'm new to the forum and have been lurking for a few weeks... gotten some very good answers to my questions. I have been searching and searching for the answer to a particular problem, which could fall under either reports or queries, I'm just not sure which is the...
Back
Top Bottom