Search results for 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...

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

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

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

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

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

thank you for ya help it worked perfectly. Cheers

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

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

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

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

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

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

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

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

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

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

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

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

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