Search results

That works! Tahnks!! That worked like a charm!!. Thanks!!!:D

Unsure about the properties aspect of the reply I am not certain that I understand your reply so I request a clarification. I am unsure as to what property you are referring to. A report when made on a cross tab query has columns which are created based on certain categories within that...

I have created a reprt based on a crosstab query where the query totals the values within a certain field. So effectively that field becomes the column heading. The problem is that if there is one field missing ina table that I am analyzing, the report gives me an error saying that the...

I have a field with a TEXT format like 1/12/1999. I would like to conver it to date format. Is there anyway of doing this??

Can be done thru chart properties Thanks. You can also add more fields thru the chart properties box. I relaized that with some research and a lot of fiddling around!;)

I am using the chart wizard for presenting datamy on the reports. I have more than six fields (maximum about 14 fields) but the chart wizard allws me to choose only 6 fields. Is there any way I could have more than six fields on my charts. I can go into the chart properties and add more...

I cannot do that because the last query from which the report is pulled does not have the centre field. The reports are also a bit complex because they involve calculations of percentages for rows headings and column headings for two sub groups within each. For some reports I had to cross tab...

I am using the following: Main table (filtering it with a macro) From filtered Main table------>Query1 From Query1------->Query2 From query2------->Final Report So you are saying the above doesnt work?

I Have done that done that. The question basically is that if I filter the table and run the query pulled from the filtered table will the Query only work for the filtered records. From what I can see it seems that the query disregards any filters on the table. Is there any way for the...

With the database that I am working, there are no key fields. There are certain fields which may be coded as either a "Yes" or left blank. What I am trying to do is add all the "Yes"s for the different fields by making queries and compile it into a report. There are some reports which require...

I am creating a macro to run a Delete Query and I want to use the SendKeys instruction to automatically choose "Yes" when the pop uu box warns me that it will delete some records permanently. Coul danyone tell me how this can be done or what should I type in the Keystrokes which will process...

The problem is that when I designed the structure I did not include the field "Centre" for the queries. But cant this work if I query on a filtered data base. I tried to add "Centre" in the queries with some frighteneing results (which included subgrouping in the Final Report). Thanks.

Details of problem I will try to explain the problem the best I can here. I am running a report from data imported from a textfile. The report actually runs from a query based on the imported table. The sequence of events is like this: From the main table -----> Query1 From Query1-------->...

I am trying to query on a filtered table. The final query is based on another query and that other query is based on the filtered table. However when I run the the query it runs it for the unfiltered table. How can the query run only for the filtered records in the table?:confused:

Thanks a lot!! Thanks a lot!!! You made my day!!!! That was frighteneing!:D

For the start up properties of my data base I had unchecked all the menu and tool bar views. Now when I start the database I cannot get access to my reports queries and all the other stuff that I have been working on. All I get is the form that I had programmed to show. How do I get rid of...

I am very new to Access and now am facing a problem with Macros. I have created a report from a query. The query is based on another query and this other query is based on the main table. I want to run the report based on filtered data from the main table. However, I dont want the the main...

Thank you Pat. I am not very familiar with access but your response leads me on to something which I will research and learn as to exactly how it can be done. Thanks again.:)

How do I link a second query to a report? Thank you for the reply. I have already made most of the reports which have pretty involved calculated fields. If I make a different query just for the group totals how do I also link the new query to the same report? I can't seem to find a way to...

I am trying to create this report which is grouped by "Que" and then within "Que" it is grouped by "Acct Type" (report is extracted from a Query and looks something like this as an example). Toy Que A 8 B 10 Food Que A 15...