Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by womper

  1. womper

    Open a Form at last entry of table

    Thank You. I guess this goes into the sub routine that opened up when I created an event for On Open of the form I am using.
  2. womper

    Open a Form at last entry of table

    How do I open a form at the point where my user can just start to input data without having to go to the last entry of the table before starting? The only order of the table is that the date is in descending order. I don't want my user to unknowingly start typing over existing records in the table.
  3. womper

    multiple queries in one report

    Thanks folks. This was very helpful! Here is the actual code I used : SELECT A.PlayerID, A.DATE, A.SkillLevelPlayed, A.NumRounds, A.NumBalls, A.WinLoss, A.Split, A.NumSafeties, A.BreakandRuns FROM NineBallMatches AS A WHERE A.DATE IN ( SELECT TOP 5 [DATE] FROM NineBallMatches WHERE PlayerID =...
  4. womper

    multiple queries in one report

    My table looks like this : PlayerID Date Win/Loss Skill Balls Rounds Safeties 2 06/09/2005 1 8 76 12 2 126 06/04/2005 0 3 21 19 1 43 06/03/2005 1 5 42 21 0 sorted by Date, more info...
  5. womper

    multiple queries in one report

    I run a pool league. I have a large table of played matches. The table consists of PlayerID, Date, Win/Loss, Match Info........ The table is sorted by most recent date at top (ie. descending order) I want to create a report which includes the most recent 5 matches from every player. I can get...
See more

Part and Inventory Search

Back
Top