Search results

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

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]) + ", " +...