Microsoft Access UNION and UNION ALL

Posted on January 6, 2016October 26, 2016 by Wyman W

This Access tutorial explains how to use UNION and UNION ALL in Access Query. You may also want to read: Excel VBA Union Method UNION and UNION ALL in Access UNION and UNION ALL are used to combine two Query results vertically into one Query, therefore both Queries require to have the same number of fields and same data types. When two Queries are combined, there could be rows of record that are exactly the same (duplicates). UNION removes all duplicates while UNION does not remove an...

Run Access Macro using RunCode

Posted on January 2, 2016September 16, 2017 by Wyman W

This Access tutorial explain how to run Access Macro using RunCode. You may also want to read: Run Excel Macro from Access VBA Run Access Macro Assume that you have already written a Sub Procedure helloWorld(). To run the Macro, you can press ALT+F11 and run the Procedure by pressing F5. Alternatively, go back to the Access Windows, double click on the Module on the left hand side and run the Procedure by pressing F5. If you are writing a Macro for users, they pro...

Add Auto number in Access Query

Posted on January 2, 2016September 21, 2017 by Wyman W

This Access tutorial explains how to add auto number in Access Query using Access VBA Function. You may also want to read: Sort Data in Access Report Add sorting in Access Table field Add Auto number in Access Table In Microsoft Access, go to Design View of a Table and define the Data Type of a field as AutoNumber Go to data view of the Table, each row of data is assigned a sequence number in ascending order. However, we cannot add the AutoNumber Data Type in Q...

SPSS Select Cases (filter data)

Posted on October 21, 2015October 21, 2015 by Wyman W

This SPSS tutorial explains how to filter data using Select Cases Function. SPSS Select Cases (filter data) In Excel, you can apply Autofilter and enter criteria to select data what you want. SPSS has similar function but it is called "Select Cases". In this tutorial, we will talk about the options are available to facilitate data filtering. Navigate to Data > Select Cases There are several options in this Select Cases box. We will talk about each option in the below sec...

SPSS Import Text File

Posted on October 2, 2015 by Wyman W

This SPSS tutorial explains how to import text file into SPSS. SPSS Import Text File Navigate to File > Open > Data Select Text in Files of Type, and then select the target text file Step 1 Does your text file match a predefined format? Leave the option default as No if this is the first time you import this file. Select Yes if you have previously saved the format in your last import. Step 2 How are your variables arranged? Wh...

SPSS define variables in Variable View

Posted on September 9, 2015 by Wyman W

This SPSS tutorial explains how to define variables in Variable View. You may also want to read: Types of data in statistics (Interval, Nominal, Ordinal) SPSS - Variable View In SPSS, understanding the Variable View is the first step before using any analytic functions. The purpose of Variable View is to define variables. In Excel, you don't have to define whether a column is number, date, or text, because Excel guesses the data type for you but of course it could be wrong in some cas...

Access VBA DoCmd.TransferSpreadSheet Method

Posted on July 20, 2015August 28, 2017 by Wyman W

This Access tutorial explains how to use DoCmd.TransferSpreadSheet Method to export and import files. You may also want to read: Access VBA DoCmd.OutputTo Method Access VBA auto generate mass report by group to Excel Access Export all Queries to Excel Syntax of DoCmd.TransferSpreadSheet Method TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA) Name Required/Optional Description TransferType Optional The type of transfe...

Access VBA DoCmd.OutputTo Method

Posted on July 19, 2015February 5, 2017 by Wyman W

This Access tutorial explains how to use DoCmd.OutputTo Method and DoCmd.TransferSpreadSheet Method to export different objects to specific file types, for example, export Query to xlsx. You may also want to read: Access VBA auto generate mass report by group to Excel Access VBA DoCmd.TransferSpreadSheet Method Access Export all Queries to Excel Syntax of DoCmd.OutputTo Method DoCmd.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding, Output...

Access VBA auto generate mass report by group to Excel

Posted on July 19, 2015January 9, 2016 by Wyman W

This Access tutorial explains how to auto generate mass report by group, for example, auto generate reports by different department and then export to Excel. You may also want to read: Access VBA DoCmd.OutputTo Method Access VBA DoCmd.TransferSpreadSheet Method Access Export all Queries to Excel Access VBA auto generate mass report by group to Excel Assume that we have a staff list of 1000 employees in 20 departments, our goal is to export 20 staff list to Excel, one department for...

Peoplesoft HCM Business Unit, SetID, TableSet

Posted on July 16, 2015August 8, 2015 by Wyman W

This Peoplesoft HCM tutorial explains Business Unit, SetID, TableSet. Peoplesoft HCM Business Unit, SetID, TableSet SetID If you look at the Table fields through Query Manager, you will find many Peoplesoft Tables contain SetID field. Tables that have SetID field include Location, Jobcode, Department, Salary Admin Plan, Employee Class, etc. SetID is a grouping for Business Unit in order to restrict or grant access to data within a table. If SetID contains only one Business Unit, the SetID ...