Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: captsamm
  • Content: Threads
  • Order by date
  1. captsamm

    Query on record for two items

    I have a customer database that includes the customer and his/her significant other and their birthdays. Field names are fname1, lname1, birthday1, fname2, lname2, and birthday2. (yeah I know it's not very original ;-} ) Would someone help me write a query that would output a single list of...
  2. captsamm

    check boxes in queries

    I have several fields collected into a form by a query. I want to change the data in one of the fields but when the field (a check box in this case) is clicked, the check box will not change state...merely a ding and nothing happens. Can anyone tell me how I can change the data in a field when...
  3. captsamm

    Check boxes and queries forms

    I have a query which uses a y/n field (check box) in my data base. I've written a form to support the query and want to include the check box. When the check box is not clicked, the record will appear in the query but if the check box is (no) then the record will not appear. The idea is that...
  4. captsamm

    Birthday alerts

    I need a query that will produce a list of people from my table that have a birthday within a two week window that starts one week from the day I run The query. ie; if I run the query today, Oct 9th, the query should list everyone with a birthday beetween the 16th and 30th of October. Can anyone...

Part and Inventory Search

Back
Top