1
  • MS Access Date Conversion in a Query

    I have a start date field in a table, I need to calculate a completion date that is 6 months later but it must also be a Friday. I know how to calculate the 6 months part but I don't know how to advance the date to a Friday. For instance if the start date is 4/15/13 then the completion date must be...

    mac3225 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following