Search results

The report has already used a query to bring out the details, that means every records even it is the same day. In the page footer I need to count the number of unique date. I think it's impossible to have two separate queries in the same report. The other way I can think of is to use...

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!

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...

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...

I think I havn't make my question clear. I have a field in a table that have already been filled with data in captial. I want to make a query with the first letter capitalized. I know there should have some simple function that can perform this job. I have tried to search the forum, but...

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