Search results

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:

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

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

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

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