Search results

Can i build an expression in a queary that give me a row count? i have a column named NAME, instead of looking at the bottom to see how many records i have i would like to have a column that has a count of the number of names i have, not like names, or different names,, just a count of the...

thanks it worked but with a twist. for some reason,,, it is showing more red than it should... must be something on my end... But thank you for the help..it is doing what i want just need to tweek it a little bit more

looking for the same (sort of) ok,, so on my report, if i have a date and if I want it to be the color red if it is less than todays date.... how would that look? how would I express this? thanks

thanks Thanks folks,,, worked like a champ!!!! Until next time....................:)

What its doing when i enter IIF(isnull([Expr19]),"Empty",[Expr19]) in criteria box of the queary... the result is, that if the feild is empty then the whole record dont show up at all..

I have my queary set up and one of the colums are date's,,,if i don't have a date for the colum i would a "word" to appear, like "emtpy" Can this be done? i was reading about the Nz function, and when i can get it to work then the whole queary comes out blank if i cant get it to work then i...

ok thanks Pat,,, will give this a whirl and get back for more help (hope not) << meaning,,, i can get it to work this time.... :D thanks for sticking with me

Yes Pat,,, Unless i am setting it up wrong,,, it isnt doing what i want it to do.. the vertical size is the problem,,,, thats why i was wanting it to "wrap" to two colums. this is what i have done to try the subreport: clicked the sub report tool button, dropped it on my report,,, when i...

Well It really didnt come out like i want....:( this is what i have: i have a queary set up.. now on the report that i have made i have a list box that shows the query contents for a report print out,,,,, now my queary has about 25 names in it. on the list box, i have to go in and edit the...

Thanks I will give that a whirl......I am a self learning Access-er

Hello all,, I have a list box on a report from a queary of name's,,,, my list of names in the list box is incomplete because the list is large. Any way to make the box 2 colums and have the list just wrap around???? name1 name6 name2 name7 name3 name8 name4 etc name5...

thanks :D

I guess I am thinking that i cant be done,, or maybe i am in the wrong forum to ask this question....???????

Hello all,,, just wondering if there was a way to incorporate an access queary or table into a word form? i would like to manufature a word form and then in spots have drop-down boxes with selections from a access queary to fill in the spots. is there a way to do this? or is it to painful...