Search results

  1. A

    Data in one table that is not in the other.

    ahhhh Thank you for your prompt response...that worked! :cool:
  2. A

    Data in one table that is not in the other.

    Hi, Can anyone assist me with this problem I'm having? I've created a simplfied generic version of what I'm looking to achieve but have been unsuccessful with lookup columns (probably i'm doing something wrong with it). One table has these fields- Letter - A, B, C, D, E Val - 10, 20, 30, 40...
  3. A

    Macro to filter data

    can you place a sample of your table data and exactly what you are trying to filter by? I can try to assist with procedure to get it done.
  4. A

    Enter date automatically when click in box

    Much thanks..i forgot about this...
  5. A

    Enter date automatically when click in box

    make sure you change the format in the date field on your table. Then go "On Enter" and put the following sample code Option Compare Database Private Sub Transaction_Date_Enter() Forms!Names![Transaction Date] = Date() End Sub My date field is named Transaction Date and my form name is Names...
  6. A

    Minimum Date not working in Totals Query

    You can try the following:- Let me know if it works. SELECT Q_AttendingAfterSchool.AdultID, Q_AttendingAfterSchool.AdultName,Q_AttendingAfterSchool.DateOfBirth FROM Q_AttendingAfterSchool where Q_AttendingAfterSchool.DateOfBirth = (Select Min(Q_AttendingAfterSchool.DateOfBirth) from...
Back
Top Bottom