Union query or Outer Joins do not create desired results

I'm using Access-2000 and creating query/queries to pull together financial data (budget & actual) to produce the following in a subform as well as a report. parm (form input): fiscal_year & fiscal_month budget actual YTD ...

Message posted on the October 26th, 2009 - 1:01 PM ET

Automatically inputting results

Hey I was hoping to find some help with a problem I'm having. I've created a database in Access 2003 to input results that were gathered from surveys that have been collected and want to be able to have several fields have a "null" result ...

Message posted on the July 31st, 2009 - 09:29 am ET

Goal Seek returning different results

I am using Goal Seek to determine an interest rate for an investment stream that returns a zero. The investment is irrgular in amount but the period is annual for each transaction. My problem is I am getting different answers depending on the ...

Message posted on the June 15th, 2009 - 12:14 pm ET

Deleting specific records based on query results

Is there a way to use a select query to find and then delete specific records in a database. My database records basic applicant information in one table (tblApplicants) and any interview data in another (TblActivities). I need to do an annual ...

Message posted on the December 14th, 2009 - 03:10 pm ET

Query sorting challenge; how to get a mix of ascending & descending.

I have a list of files/folders that sorts in a normal style, in alphabetical order, in the style of these example folders here: ABCs of Filing Annual Report - 2006 Annual Report - 2007 Annual Report - 2008 Annual Report - 2009 Business Continuity ...

Message posted on the August 10th, 2009 - 12:42 pm ET

Xbox Live makes Microsoft $1 billion in revenue

http://articles.sfgate.com/2010-07-08/business/21942038_1_xbox-project-premium-service-san-francisco Xbox Live makes Microsoft $1 billion in revenue July 08, 2010|By Dina Bass, Bloomberg News Microsoft Corp.'s Xbox Live online video game service ...

Message posted on the July 12th, 2010 - 05:21 pm ET

Transposing data

Hello, I wasn't sure which group in Access to post this to, so I'm starting here... My user would like to take her data in the table below and have it display as indicated in her query results below. Can anyone give us some suggestions on how to ...

Message posted on the July 15th, 2009 - 09:04 am ET

Report from 2 tables

Hi Just wanted to get some advice before I attempt to make a report that will use 2 tables as source material. Basically, my database stores information on a sport. One table is a list of teams and their historical venues/successes etc The second ...

Message posted on the May 10th, 2010 - 09:42 am ET

Fractal Shape Changing Robots

Fractal Shape Changing Robots Copyright (C) J. Michael 1994-1997 Background And C.V. portrait of Joe Michael Joe Michael Mobile Phone: (UK) +44 836 70 39 45 E-mail: joe@stellar.demon.co.uk Background Hi! I'm the author of the fractal shape ...

Message posted on the February 22nd, 2012 - 04:44 am ET

Expression using Iif with dates

The following expression results in an error telling me that I may have entered an operand without an operator. What ami I missing? Iif ([Certification Frequency] = “Annual”, DateAdd (“yyyy”, 1, Certification Date]), Iif ...

Message posted on the April 20th, 2010 - 11:31 am ET

Data in columns convert to single line

A spreadsheet exports like this for a huge population of employees' benefit elections: EE# BEN TYPE BEN PLAN $per EE $ per company ANNUL SAL COV AMT 1 MED MEDA $1500 $3000 $50000 1 DEN ...

Message posted on the December 18th, 2009 - 09:53 am ET

Transpose data in a report-Field values broken down to separate co

Hello, I started this question in the queries group, and someone suggested using a report, however, after trying a lot of various things, I can't figure out how to display the data as needed. Here is the need: My user has table data as follows: ...

Message posted on the July 23rd, 2009 - 04:07 pm ET

Act! 2010 to Outlook 2007 calendar integration

General Info: I am using Windows XP Media Center Edition, SP3 I have onboard Microsoft Office Professional 2007 My Question: Recently I purchased Act! 2010 for my CRM needs. I was also encouraged to purchase: The Official Act! by Sage QuickStudy ...

Message posted on the February 16th, 2010 - 08:51 am ET

Samsung breaks own record, sells over 300 million mobile handsets in 2011

Samsung breaks own record, Samsung says sells over 300 million mobile handsets in 2011. [quote] (Reuters) - Samsung Electronics Co. Ltd said on Sunday its annual mobile handset sales this year had exceeded 300 million units for the first time in ...

Message posted on the December 12th, 2011 - 10:12 am ET

		Advanced search
In

results annual