Recent content by ChristyG

I'm not sure if this is a Query problem or a Report problem, so I'm putting it in the General catagory. If I need to post it in one of the others, please point me the right direction. I have set up the following: Query A - Combines data from several tables Query B - Prompts for a text string...

I am having difficulty putting an image into my reports. I have created a calculated field in a query that creates the path to the image file. The image file is a jpg, but the extension is .0011. The path is being created correctly. However, the picture does not display. If I take the...

I just realized that I made the assumption that Age is defined as an integer. It is coming from a table in SQLServer that I didn't create. Guess I was wrong. It is a text field. I just changed my query to handle it as such and it is now working. Thanks again for the Help. I think it made me...

Thanks for the input, but that got me #Error also. Any other ideas? Christy

I am trying to enter an experssion into the grid for age groups. The result will be a text value based on the value in a column named Age. There are three groups, '<18', '18-30', and '31+'. I tried using the following but the result that is returned is #Error. age_grp...

Thanks for the info, but it didn't fix the error I'm getting. Same results as when I used the + instead of the &. The error message says: Undefined function 'Trim' in expression. Anyone have any other ideas?

I have used the Trim function in a query and am getting an error. At first I was concatanating several fields but have cut it back to the most basic form but still receive the error. The error says that the trim expression failed. Here is the code I used: fullname: trim([last]) + ", " +...