Recent content by Dimples

Query A identifies records from a table that do appear in another queries results. I want to query the results of Query A. How can I do this? I keep getting error messages. :confused:

Thanks for the suggestion, but that still did not work. I still am only get the ID numbers and it is making me crazy b/c the words that I want are showing up in design view. I just can seem to get around this. I cant even use the chart if I cant show what they stand for.

Really need help with legend Ok, now...my legend is showing incorrectly in design mode as well as preview mode. It is showing the IDs where I want it to show the words/titles. The words/titles are the key in the table as well as the bound column so I am not sure why it is displaying the...

Ok, so I finally got my chart/graph in my report the way I want and I was so excited. However, now my legend is not appearing right. The legend is showing ID numbers as opposed to the titles for each category. When I view the chart in design view it shows the words (what I want). but when I...

I have a report that is filtered by selections that a user makes in combo boxes on a form. The report works and everything is dandy. However.... This report shows a breakdown by location of individuals that were written up and the action that was taken in response to the policy violation. I...

I have a report which shows data that is filtered by user input for the 'group'. Then the data is grouped by date. Each record has a field called 'Action' associated with it. I want to add a pie chart at the beginning of the report which shows the breakdown of the different Actions that are...

1. The type of file is a pdf file. 2. I do have a control on my form named 'reportlink'. It shows whatever value is stored in the table for that record. 'reportlink' will be a differrent link/value for each record.

ok, I have links to documents(reportLink) stored as type text in a table (Investigations). Each link is different per record. I have a form that display information from this table. The field that holds the hyperlink is called reportLink on the form. On this form I would like to have a...

I have a document that is done in PDF that I want to be able to display within a form in my database. can this be done. How would I do this if it were a .doc file. I am assuming that I need to attach it to the records within my table but I am not sure the correct way to make this work. Any...

Ok, that didnt work. :eek: it is telling me the expression is either incorrect or too complex. Any ideas? TIA!

I want to put a box on a report that will display the items that are 30 over due. For instance the date of the item is stored in a table in a field called [DateofRecord]. so I want to count the records that a query for a report returns if the [DateofRecord]+30 > today AND if [Status]="In...

Thanks! Got it!! :o Nevermind. Got it! I was just being an idiot. I left a key word out. Thanks!!

Still Trouble in Paradise Thanks for the suggestion but that didnt seem to work. If I make a selection then it will pull records. However, if I make no selection then no records are pulled for the report. Any other ideas of what may be going on here?

I prompt users for different values and my report prints off what values the user chooses from the combo boxes. However, how do I get it to recognize that I want it to print ALL records for that category if the user doesnt select anything?

Ok, here is my question. I am just a little rusty since it has been a while since I have been in Access. So I have a option group: option 1, option 2, option 3 If option 1 is selected I want textbox 1 visible, but textbox 2 and 3 not visible. If option 2 is selected I want textbox 2...