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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GSINC
  • Content: Threads
  • Order by date
  1. GSINC

    Date criteria to compile past years quarterly spending

    Hi Guys, Table1 contains the following fields: Name CompanyID SignUpDate Joined by CompanyID Table two contains the following fields: CompID AmountSold1 AmountSold2 DateSold I am trying to calculate the amount spent the previous year by quarters based on the SignUpDate. SELECT...
  2. GSINC

    Grouping by Company and Month in one query??

    I am trying to get the amount that each group has spent on a monthly basis but also grouped on the GRPNO. This is how I am currently getting the information below. SELECT CLAIMS.GRPNO, Sum([CLAIMS]![PRVPMT]+[CLAIMS]![EEPMT]) AS [AMOUNT] FROM CLAIMS WHERE (((CLAIMS.PDDT) Between 1-1-2004 And...
  3. GSINC

    Quarters by Non Calender Year

    I am not a VB Coder but am rather familar with the query abilities of Access built in Query Designer. In my contacts table I have how much each company has spent per month. Each of these companies have renewal dates throughout the year. I am tring to determine how much each of the companies...

Part and Inventory Search

Back
Top