Recent content by ituser2008

I have a form created with multiple text fields for users to input the information and the data is saved in the access table. How do I add a button to the form for user to attach a word document for each item the user has entered into the form. The word document is different for each item...

Actually, I need to be able to see the detail behind the bucket 1-30. For example, if there are 2 items in the bucket 1-30, I want to see the detals for these 2 items such as username, systemid, and other fields from the datasource. Currently the way the pivot table has created, it will shows...

Thanks for everybody's responses. Yes, the datasources is in the workbook and I tried the drill down option. It does bring the details to another tab with the rows I have selected but what I really want to see is if it possible to only show the detail for a particular aging bucket I have...

I have a pivot table layout liked the following. Is anyway when I double click on the items counts listed under each aging bucket and it will show the detail for the age bucket and the user I clicked on?? For example, if there are 2 items listed under age 1-30 bucket with user Mary, when I...

I have a pivot table created by a former colleage and it was connected to a different sql server. How do I change the datasource so it can connect to the new sql server?? I tried to create a new data source but I still can't get the pivot table to change it to the new server. Any help will be...

How can I find out what is the operation system account assigned to the sql server agent?? Any help will be greatly appreciated. thanks

Is SA a default username setup up by sql server?? Does it come with a default password??

Has anybody experienced the same issue as I have??

yes, the package was changed to the new server name. I was able to open the package and run it manually but if i schedule the job to run, it failed and I got an error message stated " access is denied". Have no clue why i can run it manually but the job is not running automatically. Has anybody...

I reimported the dts package into the sql on the new box. I don't think there is a password on the package. How do I check the security for the package?? The job only started failed after the move.

We had a server move last month and the scheduled job ( a dts package) started failing after the move. I kept getting error message " access is denied" and can't figure out the reason. All the databases were backup and restored to the new server. I can manually execute the package and it ran...

Thanks for everybody’s help. I was able to suppress the duplicate record by adding the formula to the section detail. However, when I tried to sum the trans amount and place at the report footer section, the trans amount for the duplicate record was also being calculated into the total. Any...

Yes, it is a 1 to many relationship but the records needs to be at the detail level. Is any other way to do it??

How can I suppress duplicate records at the detail section?? The report is group by customer id and below is an example. Any help will be greatly appreciated. Thanks customer id Productid transdate 1234 a50 5/10/07 1234 a50 5/10/07

I am trying to convert a number field to a string field but when I used the totext function, it returned 'comma' to the output. How can I elimiate the ',' from the output?? Any help will be greatly appreciated. Plan_id with type= number (22,0) left(totext({plan_ID}, 0), 5) output 13,22