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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dinicholls

  1. dinicholls

    Adding together Group Totals

    Hi All, I think I am missing something here, but its driving me nuts!!! I have three groups. Group three contains multiple records for various learners, and using a formula I have forced a 'Y' if certain criteria is met, a 'N' if not, in the group header. In group one, I want it to count...
  2. dinicholls

    Close multiple Forms with one Button

    Hi, This might be really simple to do, but I'm having a bit of a moment, and can't seem to work it out!!!! I'm creating a database, and when a new record has been added, I need the 'close form' button to close 2 forms at once and return to the main menu. I'm not using a switchboard, would this...
  3. dinicholls

    Query - specifying between dates with set outcome

    Hi, My mind seems to have wandered into the ether on this one!!! I am trying to set up a formula field to show that if a date is in a certain range, bring back result 'a'. 'Year of enrol' formula is as follows: if {results.Start Date} = #01/08/07# to #31/07/08# then '07 - 08' else if...
  4. dinicholls

    Adding a 'Return' or 'Enter' to a formula

    Hi All, I appear to be having a mental block!!! I'm using Crystal XI, and rather than put address line's in as seperate fields, I want to combine them together, which I can do, no problems, but how do I put the return in so that the next line of the address is underneath the previous one, and...
  5. dinicholls

    Distinct Count in level 3 group, how to count these in lever 2 group?

    Hi, I've tried the formula, it returns the correct number on a normal count, but just returns 1 for a distinct count.
  6. dinicholls

    Distinct Count in level 3 group, how to count these in lever 2 group?

    Hi, Basically I have a report broken down into three groups. On the basic group level 3 I am doing a distinct count of the number of students, which works a treat. The problm being, in the next group level, I have done another distinct count to get the total of these groups, BUT the students...
  7. dinicholls

    Nested IF 'Between' Values?!

    Hi, This is probably a really easy question to solve, but my mind has gone!!! Can you have an IF statement that works with 'Between' values? i.e: =if(j11 >=170<=500, A,B) Please help, cause its really annoying me!!! Thanks
  8. dinicholls

    Import text file fixed-width to access 2003

    Hi, I have a text file that I need to import into access. The table is big. I know I can import it via the wizard, but I need to do this on a regular basis. I know the lenth of the fields and the position. I believe you can use transfertext, in VB, but I'm not familiar with VB, can someone just...
See more

Part and Inventory Search

Back
Top