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 gkittelson 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: auerd
  • Order by date
  1. auerd

    query to find previous record fields

    133000 records. It is slow and I am unable to use the query in a report. Any ideas on how to remedy?
  2. auerd

    query to find previous record fields

    MS Access 2003 I need to have a query that shows a record with 2 fields from a previous record where the MOrder field is the same and Adate is greater than current records Adate. This is an example of the data in the tApprovals table Morder Adate ApprAmt abc123 1/1/2010...
  3. auerd

    parse semicolon delimited table

    MS Access 2003 I have a table called tblHistory with the following fields... HistRev MOrder HistNotes HistDate with the below data rows. It is semicolon delimited. I need to parse the records to a new table called tblDestination HistRev 1;2;3 1;2 MOrder abc123 xz123 HistNotes...
  4. auerd

    send email to query fields

    Access 2003 When I click a button on my form I would like it to email to all recepients that are in a query. Query is qLookupNotifyNewProj. SQL SELECT DISTINCT t41ContactsMSP.MSPContactEmail FROM (tblVersion LEFT JOIN t41ContactsMSP ON tblVersion.UserID = t41ContactsMSP.MSPContactUserID) LEFT...
  5. auerd

    multi select list box

    Multiselect listboxs I am so close but yet soooo far... I have a form with combo boxes which display the choices from the boxs in a list box. If you choose from one of the 7 combo boxes it limits the display in the list box, if you choose another combo box, the listbox display is limited...

Part and Inventory Search

Back
Top