Recent content by yanliang

  1. Y

    iif Calculate percentage

    I need to calculate the percentage of the contribution of customers (how many times of purchases) in a specific state. iff function: count up the times of transection of customers in a state like "Indiana" and divide to the total numbers of transactions. Pls help thank you
  2. Y

    iif function

    thankyou so much
  3. Y

    iif function

    I need to create a query for certified employees. the certified field is called "certified?" and is Yes/No If an employee is certified I need to input "Eligible for Bonus" if not "Enroll in Summer MG Class" I inserted in a function iif([Certified?]="Yes","Eligible for Bonus"...
  4. Y

    phone number of area code

    I ran into a problem where I need to find those who did not enter an area code for phone numbers. (626)421-3459 is correct but some are ()421-2459, are the one I need to find. how to find those who those.
  5. Y

    General question about dates and expiration

    I am a new starter on learning about access and database. I ran into a problem that is in the field of CardExpirationDate. An expiration date that has past or is within 30 days of the current date should not be allowed. Any expiration date that is more than 30 days into the future is...
  6. Y

    Basic database leaning

    thank u so much. really helpful
  7. Y

    Basic database leaning

    Hi, I am a student that just started learning about data and access. I ran into a problem with creating a rule in the field of CardExpirationDate. The question is how do I set up a command which tells the people to enter a Credit Card number which pastes or is within 30 days of the current...
See more
Top Bottom