User Profile

Collapse

Profile Sidebar

Collapse
namktkt
namktkt
Last Activity: Nov 7 '14, 10:14 AM
Joined: Sep 19 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • namktkt
    replied to Report displays Sum of Group wrongly
    in Access
    Thanks twinnyfo.
    In fact, these are numeric fields only. I just get back to the table & found out some records were not rounded numbers.
    I think this is the cause of my problem & I need to re-check the whole table.
    One more experience for myself, guy.
    Thanks for your advice.
    See more | Go to post

      Leave a comment:

    • namktkt
      started a topic Report displays Sum of Group wrongly
      in Access

      Report displays Sum of Group wrongly

      Hi all,

      I've got a strange problem with report of Access. Hope that some of you experienced this before & can help me out.

      I've a table & make a select query to filter data. With that query I created a report (& here comes the problem !!!)

      In my report, I need to make 2 levels of Group. Problem is when viewing the Sum of the 1st Group (i.e Sum(VND)), it's obviously wrong by missing a tiny amount...
      See more | Go to post
      • namktkt
        replied to Create a report with concatenating value
        in Access
        I found the error, twinnyfo.
        U missed one line in your codes:

        Code:
        Loop
[B]BuildString = strReturn[/B]
Set rst = Nothing
        So, now I can run the function directly in Report (no need to set up a Query then).

        It's done.
        Thanks guy
        See more | Go to post

          Leave a comment:

        • namktkt
          replied to Create a report with concatenating value
          in Access
          Yes, i created a new report & follow your way. It's still nothing there.
          Let me try on another PC by tomorrow. Thanks
          See more | Go to post

            Leave a comment:

          • namktkt
            replied to Create a report with concatenating value
            in Access
            I tried this but one msgbox saying that "Query input must contain at least one table or query" :(
            I'm using MS Access 2007 SP2.
            See more | Go to post

              Leave a comment:

            • namktkt
              replied to Create a report with concatenating value
              in Access
              Yes, that's correct. I checked around & tried to insert Option Explicit as guided in http://allenbrowne.com/ser-30.html
              But it's still the same :(
              See more | Go to post

                Leave a comment:

              • namktkt
                replied to Create a report with concatenating value
                in Access
                Hi twinnyfo,
                Table1 is requested by Access to execute the query. When I try to run the query alone, it also doesn't have any value inside (except for some blank cells) !!!
                See more | Go to post

                  Leave a comment:

                • namktkt
                  replied to Create a report with concatenating value
                  in Access
                  I set up 1 Query & use it as Record Source for the Report.
                  It is "SELECT BuildString(1) AS CreateDate, BuildString(2) AS DeliveryDate, BuildString(3) AS CompleteDate
                  FROM Table1;"
                  See more | Go to post

                    Leave a comment:

                  • namktkt
                    replied to Create a report with concatenating value
                    in Access
                    I've got it & try your suggestion but it fails !!!
                    Anyway, let me check this error around & get back to u. Thks.
                    See more | Go to post

                      Leave a comment:

                    • namktkt
                      replied to Create a report with concatenating value
                      in Access
                      Hi twinnyfo,

                      I copy your codes in the Modules under the name of Module1. I tested it by using AddWatch with the strReturn & I can see the output of the Function.

                      However, when I set up a textbox on Report & set =BuildString(1) in the ControlSource, the Report only displays blank for this Textbox at the preview mode. Am I wrong somewhere else ?

                      Thks
                      See more | Go to post

                        Leave a comment:

                      • namktkt
                        replied to Create a report with concatenating value
                        in Access
                        Thanks jforbes, I understand that u're guiding me another approach to my issue. But it seems to tough for me to get your points (I'm quite new to Access !!!).

                        Thanks twinnyfo, your modified codes look much better than mine. Please let me check at my end & get back to u soon.
                        See more | Go to post

                          Leave a comment:

                        • namktkt
                          replied to Create a report with concatenating value
                          in Access
                          Yes, I need the data is A,B...(not the date).
                          The number 1,2,3 is not necessary, so don't pay attention to it.

                          Anyway, with my codes, I can see that I was able to list the data to A,B,C...but now I don't know how to assign them to the Report (sorry I can't upload my file here). I tried to put "strCreDate ", "strDeliDat e", "strCompleD ate" to the ControlSource of 3 different textboxes in the report. But...
                          See more | Go to post

                            Leave a comment:

                          • namktkt
                            replied to Create a report with concatenating value
                            in Access
                            Hi twinnyfo,

                            When u say about writing a Function, I'm a bit worried as I'm not so confident in writing a Function in Access. But anyway, I tried & did it (as below).
                            As you can see in my file, we can get the outcome of the Function but it's quite stupid to me that I can't assign these output values to the Report !!! Can u help me this ?
                            And another question is that can we arrange output values in better order (it is currently...
                            See more | Go to post
                            Last edited by zmbd; Sep 22 '14, 05:41 AM. Reason: [z{please be aware that usually only one question per thread is allowed.}]

                              Leave a comment:

                            • namktkt
                              started a topic Create a report with concatenating value
                              in Access

                              Create a report with concatenating value

                              Hi all,

                              I'm a newbie to MS Access & trying to make a report with from a table as below :
                              Code:
                              	ItemID	CreDate/DeliDate/CompleDate
	A	01-Jan		
	B	02-Jan		
	C	02-Jan	04-Jan	
	D	03-Jan	05-Jan	07-Jan
	E	04-Jan	06-Jan	08-Jan
                              My expected outcome for the report is like
                              Code:
                              1. CreateDate : A,B
2. DeliveryDate : C
3. CompleteDate : D, E
                              I tried...
                              See more | Go to post
                              Last edited by zmbd; Sep 19 '14, 04:21 AM. Reason: [z{Using the [CODE/] format button will help preserve formatted tables (^_^) }]
                              No activity results to display
                              Show More
                              Working...