Search results for query: *

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?

that was my next issue... thx for the tip ;)

thx alot

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...

i dont get it... do you want to hide roch on the report? or in the query... cause if you want to do that on the report its easy ??

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...

thanks alot.. that was the best tip

hmmm i havent looked anything at the code .. but the error right now is type mismatch... Me!Risker = Me!hiddenEnvi_Risk_Class And Me!hiddenPro_Risk_Class 'Probable error - "aaa" AND "'bbb" or 123 AND 456 = 72?

all of this is shown in a report that in the end looks something like this Risk class ID TOTAL Frequency a 14,18 2 1 b 1,2,3,4 4 256 c 7,8,10 3 2 d 12,13,14 3 54 now.. like i said.. it works...

okej.. i will try to explain it better... if i choose only one field like this Set Re = CurrentDb.OpenRecordset("SELECT Pro_Risk_Class, HazardID FROM tblHazard Where Pro_Risk_Class ='" & Me!hiddenPro_Risk_Class & "' ORDER BY HazardID") Risk = "" it works...

ive tried both of yer examples but it still doesnt work... it complains on this row... Set Rs = CurrentDb.OpenRecordset("SELECT Pro_Risk_Class, Envi_Risk_Class, HazardID FROM tblHazard Where Pro_Risk_Class ='" & Rs!hiddenPro_Risk_Class & "' AND Envi_Risk_Class ='" &...

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...

tty0.. i meant i got it to work.. so thx vbkris... hmmm that was a strange one.. message boxes popping up giving me strange values and then nothing on the report :)

thx.. it was nothing.. like i said i was blinde ;) thx for ya time

thx... i cheated and made the sums in a subreport... cause i have to have them that way... thx for your time

list seperator or ) either im stupid or blinde

i dont understand where the compiling error is

hmmm it seems right but its complaining on that.. it wont work :/

but i want to keep the ids.. and just add another box that prints out total...? how am i supposed to do then