Recent content by kate007

Is it possible to conditionally suppress groups if the details section is blank? i.e., not have the group name come up at all. Thanks

yes, I am using 'or'. I wish I could modify the database, however, we have all our reports running off it (and hopefully we will be moving to a data warehouse situation soon..). Thanks.

Hi, I have inherited a highly denormalized ACCESS database where almost all information stored is in the one table - it's massive, almost all the other tables are look ups. Because muliple fields in this table relate to one particular look up table, when querying in design view I have to put...

when users do not enter a selection in a parameter field, the report does not return any data - is there a way of making it select everything if no criteria is entered?

I'm trying to create a union query, ACCESS accepts the sql, but when I try to run it a box asking me to select parameters for one of the tables comes up. Why would this happen and what does it mean?

None of the above two while loops doesn't worked either. Any other commands in unix to get the line as as whole into a variable Thanks a lot Kate

Hi, I have flat file with multiple lines as below ++++++++++++ file_name : test.txt This is a first row This is a second row This is a third row and soon ... ++++++++++++ Is there a way that i can get each line into a variable. I tried with foreach command but i am n't getting it and i'm using...