Hi
Is there any method to make a fixed format in a report. Following are my
tables and fields
Table1:Ordertypes
OrdTypeID(Autonumber)
OrdtypeName(Text)
Table2:dailyorders
SL # ( Autonumber)
Customer Name(Text)
Order Date ( Date/Time)
Order Type ( Text )There are 16 types of orders.These are maintained in
Ordertypes table
Report Output: Total No of order types received in a given date range
I need to keep the order type as the fixed format, I am extracting
the report from a Query(based on dailyorders table) with a criteria in the date
field ( Date
range:From and TO ). In present report it gives only the records that
falls in to the given date range. I need all the order types to be
shown always in the report. If no orders received in the given date
range it should show ZERO or else the total number of orders received
in the given date range.
How to do this , somebody in this group provided a code, but it did not give
the result what i am looking for.Please help.
Thanks
---------------------------------
Start your day with Yahoo! - make it your home page
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h0ve2dl/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122845295/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
