Search results

  1. C

    Count Unique Function

    Is there any functions that I can use in a report to count the unique value in a field. e.g. there are so many records of the same day, I just want to count it once. Thanks!
  2. C

    Null Value in Cross-Tab Query

    Is there any way to change the null value in the Cross-Tab Query to show "0". Presently, the null value field is blank. The problem I have is when I set a control in a form to add up the fileds from the cross-tab queries, the formula doesn;t work if the fields are blank. It must have a 0...
  3. C

    OLE Field doesn't show the picture

    In datasheet view of a table, I insert a picture in jpg format into an OLE field. it shows the word "Package" instead of the file path. When I go to the form of the table, the field shows something like an icon, but not the picture. I didn't select the box "display as icon" in the dialog box...
  4. C

    Capitalize the first letter

    How to capitalize the first letter in a query?:confused:
Back
Top Bottom