Recent content by ThyTony

Hi arnelgp, Following your example, I could create extra row "Total project" to the union query . I tried to converted the Amt to currency data type by separating the original query into two queries but no success. I want to display the data in the report so that the upper part of report shows...

Dear arnelgp I have created the crosstab query which indicate the project progress of one selected WorkUnit from a form VS the ProjectYear (which I converted to column heading number and count the number of projects (ProjectID) as attached for your reference. My problem is I want to add 3 rows...

I see the problem. I'm using the data entry from a form. I need to remove the criteria from the old query and put in crosstab query.

So after I created a crosstab table, I can not use it in the report Record Source in my Report because there's no "Existing Fields" to add to the report. Any Idea how I can create report?

Hello everyone, I want to create a report table from the selected fields but need it to be in the top of each other ( vertically). I'm not sure what's it's actually called but it's like merging cells in excel. I have attached the table image which was created in excel. The table shows the list...

Thanks arnelgp. It works

I have a Date/Time field which I call MeetingDate. When I do a report based on the query in which there's MeetingDate field, there's some empty values of the field and I want to put text "N.A" in it. In the query I've created a new field which I call "StrMeetingDate" which I converted to string...

Hello Doc, Thank you. I'll take it. :) I hope we can share ideas on how to solve problems related to MS Access. Regard

Hi all, My name is Tony from Cambodia. I am kind of lazy person so that I really want thing to go fast and easy. I struggled to use Exel to do the document control plus tracking tasks and do report. Here I am learning MS access because I hope it is going to help me out with my office work.