crosstab query
in [Queries]
|
Prev: Building/Storing a passthrough:How to assign connection string andmake passthrough
Next: Negative Figures In A Query
From: John on 20 Apr 2010 19:38 I have a crosstab query for a two year period. How can I get it to return a zero value if there is no incidents for that year. I want to ensure I have all the locations even if nothing happened.
From: Duane Hookom on 20 Apr 2010 20:50 Hint: maybe tell us something about: 1) your tables and fields 2) your data 3) the SQL view of your query -- Duane Hookom MS Access MVP "John" <John(a)discussions.microsoft.com> wrote in message news:F83AB31C-DF18-4F0C-855D-E393AA3CE0FB(a)microsoft.com... > I have a crosstab query for a two year period. How can I get it to return > a > zero value if there is no incidents for that year. I want to ensure I have > all the locations even if nothing happened.
From: John on 21 Apr 2010 12:05 I have several buildings listed in my query to find out if there were any crime at those buildings, however I was trying to show the buildings even if there were no crimes. "Duane Hookom" wrote: > Hint: maybe tell us something about: > 1) your tables and fields > 2) your data > 3) the SQL view of your query > > > -- > Duane Hookom > MS Access MVP > > > "John" <John(a)discussions.microsoft.com> wrote in message > news:F83AB31C-DF18-4F0C-855D-E393AA3CE0FB(a)microsoft.com... > > I have a crosstab query for a two year period. How can I get it to return > > a > > zero value if there is no incidents for that year. I want to ensure I have > > all the locations even if nothing happened. >
From: Duane Hookom on 21 Apr 2010 20:20
Hint: maybe tell us something about: 1) your tables and fields 2) your data 3) the SQL view of your query -- Duane Hookom MS Access MVP "John" <John(a)discussions.microsoft.com> wrote in message news:7F7B3963-D188-43CB-896E-DE75F39C7DF7(a)microsoft.com... > I have several buildings listed in my query to find out if there were any > crime at those buildings, however I was trying to show the buildings even > if > there were no crimes. > > "Duane Hookom" wrote: > >> Hint: maybe tell us something about: >> 1) your tables and fields >> 2) your data >> 3) the SQL view of your query >> >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "John" <John(a)discussions.microsoft.com> wrote in message >> news:F83AB31C-DF18-4F0C-855D-E393AA3CE0FB(a)microsoft.com... >> > I have a crosstab query for a two year period. How can I get it to >> > return >> > a >> > zero value if there is no incidents for that year. I want to ensure I >> > have >> > all the locations even if nothing happened. >> |