Search results

  1. I

    Get value from one table and subtract it from a similar value in a different table?

    any advice would be appreciated mainly i want to know if its possible
  2. I

    Calculations and updating tables

    any advice would be appreciated mainly i want to know if its possible.
  3. I

    Get value from one table and subtract it from a similar value in a different table?

    Calculations and updating tables Ok, i have two tables, one called Feed Schedule, in it is has Type of food and Quantity Fields So it looks like this Type of Food Quantity Cat Null Dog 2 Then i have another table called Stock, it has the same layout but has the current stock for each of...
  4. I

    Calculations and updating tables

    Ok, i have two tables, one called Feed Schedule, in it is has Type of food and Quantity Fields So it looks like this Type of Food Quantity Cat Null Dog 2 Then i have another table called Stock, it has the same layout but has...
  5. I

    creating query that runs in a form when i enter two dates in....

    omg i did it using unmatched query wizard in about 15 seconds. >:O! i need to learn alot about access. Thanks people. :]
  6. I

    creating query that runs in a form when i enter two dates in....

    well i got to show them by making a simple query but i want it to show the ones that are not in the first query, what criteria would i put in? ive uploaded my db.
  7. I

    creating query that runs in a form when i enter two dates in....

    i got it to work using, >=[forms]![Edit Booking]![Start date of booking] & >=[forms]![Edit Booking]![End date of booking] But now i have to make a macro that gets the kennel ids from this query and compares it to a table of kennel ids using another query and then display these. but...
  8. I

    creating query that runs in a form when i enter two dates in....

    how do i get it to put the start date in from the form text box and the end date in from the end text box?
  9. I

    creating query that runs in a form when i enter two dates in....

    creating query that runs in a form when i enter two dates in that gives possible kennels that arn't in use for them dates. So i have a booking form with start date of the booking and the end date of the booking, then the kennel number that booking will use. but i want the combo box where you...
Back
Top Bottom