my question is, is it possible to leave the fields blank while making a crosstab query.. cause it doesnt work for me... am i supposed to do it differently???
I have a huge problem... I have a form that produces report when pressing certain action reports... the report is based on a crosstab... the thing is.. when i leave a field blank in my table the report wont open correctly... i dont understand what the problem is? am i supposed do do something else?
this is probably a very easy one but i just started today with sql programming.. the thing i wanted to ask is how to set the same values in a column with one simple command...
for example
name grade
anna 5
donna 5
albert 5
in this example... if i know that they all have...
hi everyone... i need to ask something.. is there a way to put three crosstab querys together.. lets say ive a crosstab query that look something like this
risk class severity class
I II III IV
a 2 1 2 3
b 8...
hi everyone... im new at this but can someone tell me how i am supposed to write this code. It complains on this row:
Me!Risker = Me!hiddenEnvi_Risk_Class And Me!hiddenPro_Risk_Class
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim Re As DAO.Recordset
Dim ReSum As...
hello everyone
this is the code behind my report, the only thing that i want to do is to sum the IDs that pop up ..
Private bContinuedSection As Boolean, sLastHeaderKey As Variant
Private Function IsContinuedSection() As Boolean
IsContinuedSection = bContinuedSection
End Function
Private Sub...
hi everyone...
ive made a crosstab query that looks something like this:
Sweden Germany Denmark
A 4 2 0
B 3
C 5 1 6
D 2 2
i have a table with countries, cities, population and...
hi.. i was wondering if anyone could look at my reportgenerator and tell me whats the problem with the code ... im trying to filter some stuf but it doesnt work.. its a report generator made in access
hi can anybody tell me what i am supposed to do if I dont want duplicates in my combo box. I dont want it to write the number twice when its already there...
thx
i have created four pages... u recieve a report through three of the pages... now i want the first page to add all the three report from the other three pages to one... is this possible?
i dont know what im doing wrong.. i have a form that will print out a report after choosing options in the combo boxes... then my filtering code is like this:
Option Compare Database ' Use database order for string comparisons '
Option Explicit
Global RapString
Sub...
this is not a hard one... but since im new i dont know how...
ive created a crosstab query, and i want the totals to be shown side by side... how can i do this...
1 2 3 4
a
b
c
d
Totals bla bla bla bla <---
I would like to do as follow.... first i want to create an array and print it out on a report... the thing is that i want the same values to be printed out on the same place with a , between... like this
salesman programmer author
Anna 1,2 3
Bella 4...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.