Search results

  1. B

    Form output data manipulation

    I tried adding max to a date and distinctrow. Did not help and date no shows as #Name? because of Max setting for the date. Here is what I have: SELECT DISTINCTROW Info.InfoEntryID, Info.InfoBarrelNum, Info.InfoPh, Info.InfoSalinity, Info.InfoAcid, Info.InfoDip, Info.InfoText, Info.InfoMRU...
  2. B

    Form output data manipulation

    SmallTime I tried different combinations. Can you give an example of what unique records might look like? Thank you
  3. B

    Form output data manipulation

    Hello I have a form that has a search button. Search button calls on a query. SELECT Info.InfoEntryID, Info.InfoDate, Info.InfoBarrelNum, Info.InfoPh, Info.InfoSalinity, Info.InfoAcid, Info.InfoDip, Info.InfoText, Info.InfoMRU, Info.InfoBarrelID FROM Info WHERE...
  4. B

    Outlook form not posting correctly to Access

    I have custom form in Outlook. part of the code behind is posted below. Problem: If CDbl(TotalH) is 4.683333, rst!LengthofAppt is rounded up to 5 instead of staying 4.683333 Anywhere else in the code rst! value can be anything such 0.003 or 111#$23. It seems to be Access issue, but all fields...
Back
Top Bottom