Search results

I use Access 2007 I run a Madden online league (Nintendo Wii) I am stuck on how to run a query or report that calculates STANDINGS and I think my Tables might be set up wrong. Here are examples of 3 games played: bdhobbs1 (Colts) 24 at Zygon (Cowboys) 34 - Feb 25th at 2:15pm salomii...

I run a Madden online league (Nintendo Wii) I am stuck on how to run a query or report that calculates STANDINGS. W - L - PCT - GB - PF - PA - DIV WL - CONF WL W - Wins L - Losses PCT - Winning Percentage GB - Games Behind PF - Points Scored PA - Points Allowed DIV WL - Divisional Games Won...

I am making a mailing list in Excel to send letters advertising my new business. I copied and pasted data from Yahoo Business Listings onto an Excel Spreadsheet. The problem is this, I now have several hundreds of lines of data and I need to move certain data over to the correct columns. A...

My wife and her boss, a Phd Nurse Practitioner were meeting this afternoon in her office. Her boss got up to leave and after her boss left her office; my wife found her boss' paycheck stub lying on the floor under the chair her boss had been sitting in, the stub was from last September 2006...

We just upgraded to Access 2003 and I am creating a new database and in my Form... I was trying to set the REQUIRED FIELD PROPERTY to YES, but when I click the Properties of each field, it's not listed. Has this been removed?

I have a query and I need the records to display 3 working days before the 15 working day deadline. I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead. <=DateAdd("w",-12,Date()) Can...

I searched the forums and I couldn't find my answer. Here is situation: For example: We receive an appeal 10/1/06, the State mandates that we complete the Appeal in 45 calendar days. We send the Appeal to claims for handling and sometimes they don't reply back in time and we get fined. So, I...

I already have IE 7.0 and I want to go back to using IE 6.0 -- but when I try to download IE 6.0, I get a message that the newer version is already installed and the download stops. How can I override this? I know IE is not the best, it's for the wife's computer. I use Firefox on my PC and...

I would like to know if there's a way to import data from a website page into Excel. And put the data in the correct columns and rows. This would help save me lots of data entry time. In Excel I tried using the Import External Data under DATA and the data I wanted was not selectable from the...

I have a question about returning values from another cell. Example: There are 4 columns (G, H, I and J) that contain a number between 1 and 8. Then there are 8 columns for each of those 8 numbers, columns K through R. What I do is if 1 is contained in G, H, I or J - I indicate F in column K...

I need help with a required field that has different character lengths. I have an input mask that covers the first 7 characters, however, the users are still entering the incorrect policy numbers, I need to put a stop to it. I have 3 different policy number lengths involved, 7, 8 and 9. They...

When applicable, I have letters in Word already set up to show the cc: information at the bottom. However, Management needs a statement added to the bottom of the letters that ONLY show the cc: I am having a slight problem trying to figure out how to make this statement show up only on certain...

Is there a way to create a field (Table or Query) that contains the Month and Date only and not the year?

I need a query that calculates a date that is the first of the month following a specific date. Example: The first of the month following the 65th birthday. Is there any way this can be done?

I am designing a new database for our life and disability department and they have several different policies where the base life insurance reduces at certain ages. Please take a look at the scenarios listed below and give me any suggestions and tips on the best way to get this done. If you...

We have a report that is generated monthly to management on Excel. We Export the data from an Access query to Excel and at that time the user has to update the Month Reported and Year Reported fields on each record within that query. Can I set up something to where the user can click a button...

I have a form where the users need to update an option group when they enter any information on the form. The problem is that the users don't always update this option group. The option group does not have a default value and has only two options. When the user updates a form they need to...

I have a form set up where user's type in an explanation of how a claim is being appealed and resolved in a memo field. One problem, for some reason management doesn't want these explanations to end with a period. But the users keep ignoring our request and keep using the period. Is there a...

I have a form where users fill in a date resolved and click complete in the Option Group, it's default value is incomplete. I have a problem with the users forgetting to change it to complete when the enter the date resolved. Is there a way to change the option group value when the date resolved...

I have multiple users entering data on bound forms. I have three required fields, all in the first 3 fields of the form. My question is, can I program something to where Access will update the record, after the 3rd required field, so that other users are not having to wait to enter there new record?