Getting a Value from a Form for Query Criteria in MS Access

A question I get asked all the time is how to reference a value on a FORM (like a Customer ID) from another query or report. This video shows you how.

Duration : 0:7:26


[youtube QUcjL7Cy5n0]

4 Responses to “Getting a Value from a Form for Query Criteria in MS Access”

  1. Thank you very much …
    Thank you very much. It was very helpful and easy to understand !!!!

  2. oops sorry touchy …
    oops sorry touchy touchpad, anyway I need to subtract starttime from end time, but the date info is messing up the calculation, is there a way to split that data when I run my Query?

  3. Have a table with …
    Have a table with Start and end times but the way the data was entered included the date so input is StartTime: 1/2/2009 6:30:00 AM and endTime: 1/2/2009 6:30:00 AM

  4. Thank you soo much …
    Thank you soo much its really very nice….! Helped me alot

Leave a Reply