rolfrobinson
Registered User.
- Local time
- Today, 20:58
- Joined
- May 29, 2003
- Messages
- 11
Hi Everybody I hope this is in the right Forum,
I have a database that I am writing at a company which has a huge I.T. Support, yet no one willing to help.
I am a beginner and I am using Access 97. I dont understand VB or how to program in SQL although I understand what it is doing I couldnt program with it (I can do the majority of things using the wizards and fumbling through until something works).
I have designed a report which runs from an unbound form (via a query.) It is selected via combo boxes (for Contractor) and List Boxes For Date.
1) Contractor
2) Date From:
3) Date To:
To Specify one contractor between x and y date is ok and works. But how do i select All Contractors between x and y date? If I leave the Contractor blank then all it does is show no results.
Also i have some figures which are used to calculate total items sent and received by Contractors between x and y dates.
How do i get a zero field when i run a query so it at least shows some kind of result even if it is zero. ( this is when there have been no items sent or received between 2 dates). I have tried using Nz( ,) from the access help on the Sql part of the sum query but I cant seem to get it to work.
Thanks In Advance for any help!!!!
I have a database that I am writing at a company which has a huge I.T. Support, yet no one willing to help.
I am a beginner and I am using Access 97. I dont understand VB or how to program in SQL although I understand what it is doing I couldnt program with it (I can do the majority of things using the wizards and fumbling through until something works).
I have designed a report which runs from an unbound form (via a query.) It is selected via combo boxes (for Contractor) and List Boxes For Date.
1) Contractor
2) Date From:
3) Date To:
To Specify one contractor between x and y date is ok and works. But how do i select All Contractors between x and y date? If I leave the Contractor blank then all it does is show no results.
Also i have some figures which are used to calculate total items sent and received by Contractors between x and y dates.
How do i get a zero field when i run a query so it at least shows some kind of result even if it is zero. ( this is when there have been no items sent or received between 2 dates). I have tried using Nz( ,) from the access help on the Sql part of the sum query but I cant seem to get it to work.
Thanks In Advance for any help!!!!
