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 John Tel 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: dpelizzari
  • Content: Threads
  • Order by date
  1. dpelizzari

    iif else in query not exactly returning the right results

    I have never tried this before, but I was asked to create a calculated field based on information in a query. basically, if a field is blank, then select another field, if that field is blank, select a third. Here is what I wrote: IIf (LEN( [Remedy Budget])>9 , [Remedy Budget], IIf (LEN...
  2. dpelizzari

    Conditional date filter Access 2007 form?

    I have built a form that filters data between two dates (start date, end date) as well as another criteria (site code). If the user puts in the start and end date, they can retrieve all records in that range, however, if they leave the date fields blank, they get no records returned. What I...
  3. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    I have two SQL 2005 tables, ISD SACD and ISD Lease, both tables have a primary key assigned (all bit values have been set to 0, and do not allow nulls). I have created a form using a join between these two tables in Access. I am prepopulating two fields in ISD Lease to ensure the join will...

Part and Inventory Search

Back
Top