Search results for query: *

I have a form with several combo boxes. The selection on the first combo box determines what data is retrieved by a pass-thru query which are then used to populate a table. The subsequent combo boxes are based on a query that grabs data from the just populated table. It's when the second combo...

We are using PeopleSoft 8.44 for our Requisition/ Purchasing, Accounts Payable, General Ledger and Payroll. In purchasing, our inventory and non-inventory items (services) have tax defaults (rates, non-/taxable). Unfortunately, a lot of these items are either non-taxable or have different rates...

I have a report with months 1 to 12 as columns in Detail section. What's the best way of hiding the columns 1 to 5, for example, if the desired information (input selection from Form) is only from Jan to May. Initially, I was thinking of use Select Case making each month visible only as...

What's the difference between Powerplay Web and Upfront? I thought once you published your PPlay report (created through PPlay Windows) to Upfront, that's the PowerPlay Web version. But then I read a Powerplay user's guide which says reports from Powerplay Web Explorer or Web Viewer can be...

My query looks like this: SELECT Fld1, Fld2,'','','','','','','','','','','','',Fld13 FROM tbl_One so that it will create 12 or more blank columns between Fld2 and Fld13. Is there a more 'professional-looking' query to get the same result? Thanks.

Our users are grouped by business unit, department, and project. How do we restrict users to access data in a cube only for their assigned business unit, department and project? A user can have access to one business unit but should be able to look into one or more departments and projects. Is...

I've experimented on several options to copy a table from an external database into my local Access table. After so many attempts and internet searches, my efforts were unsuccessful. So far the script below looks promising as it's only giving me "Invalid Argument" error. Please help as I'm quite...

I have an SQL table (tblOne) created through DTS with the following columns: RecType, Code1, Code2, Month1, Month2, Month3, Month4, Month5, Month6, Month7, Month8, Month9, Month10, Month11, Month12. It's the same layout from a source table in a different database. Now I want to have another...

My Access table is in my C: drive with a DSN-less connection to a database is in a server. Is it possible to copy an entire query result into my local table? If yes, how do I do it. I experimented on a script to insert the results but it when into a table in the database. Thanks a lot for your...

I converted my Access 97 reports into Access 2002-2003 and have been getting the "Microsoft Office Access can't find the macro 'Report menu'. Will appreciate any help. Thanks.

One particular payroll report prints out daily payroll record of an employee for a selected date range (which could be for a month or years). Selection of employee and start/end date is through a parameter. Now I want to create a sub-total of hours worked and wages every 7 days starting from the...

We have several reports in SSRS which will be available to various users through Report Manager. The reports are using drop-down lists to select company and department, both as parameters. The reports work perfectly. But the challenge is, the drop-down list should only have the company(ies)...

In my 2005 RS report, there is an option to enter a week number as a parameter. Instead of manually entering the week number, how do I create a drop-down list for week 1 to 53 without placing each figure as a non-query value of the paramater. Will appreciate any help.

We just acquired SQL Reporting Services 2005 and planning to attend a training. Unfortunately, training available in our area is only for RS2000. Will it be worthwhile taking RS2000 training? I'm just starting with SQL Reporting Services. Thanks.

I have an Excel spreadsheet which imports data from an another spreadsheet. Until recently, data is refreshed everything flows in except for the figures. The column and row descriptions are there but have blank cells where the figures are supposed to be. What baffles me is that it used to work...

I have an Access97 program in Citrix. It uses SQL pass-thru queries to grab data from a database with the following script: ODBC;DSN=Payroll;SERVER=SERVSQL1;UID=reports;PWD=passwd; DATABASE=PayNet;Address=SERVSQL1;Trusted_Connection=No;AutoTranslate=No" My problem is, the program works with...

We are using Microsoft Access (97 and 2003) to retrieve data from an SQL database and generating reports. An ODBC connection was created for the link and a pass-through query is use to select a particular table from the database or a set of tables during consolidation. When running reports we...

I want to create a form with Header data coming from Table 1, Detail from Table2, and Footer from Table 3. The tables share the same ID field. What is the best approach to do this? Thanks.

What's the best approach to create special date categories like 7 days (always day 1 to 7 of each month); 14 days (1 to 14); and 21 days (1 to 21)? I tried a few combination of selections under the Relative Time tab but couldn't get it right. Greatly appreciate any thought or suggestions.

We have several DTS connections (one for each company) that add records into TempFile. But when I created new DTS for a new company, no records are added. When I change the Destination file say, New Table, it works. Also, if I use an existing DTS but change the table name to that of the new...