Re: Use of Nz Function in Queries
- From: "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Jul 2005 22:11:24 -0400
Post the SQL statement of the query that you're using....
--
Ken Snell
<MS ACCESS MVP>
"Guayo" <guayo@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:10459F61-44F3-461B-893C-4AF79FBD3EA3@xxxxxxxxxxxxxxxx
> I'm constructing a Line Tendency Graphic in a Database of Access 2000,
> from a
> Crosstab Query with Columns showing Months of a year and File showing
> Costs
> ($) of the desired months with "between Initial and Final Date" criteria
> (Chort format). The problem is, the Line Tendency of the graphic doesn't
> shows the months with no records due to these desires months there weren't
> records to register; but I need the Tendency Line shows those as "0". I
> know
> the Nz Function solve my problem but I don't know how and where to insert
> it
> and what other conditions or controls properties do my database must has
> in
> order to get the response that I need.
> Guayo, requiring help from Osorno, Chile.
>
.
- Follow-Ups:
- Re: Use of Nz Function in Queries
- From: Guayo
- Re: Use of Nz Function in Queries
- From: Guayo
- Re: Use of Nz Function in Queries
- References:
- Use of Nz Function in Queries
- From: Guayo
- Use of Nz Function in Queries
- Prev by Date: Use of Nz Function in Queries
- Next by Date: Re: User Select Field
- Previous by thread: Use of Nz Function in Queries
- Next by thread: Re: Use of Nz Function in Queries
- Index(es):
Relevant Pages
|
Loading
