Recent content by bdhtexas

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...

Here are examples of 3 games played: bdhobbs1 (Colts) 24 at Zygon (Cowboys) 34 - Feb 25th at 2:15pm salomii (Jaguars) 35 at MJALLDAY (Jets) 38 - Feb 27th at 3:00pm dearnest (Titans) 28 at pete36z (Eagles) 10 - Feb 28th at 11:00pm Members can choose one of 32 teams (parenthesis) to use in an...

Here are the fields on my form: My structure may be off and that may be the problem, if so let me know and I will fix it. Season - a number representing what season the game was played in, 1, 2, 3, etc Type - what type of game was it, tournament, league, etc Week - a number representing what...

ok, I will try to be more specific... What I am trying to do is create a query that is like Standings: PLAYER NAME - WINS - LOSSES - PF - PA I would be happy with just that, but anything else is just a plus. Thanks

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...

I ended up adding a code to check all the required fields before updating, it's working nicely. Thanks!

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?

What if I have a Working Day Table that lists only the Working Days and no holidays? How would I code the query to show only the records that are 15 working days or more from today?

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 still can't figure this out... here's what I tried DateAdd("d",[Tech Unit Database Table]![Complaint Date/Rcvd]+[State]![Calendar Days])

OKay, I already have a table with the State and the number of days pertaining to each. What if I already have a TEXT BOX on my form that displays the number of days for the State? Example: Jim House CA 45days sent to claims 11/1/06. All this info is on my form and I just need a due date of...

I am just not understanding how I can do that. Example: California is 15 calendar days Arizona is 30 calendar days Virginia is 60 calendar days Can the date add function grab the # of days needed to figure the due date based on that number being contained in a field of it's own and based on...

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...