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 Wanet Telecoms Ltd 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: bendixen
  • Content: Threads
  • Order by date
  1. bendixen

    upgraded Access 03 to 07, joined query now won't work

    I recently upgraded from Access 03 to Access 07. Most of my queries linking to ODBC tables I previously created in 03 are working fine. There are a couple that do not now. The ones that do not have left joins between some of the tables in them. The tables are pulled in from an ODBC source...
  2. bendixen

    Query gives no results when using [enter] in one of the Criteria field

    I am running into a problem where the query gives no results when I have [enter budget reference] in the Criteria but if I hard code the same information into the Criteria line the results are produced. I'm trying to create a pop-up box so the user doesn't have to go into the query itself to...
  3. bendixen

    dLookup with multiple conditions?

    Is it possible to have multiple conditions in the criteria field of a dLookup command? I want to autopopulate a value into a form if both pieces of critera are met. The table I'm pulling the information from has the same person (UID) several times, but only one time per project number...
  4. bendixen

    Trying to add +1 to record revision number automatically

    This is probably simple, yet I'm not getting it. I am using a form to update records in a table. To prevent duplicate records from being entered, I am requiring a new revision number to be entered when changes are made to the existing records before the new record can be saved. That part...
  5. bendixen

    Need Help querying range within range using MIN & MAX

    I am trying to query a range within a range. I have a table which has a ProjStartDate and a ProjEndDate field. There is also a DailySalary field. My report has a RptStartDate and a RptEndDate. I am trying to have the report show the salary calculation for any projects with dates within the...
  6. bendixen

    Need to search a range within a range

    Any help on this would be appreciated. I'm losing what little hair I have left! I am trying to query a range within a range. I have a table which has a ProjStartDate and a ProjEndDate field. There is also an AnnualSalary field. My report has a RptStartDate and a RptEndDate. I am trying to...

Part and Inventory Search

Back
Top