Search results

  1. N

    Automatically Populating Form after selection

    Hope someone can help... I have one table which has emp #, Address, City, State and zip. What I would like to do is create a form that will have a list box. I will then select the emp# and all the other data pertaining to that emp# will automatically populate on my form. How do I do this...
  2. N

    Creating different groups on one report

    Hope you can help... I have a headcount report set up by Dept. Division Tier1 Tier2 Tier3 What I need to do is set up my report to display the data by different grouping depending on the dept. For example, for dept 1000 I need to group the data by Tier1 and Tier3. Then for dept 2000, I need...
  3. N

    Specifying which Data to display

    I need to create a headcount report which displays data by tiers. The problem is that for each group, I need to display the data by different tiers. For Example, For the Private Client Group, I need to see it grouped by Tier 1 then Tier 2. For the Capital markets group, I need to see it by...
  4. N

    Creating a new column from another column

    Hope you can help me out with this one... I created a column in my query called "Clerical" in which Iam adding fields that pertained to clerical staff. However, the problem is,I need to create another column called "Part-Time" which has to look for anyone who is clerical then the formula needs...
  5. N

    Report by Group totals

    How do I create a report which displays only my totals for each group without the details. For example, Group A Clerical Professional Fulltime employees 2 6 Part-time employees 1 2 Group B Clerical Professional Fulltime employees 4...
  6. N

    Detail Report

    I would like to create a report that looks like an excel spreadsheet which will list the details as follows: #of FT #ofPT Total Company Division I 2 1 3 Division II 0 1 1 Dept. 3 2 5...
Back
Top Bottom