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: *

  1. matthoward

    Last 7 days transactions query

    This is the sql without the command you gave me INSERT INTO lend_trans ( [Product Type], [Internal Account Nbr], [Txn sequence], [Transaction Date], [Transaction Time], [Transaction Display], [Value Date], [Posting Indicator], [Posting Reference], [Transaction Amount], [Txn Future Balance], [Txn...
  2. matthoward

    Last 7 days transactions query

    Also EUNBCD is the field that I tell it that I just want the Payment transactions coming down. Cheers
  3. matthoward

    Last 7 days transactions query

    EUCGD7 is the date field it appends the field in lend_trans called Transaction Date. Am I writing it out wrong and where should I be putting the Formula, Should I go under EUCGD7 or in the SQL or in the new field in the append query? Thanks again for your help, Cheers Matt
  4. matthoward

    Last 7 days transactions query

    Thank you for your help I am just a little lost still this is my SQL commands INSERT INTO lend_trans ( [Product Type], [Internal Account Nbr], [Txn sequence], [Transaction Date], [Transaction Time], [Transaction Display], [Value Date], [Posting Indicator], [Posting Reference], [Transaction...
  5. matthoward

    Last 7 days transactions query

    I must add that I want to run it daily for the last seven days not once a week for the last seven days, Thanks
  6. matthoward

    Last 7 days transactions query

    Good Afternoon. I have a date field in my append query. What I want to do is bring down information for the last 7 days only. I havde tried Last7Days which is a command I stole out of crystal but no luck. Does anyone have any ideas? Thanks Matt
  7. matthoward

    Grouping By Month

    thank you for ya help it worked perfectly. Cheers
  8. matthoward

    Grouping By Month

    Could anyone tell me how I can break a years worth of daily transactions down to a month by month grouping? For example 1/1/3 $4000 1/1/3 $6 15/1/3 $50 20/2/3 $560 28/2/3 $10 2/3/3 $57 23/3/3 $67 So I would have a grouping of Jan 4056 dollars Feb 570 dollars March 114 dollars Help as always...
  9. matthoward

    Selecting Todays ISO Date

    Good Afternoon, I need a selection criteria in a access append query to bring down just data for today off the AS400. I am also running it in ISO date format would that cause any problems Thanks In Advance Matt
  10. matthoward

    Counting Groups

    Is there a simple formula that tells you how many groups you have? For example I have a report with all the transactions of a particular account number. I want to do a count on that group so I can see how many customers(accounts) i have done business with lately, Cheers
  11. matthoward

    A Big Question

    Thank you, It half worked. I am using crystal reports 6. My problems seems to be after putting in the formula for grouping it just does not want to group that way. Am I missing a step because it just wont let me add a group by formula. Help As Always is Appreciated, Thanks Matt
  12. matthoward

    A Big Question

    Well I have a huge problem and no matter how I try to resolve it, it just wont solve itself. Outline of the problem How the report looks Account Number 123456 Name etc etc etc etc Loaded Payment Method Payment type 1 3time Payment type 2 2time Payment type 4 1time This report is grouped by...
  13. matthoward

    Query to Show Fields with particular content

    Wat is "select foo, bar, qux", Sorry for sounding dumb, Cheers Matt
  14. matthoward

    Query to Show Fields with particular content

    I am looking for a query which most people probably no the answer to but I am having a mental block on. I need to be able to run the query so it will bring up all records with the name "Trust" in the field. The other question is how do I do a query to exclude certain records that...
  15. matthoward

    Query to Show Fields with particular content

    I am looking for a query which most people probably no the answer to but I am having a mental block on. I need to be able to run the query so it will bring up all records with the name "Trust" in the field. The other question is how do I do a query to exclude certain records that...
  16. matthoward

    Pick One Field Or The Other

    The are all in the table I have called CLT001. Its list all my client information and in that I have the various Fields of Mailing Address and Postal address etc etc. Cheers Matt
  17. matthoward

    Pick One Field Or The Other

    Message to the Wise Ones. I have a access database with the following, Residential Address, Residential Address1, Residential Address2 and also Mailing Address, Mailing Address1, Mailing Address2, Mailing Address3. My big problem is that I have a number of customer who do not have a mailing...
  18. matthoward

    Group Totals

    In my access datatabase at the moment I have two fields. Transaction Type and Account Number. The account number just lists every ones account number but the Transaction type lists the type of payment for example C for Cheque D for Cash etc etc. So below is an example Account Number...
  19. matthoward

    Creating a Total Of Transactions

    Okay sorry guys I may not have made my self clear enough so here goes on attempt two. In my access datatabase at the moment I have two fields. Transaction Type and Account Number. The account number just lists every ones account number but the Transaction type lists the type of payment for...
  20. matthoward

    Creating a Total Of Transactions

    Good Morning, I need to find myself a way to do a total of transaction types for a three month period. I have a report were I have grouped by account numbers and it shows that for example in the three month period they have made 2 direct debits and 1 by cheque. I need to be able to in the group...

Part and Inventory Search

Back
Top