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 Perk76

  1. Perk76

    Automatically Enter A (1) in a different cell

    What I am trying to do is enter a name in one cell lets say cell D. I would like Cell C to automatically have a 1 in it. I am counting the number of people for a monthly total. Any ideas? I enjoy using Access, but have yet to attain a high skill for it! Thanks in advance.
  2. Perk76

    Change a Date to a Quarter?

    Thanks..got it workin now! Is there a way in a query to take the date and view only one quarter before? ex: ExitDate EndofQuarterDate 3/30/02 9/30/02 When i set a parameter for the EndofQuarterDate, i do < [EndofQuarter] in the criteria for query. How can I go only 2...
  3. Perk76

    Change a Date to a Quarter?

    Ok, I need to take a date [ExitDate], change it to the corresponding quarter. I used DatePart(&quot;q&quot;,[ExitDate]), and it returned the quarter of the date. Using this, I need to add 2 quarters. I did it, but it doesnt take in effect that there is only 4 quarters in a year, and I want...
  4. Perk76

    Can't use wizard for button!!

    What are you trying to print? The form? Data? Or a Report? I enjoy using Access, but have yet to attain a high skill for it! Thanks in advance.
  5. Perk76

    Query Count

    I made a query to return 4 fields...custid/exitdate/y/n/reason. How do i make a count column that counts the number the query returns? Then I want to take the &quot;Y&quot; results and divide by the count column? TIA I enjoy using Access, but have yet to attain a high skill for it! Thanks...
  6. Perk76

    Form Help: Make a Field Entry Mandatory if Another Field is &quot;N&quot;

    I did that, now when I click on add record, it comes up as: You cant go to the specified record. Wont let me enter any data. I enjoy using Access, but have yet to attain a high skill for it! Thanks in advance.
  7. Perk76

    Form Help: Make a Field Entry Mandatory if Another Field is &quot;N&quot;

    Where would i place that code? Form properties somewhere?
  8. Perk76

    Form Help: Make a Field Entry Mandatory if Another Field is &quot;N&quot;

    I have an Employed field where the data entry is &quot;Y&quot; or &quot;N&quot;. If this field is &quot;N&quot;, then I want the NonEmployed field to be mandatory on the form which is a dropdown box? Any ideas?
  9. Perk76

    Make an field on a form mandatory if another field is &quot;n&quot;

    I have an Employed field. If this field is &quot;N&quot;, then I want the NonEmployed field to be mandatory on the form? Any ideas?
See more

Part and Inventory Search

Back
Top