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

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

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

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

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

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

Hey, Does anyone have an idea on how to create two totals on one field? My situation is that I have a field that contains negative and positive values and I want to do a total of the negative and a total of the positive. for example New Motors Ltd -$100 Motor Cars Ltd $300 Crash Bang Motors $125...

Hey, Does anyone have an idea on how to create two totals on one field? My situation is that I have a field that contains negative and positive values and I want to do a total of the negative and a total of the positive. for example New Motors Ltd -$100 Motor Cars Ltd $300 Crash Bang Motors $125...