Search results for query: *

Using MS Access 2003, I am using Export to send data from three tables to an XML file. The three tables are joined on a common key. Is it possible to exclude a field from the XML file? I need the field used in the join to appear in the XML output in only one of the three tables. The XML for...

Yes, there is a workgroup being used in the existing security database.

Hello! I currently have an Access database that has user level security. I do not want to change any of the security settings in the existing database, but would like to make a copy of the database that does not have any user level security. Can anyone advise the best way to accomplish this...

Normally when my SAS program executes without error, a return code of 00 is returned. I am running my SAS program via JCL in a mainframe batch environment with Z/OS. Is there a way in the SAS program to set the return code to a different value, say 20. I'd like to do this so that subsequent...

Hello! I am attempting to do a simple concatenation of two variables in a Business Objects 6.5 WebIntelligence report. However, I am having trouble finding the concatenation function. Any help that anyone can provide would be greatly appreciated.

I have a Powerpoint presentation saved as a web page. When I open the web page thru Internet Explorer, some of the information on the righthand side of each slide is truncated. However, if I select the Full Screen view (PF11) in Internet Explorer, no information is truncated. Is there a way...

I am reading in a raw data file that is delimited by commas and quotes around text fields. My data looks like: "Smith",30,90,100,120,130,140,150,160,"Philadelphia" Most of the fields in the raw data file are not needed and I would like to SKIP the unused fields when...

I have an Access 2000 table with 80+ fields. When fields are selected for a query from this table, the user must scroll through the table to find the desired field. It would be much easier for the user to find the field(s) of interest if the field names were alphabetized in the pick list. Is...

When designing a query in Access 2000, is there a way to display, in the table box, the caption label for each field rather than the actual field name? My table includes field names that are hardly descriptive while the caption names accurately identify the field contents. When selecting...

I am trying to use PROC REPORT and have my TITLE lines centered and my FOOTNOTE lines left-justified. I have used OPTIONS=CENTER at the beginning of the PROC REPORT step. It seems like this controls both the titles and footnotes. Is there an easy way to tell SAS to center the titles BUT left...