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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wambaugh

  1. wambaugh

    Help needed on export to excel

    Thanks TomHW Just what I Needed Thanks Wambaugh
  2. wambaugh

    Help needed on export to excel

    Hi All Does any one know How (or if it's even possible) to transfer data from a query to a specific cell in an excel spreadsheet? I have a form based on a query which has controls in it and I want to be able to extract data from a control (say me.text0) and send it to a spreadsheet in a...
  3. wambaugh

    DCount and Dates Help Needed

    Duane Thank you The 2nd statement works I had tried that before but had gone a day either side and not just the end of the month Is there a resason why you have to go a day forward and not just the month?? Many thanks Wambaugh
  4. wambaugh

    DCount and Dates Help Needed

    Hi Dhookom Not sure what you mean. Why do you have to add .9999 to the last date and how would you do it thanks Wambaugh
  5. wambaugh

    DCount and Dates Help Needed

    When I Run The statement it returns a value That value is wrong If I specify the dates as 1/1/05 and 31/1/05 it should return 9 records for the month of january. It only returns 8 This happens any time that there is a record that matches either of the dates specified in the dcount statement I...
  6. wambaugh

    DCount and Dates Help Needed

    Hi All Im sure this is something stupid but I cant work it out I have a report with a control on it. The control source is the following DCount statement =DCount("[category]","TBL_HELPLINE","[start_date] >= #02/01/2005# AND [start_date] <= #02/28/2005# And [category]=" & category.Value) this...
See more

Part and Inventory Search

Back
Top