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!

  • Congratulations derfloh 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: *

  1. 1stTimeOut

    Combine 2 Access Records into 1 Excel Row?

    Skip, Thanks for taking time to answer my question. As I am really new to this, may I please make sure I'm on the same wavelength as you? The two records reside in one table. How does A. and B. work for one table? After the laughter dies down....thanks, and don't worry, I'm getting used to...
  2. 1stTimeOut

    Combine 2 Access Records into 1 Excel Row?

    From my database, I output to an Excel spreadsheet. The database shows two records, with some matching fields and some varying fields. I need Access to analyze the LABEL #s and if they match, combine the two records into one row of cells in Excel. I ran a macro using "ALT-Enter" to create a...
  3. 1stTimeOut

    Excel Formatting and Combining two Access Records

    From my database, I output to an Excel spreadsheet. The database shows two records, with some matching fields and some varying fields. I need Access to analyze the LABEL #s and if they match, combine the two records into one row of cells in Excel. I ran a macro using "ALT-Enter" to create a...
  4. 1stTimeOut

    Can Form Field have default formula AND override?

    PHV, Thanks but no luck with that one. DateB doesn't populate at all now. Anything event required in DateB? Thanks for your time!
  5. 1stTimeOut

    Can Form Field have default formula AND override?

    I need a field (DateB)in a form where the default date is based on two criteria: 1. A specific box (BlockA)is checked 2. A date is entered into another field (DateA) If both 1 and 2 are true, then (DateB)=((DateA)-7). Ocassionally, the user will need to override the formula in (DateB) and...
  6. 1stTimeOut

    Find a record using 2 criteria

    My form pulls from a table containing two records [MDN NPA-NXX] with a date of 01/01/98 [MDN NPA-NXX] with a date of 01/03/99 I'm using a combo box to find the records. It searches fine, but will only populate the form with the first record even if I select the second record from the combo...

Part and Inventory Search

Back
Top