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 derfloh 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
  • Order by date
  1. GSINC

    Date criteria to compile past years quarterly spending

    I just renamed the fields so it would be more simple to understand. Here is the SQL: SELECT MEDI_GROUPDATA.GRPNO, Sum(MEDI_HSTTRAN!PRVPMT+MEDI_HSTTRAN!EEPMT) AS [Amount Sold], MEDI_GROUPDATA.NAME, MEDI_GROUPDATA.RENEWLDT FROM MEDI_GROUPDATA INNER JOIN MEDI_HSTTRAN ON MEDI_GROUPDATA.GRPNO =...
  2. 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...
  3. GSINC

    Grouping by Company and Month in one query??

    The problem with that is, each group has a different calender year one group might have a calender that runs June to June or September to September. So I needed a away to look at the amount spent by quarter based on each groups calender year. I am sure that a better way exsists to acheive...
  4. GSINC

    Grouping by Company and Month in one query??

    I already have code which works on the format that I am trying to acheive. Heres the code. Option Compare Database Dim cn As ADODB.Connection Dim rs, rs1, rs2, rsmnth, rsgen As Recordset Dim Mnth, Yr, Counter, calender As Integer Dim q1, q2, q3, q4, temp As String Private Sub...
  5. GSINC

    Grouping by Company and Month in one query??

    I have run it as a crosstab in the past however. I need to populate the results of that crosstab into a table. Is that possible???
  6. 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...
  7. GSINC

    Quarters by Non Calender Year

    The above code is for the original format that I layed in the beginning of the thread. Here is the refence table. ivalue Mnth 1 Actual Self Fund jan 2 Actual Self Fund feb 3 Actual Self Fund mar 4 Actual Self Fund apr 5 Actual Self Fund may 6 Actual Self Fund jun 7 Actual Self Fund jul 8...
  8. GSINC

    Quarters by Non Calender Year

    CHECK this code out. Using a month lookup table and this code its working. Some changes need to be made for 2005 and on but WOW! Option Compare Database Dim cn As ADODB.Connection Dim rs, rs1, rs2, rsmnth, rsgen As Recordset Dim Mnth, Yr, Counter, calender As Integer Dim q1, q2, q3, q4, temp...
  9. GSINC

    Quarters by Non Calender Year

    Okay, I think I understand the concept of the statment QUARTER = FLOOR((MONTH(DATECOL)-1)/3)+1 I am trying to apply it now. I have changed how I am compiling the amount spent by company so it now looks like this. Company amountspent checkdte renewaldt ABC 2115.12...
  10. GSINC

    Quarters by Non Calender Year

    Actually they are not I am pulling them from a check register, I put them into the table in that manner Mistake on my part. The companies have mutiple entries by date in the oracle table. Can you explain the statement above?
  11. GSINC

    Quarters by Non Calender Year

    Actually, I have compiled this contact table from other Oracle tables and imported them into Access into one table. The pertanant fields in the table are: Company Renewaldt properly formated date/time (1/1/2005 example) slffundjan04 slffundfeb04 slffundmar04 slffundapr04 slffundmay04...
  12. 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