Recent content by russanalyst

Thanks so much! Russ

Hi. Thanks for the response. Unfortunately, the chain of command does not allow me direct access to the group that set the specs. One final question for you is what makes a NULL ? Russ

Hi. This might sound stupid but it is a real issue for us. In our datafile some fields' values were updated to " " . A government entity wants the value to be blank, instead. How do I change this? Likewise, there are some instances where the reverse is true. How do I change those? Russ

1st, thanks for responding, both of you. It is probably me bueing 'burned' or just 'dense'. I am missing how to set up the form. Can I upload one of the queries so you can see what I have? Russ

Hi. I have numerous queries each based on a different table. With the same parameter, although each table has difefernt fields. Currently the user has to enter the parameter multiple times. I do NOT need the user to modify, add, or change adta. Simply to see existing data. How? Please be...

Hi. I inherited some un-normalized tables and need some help. I have 20 tables each with an ID field and a dozen text fields, each containing unique values. I need the user to be able to enter the requested ID and the requested value which could exist in any of the fields in any of the tables...

Thank you for your response. - And these tables were 'inherited'. Anyway, i ha dnot mentioned taht I have approx. 20 tables to do this for. I had hoped to us ea maina nd then sub-reports. Is there another way, than what you suggested, to avoid having to do the manual coding for 20x13=260...

Hi. I have a query which looks in a table having 13 fileds. One field is a client ID, the others contain text. I need to have the user enter the ID and then the value that they seek in a given field. And, have only the ID and that one field with that specific value show. I made a query with...

Hi. Thanks. I will try it out. Russ

Hi. How do I convert number fields (double with 2 decimal places and with data) to text fields maintaining the actual numbers after the decimal point. Please be specific. Thanks! Russ

Hi. I really need to convert fields with currency data into text values AND still keep the decimal point and the numbers after it. Russ

Thank you so much! Russ

Hi. I believe that I have found a way to solve a problem in a much faster manner than I thought possible. But I need some coding help. I have a table with a field called 4/2006 which contains a text string of numbers. How can I code a query that will add '4/2006 -' to each record's 4/2006...

Thanks, so very much for the response. I will check the link. I totally agree with any and all comments regarding the structure of these tables. Unfortunately, not really my choice. Thanks again. Russ

Hi, folks. Sorry to come back on this same topic, but an agency programmer was asked to help me with this project. However, he said you folks who responded are wrong. (How dare he!) He said there are far easier and better ways to search for values by the name of the field. Yet he did not offer...