Re: displaying two query results together
- From: Harry <Harry@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Sep 2006 16:16:01 -0700
I created a command button to create a billing report for all customers so
that is taken care of. I attached the two text boxes to a table DATESORT. I
just need to configure each query to use the last saved date entries in the
DATESORT table as the Between parameters for the Date Added column in my
query. Of course, I might have to go back to Unbound text boxes but I believe
this could be a viable alternative. I’m continuing to work on it.
"Harry" wrote:
For Smartin: Each customer has only one protocol..
For John Vinson: Thanks for helping with the date display issue. Below is
the exact code I have been using for “high-speed” customers.
SELECT [CLIENT TOTAL].Mailbox, [CLIENT TOTAL].Customer, [CLIENT
TOTAL].[CustID-DLB#], [CLIENT TOTAL].[Category-ID], [CLIENT
TOTAL].[Billing-ID], [CLIENT TOTAL].Fee, [CLIENT TOTAL].Currency, [CLIENT
TOTAL].[Date Added]
FROM [CLIENT TOTAL]
WHERE ((([CLIENT TOTAL].Fee)>0) AND (([CLIENT TOTAL].[Primary
Protocol])<>"Async" Or ([CLIENT TOTAL].[Primary Protocol])="Bisync" Or
([CLIENT TOTAL].[Primary Protocol])="SNA"))
ORDER BY [CLIENT TOTAL].Mailbox;
The “dial-up” customers query is exactly the same except there is an “equal
to” symbol in place of the “not equal to” symbol.
Now comes the sorting by the date they became a customer (for billing
purposes). I created a small form (SORT DATE) with two unbound text boxes.
SortDateA (default value is Date()) and SortDateB (default value is
#11/4/2005#). 11/4/2005 is when we got our first customer. So I want to be
able to create a billing report for that time period or anywhere in between.
According to your example, this is how the date code would be written (?)
=[Forms]![SORT DATE]![SortDateA]
=[Forms]![SORT DATE]![SortDateB]
Please help me join these bits of code to the main body of the query. I have
tried and I get prompted to Enter Parameter Values labeled: [Forms]![SORT
DATE]![SortDateA] and =[Forms]![SORT DATE]![SortDateB]
Also, when I enter the values in the SORT DATE form, is it enough to just
save the form and exit? Will the queries respond to those values that I enter
when I run the queries?
"John Vinson" wrote:
On Tue, 12 Sep 2006 17:06:01 -0700, Harry
<Harry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Great idea! I'm working on that. However, I am trying to set up one of my
time period fields with a default value of 11/1/2005. I am trying to do this
in the properties of the (unbound) text box. I keep getting a default value
of 12/30/1899 displayed in the text box. I have tried a number of
combinations but I end up with the same result. What is going on?
It's dividing 11 by 1, and that result by 2005; this gives
0.005486284289276, which corresponds to #12/30/1899 00:07:54#.
Try setting the default value to #11/1/2005# to get November 1. The #
indicates a date value.
John W. Vinson[MVP]
- References:
- Re: displaying two query results together
- From: John Vinson
- Re: displaying two query results together
- Prev by Date: RE: Exporting query to XL is truncating field data
- Next by Date: Re: How do I take the differnet dates
- Previous by thread: Re: displaying two query results together
- Next by thread: Re: DateDiff Time
- Index(es):
Relevant Pages
|
