Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Obtain quarterly records in Access with the DatePart function
- How did your company's stock fare last quarter? Who came aboard during the first quarter last year? Mary Ann Richardson shows how to use the DatePart function in Access to obtain quarterly results. IT managers often want to know data points about a particular quarter. If you need...
- Tags: Microsoft Access, DatePart, Microsoft Office, Databases, Mary Ann Richardson, Click New, cell, Microsoft Office Suite Access Tips Newsletter, Expression, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-04-25
- Month Name function problem in MS Access query
- I have a simple table containing order number, order date, cd number, cd title etc. I have imported 5000 records and need to analyse the data for trends. I need to create a query that will extract and list month names and the number of orders for each month. The...
- Tags: traceyae@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-03-25
- Help with SQL Query (Date ranges)
- I've been struggling with a SQL query and can't find a answer anywhere, although I've come kinda close. I need to pull a range of users by hire date BUT just the month and day. For example I want to pull all users who had a hire date...
- Tags: ADynes@..., DatePart
- Discussion threads 2007-07-11
- How do I... Retrieve a random set of records in Microsoft Access?
- We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. In this How do I... tutorial, Susan Sales Harkins explains how to use the random function in Microsoft Access to...
- Tags: Microsoft Access, Microsoft Corp., Record, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2007-10-11
- Performing a year comparison within SQL Server
- HelloI'm trying to do a comparison of a full date field to a year field using: min(SUBSTRING(CONVERT(CHAR,ISNULL(me.e_start,GETDATE),110),7,4)) "Start_Year"to convert the date field in to a year, I then want to compare this converted field to a current year view that I have created.e.g 19/06/2007 will convert to 2007me.start=(SELECT AC_YR from...
- Tags: server, Microsoft SQL Server, dcleary@..., DatePart
- Discussion threads 2007-06-19
- TechNet Webcast: SharePoint Server 2007 (Part 4 of 6): Compliance and Records Management (Level 200)
- This webcast looks at records management and the challenges it presents. It shows a review of the Enterprise Content Management ECM features in Microsoft Office SharePoint Server 2007, and how they address these challenges. It also examines how records management is made easier with SharePoint Server 2007. The attendee will...
- Tags: Microsoft Office SharePoint Server, Webcast, Microsoft SharePoint, Compliance, Microsoft Office SharePoint Server 2007, Microsoft TechNet, Records Management, Managerial Accounting, Finance
- Webcasts 2008-01-25
- passing adodb rst into an array
- can i pass a adodb rst into an array using vb code? if so how can i retrieve my rst from the array? thx!!Bit more infoBy rst I presume you mean recordset ?Do you want an array of recordsets.Do want want to access all the records or just the one...
- Tags: rst
- Q&A 2005-05-13
- Instant Payroll Totals for Quarterly Tax Reporting
- Accurate numbers are a must for filling out quarterly tax forms, but creating the various subtotals for state and federal forms can be time-consuming. Now users can get the information they need fast - thanks to the new list feature in Microsoft Office Excel 2003. Put the list feature to...
- Tags: Payroll, Taxes, Free Trade, Operational Accounting, Financial Planning, Finance
- Webcasts
- Introduction to the Records Center Site
- The Records Center site template in Microsoft Office SharePoint Server 2007 is designed to help organizations implement their records management and retention programs. The Records Center is intended to serve as a central repository in which an organization can store and manage all of its records. The Records Center supports...
- Tags: Records Center, Records Management, Managerial Accounting, Finance
- White papers
- Audit Firms and Data Security: A Case Study
- This case study describes the issue of data safety and availability of an audit firm. Audit firms maintain proper accounting records, prepare quarterly balance sheets and social security reports, and file regularly for taxes on behalf of their clients. The auditor's biggest concern is the safety of computer files containing...
- Tags: Accounting, Auditor, Audit, Data Security, Social Security, Operational Accounting, Financial Accounting, Financial Services, Government, Finance
- White papers 2007-01-01
- WebFill (exe)
- With WebFill you can make an automation script for any Internet form. Fill the Internet forms with your data records and submit them. Also scheduler function is included. It can help you to decide when the data records will be submitted by WebFill and how many data records you will...
- Tags: Form, Internet
- Software downloads 2005-12-22
- Kansas State Records Management Manual: State Records Center Procedures
- The Kansas State Records Center provides centralized, efficient, and secure storage for inactive and semi-active state government records. Authorized by the legislature in 1957 and funded in 1992, the State Records Center offers agencies controlled access to their records until administrative, fiscal, and legal retention requirements are met. There are...
- Tags: Agency, Record, Kansas State Records Center, Records Management, Advertising & Promotion, Managerial Accounting, Marketing, Finance
- White papers
- Report By Date range, Grouped into days
- I am creating a Stored Procedure to query between a given date range as follows:SELECT Ksnr as 'Cust No', Artnr as 'Intier No', count(*) as QuantityFROM JITWork_ArchivWHERE (NOT (Sequenznr LIKE '0%')) AND (Letzte_Prioritaet =...
- Tags: Dummy, DateTime
- Discussion threads 2005-09-13
- Combine Records in MS Access
- Greetings,I've created a database for my office, but it needs some improvement. For each record in my database, there is the AutoNumber ID, and there is a unique subject ID for each person in this database. Sometimes, individuals are entered more than once w/ different IDs, but a...
- Tags: Social Security, Storage, Databases, Operational accounting, n.smith326@..., Microsoft Access, Microsoft Corp., W/O, database
- Discussion threads 2007-09-07
- Destruction of Records . . . Your Legal Obligations!
- All organizations destroy records. Preferably, records are destroyed under a records retention program when they are no longer needed for any legal, user, historical or other purpose. Records are also destroyed after microfilming or scanning as part of an electronic imaging system. Courts expunge records to eliminate any traces of...
- Tags: Destruction, Record, Document Management, Enterprise Software, Software, Finance, Managerial Accounting
- White papers
- Family Finder - Genealogy Software (zip)
- Find Lost Family Members & Research Your Genealogy. Search millions of vital records (birth records, marriage records, death records, divorce records, property records, public records, court records) and more to find lost family members or friends in just a few clicks. YourSpyingEyes is a simple & powerful application that taps...
- Tags: Record, YourSpyingEyes, Government, Vertical Industries, Tools & Techniques, Enterprise Software, Software, Management
- Software downloads 2007-06-25
- How do i record holiday bookingsin a Microsoft access database???
- this is for my school project and i need to think of a way of recording bookings being made on different accomadation by different customers.This is what i know already i need a relational database with tables of customer details-House details and a bookings table but what fields should i...
- Tags: booking, e-mail, Microsoft Access, microsoft access database bookings, Microsoft Corp., off-topic, programming, project management, Supergilfrod@..., windows
- Discussion threads 2007-01-07
- Sequential numbering in Access 2007
- I am having a problem doing something in Access 2007 that I was always able to do in Access 2003. Let me give you an example. A simple table with three columns, one is the autonumbered column for each record, the second is a product name and the...
- Tags: Microsoft Office, Nothing, bwigton@..., Microsoft Access
- Discussion threads 2007-10-12
- Sequential numbering in Access 2007
- I am having a problem doing something in Access 2007 that I was always able to do in Access 2003. Let me give you an example. A simple table with three columns, one is the autonumbered column for each record, the second is a product name and the third we...
- Tags: Nothing, bwigton@..., Microsoft Access
- Discussion threads 2007-10-13
- << Previous
- page 1 of 1
- Next >>
