Adding Data directly into External Databases
Posted On 31 Oct 2011 By a.p.r.pillai. Under Queries.
Back-End to Front-End database designs are common in MS-Access . Back-end can be MS-Access, dBase, SQL Server, Excel or Paradox databases with their linked Tables. Once the tables are linked ... Continue Reading
1 Comments
Dynamic Dlookup in Query Column
Posted On 28 Jul 2011 By a.p.r.pillai. Under Queries.
If we need only a single column value from a related table to incorporate into a Microsoft Access Query then we can use a DLookup() function to bring that value ... Continue Reading
No Comments
Change Query Top Values Property with VBA-2
Posted On 30 Jun 2011 By a.p.r.pillai. Under Queries.
Through last week’s introduction we have seen various ways the Top Value and other properties change the SQL string of a SELECT Query. Now we will learn how to redefine ... Continue Reading
No Comments
Change Query Top Values Property with VBA
Posted On 20 Jun 2011 By a.p.r.pillai. Under Queries.
We have learned how to use the Top Values Property of Queries (SELECT, MAKE-TABLE and APPEND Queries where this property is applicable) in an earlier Post. Before going through this ... Continue Reading
No Comments
TOP N RECORDS IN QUERY
Posted On 11 Mar 2011 By a.p.r.pillai. Under Queries.
We have seen the usage of different type of complicated Queries like Cross-Tab Union Queries for Charts, Union Query ... Continue Reading
1 Comments
Sub-Query in Query Column Expressions
Posted On 02 Jan 2011 By a.p.r.pillai. Under Queries.
Queries are the main data processing component of any database systems. Queries work behind the scene shaping the data into Reports and other form of outputs. Microsoft Access Users (mostly ... Continue Reading
No Comments
Memo field and data filtering
Posted On 31 Oct 2010 By a.p.r.pillai. Under Queries.
We design tables carefully to organize information properly so that we can retrieve them easily through search, filter etc. If you look at the Employees table in the Northwind.mdb sample ... Continue Reading
No Comments
Auto Numbering In Query Column
Posted On 04 Jan 2010 By a.p.r.pillai. Under Queries.
We know how to create an Auto-number Field in a Table to generate Unique Sequence numbers automatically for the records added to the Table. We know how to create Sequence Numbers for data lines on Reports.
8 Comments
Multiple Parameters For Query
Posted On 24 Oct 2008 By a.p.r.pillai. Under Queries.
Queries are an essential element in data processing and we use them a lot in various ways. While creating Queries the main issue we are faced with is how to ... Continue Reading
2 Comments
Selected List Box Items and Dynamic Query
Billing Department of Northwind Traders processes their Orders selectively for shipment of materials. An Order Selection Screen has been provided with a List Box on which they can highlight the ... Continue Reading
3 Comments
Finding Consecutive Workdays with Query
Posted On 17 Apr 2008 By a.p.r.pillai. Under Queries.
How do we determine that the date values within a certain date-range are consecutive or intermittent? To bring some clarity into this problem and solution I will present an example ... Continue Reading
No Comments
Filtering Data for different Users
Posted On 07 Mar 2008 By a.p.r.pillai. Under Queries.
In a Network based MS-Access Application several Users may involve in updating information into a common Master Table from different Locations or for different categories. When a particular User Logs ... Continue Reading
3 Comments
Crosstab Union Queries for Charts
Posted On 29 Feb 2008 By a.p.r.pillai. Under Queries.
For preparing Charts in Excel, the Source Data keyed directly into cells or source-data cells are linked into specific locations on the Worksheets where summary figures are available. The arrangement ... Continue Reading
No Comments
Union Query
Posted On 20 Feb 2008 By a.p.r.pillai. Under Queries.
Union Queries are useful for combining data from more than one Table or from other Queries while maintaining the original data physically separate.
Assume that the data Tables from different ... Continue Reading
3 Comments
Percentage on Total Query
Posted On 14 Feb 2008 By a.p.r.pillai. Under Queries.
Query Problem
How do we calculate percentage of individual value on each row based on Total Value of all rows?
Let us look into an example. Northwind Traders Customer-wise Order-wise Sales Figures ... Continue Reading
5 Comments
Download Free Software:Desktop Utilities, Mobile Communication, Games etc.
