Recent content by mrssevans

anilvaghela I haven't ever found that can be done directly. Instead, consider one of these: 1) create a query that returns the information that would be in table+subdatasheet and export that. 2) create a (very simply laid out) report using a query like that in (1) as its source, grouped and...

A query is meant to take multiple tables and make them into one "table" if you will, so that might be why it is exporting as one table. Can you explain a little more what it is you are trying to do?

No, no data without the iif's either. There are no errors, but no data.

Thank you for trying to help. The database is too complex with linked tables, etc. I might try to setup a similiar one that isn't linked and post it. Thanks again

Thank you for the reply and the example. I can see how that would work and I have actually used that option before, however this situation seems to be a little more complicated for some reason. I would have to somehow use an iif statement because the information needs to match correspond to the...

Sorry, I was unclear From a subreport I have a text box with the mentioned iif statement. I don't get an error, but it doesn't find the information I am looking for either.

Referencing a Subreport I have searched through the forums, but have not found an instance of this yet. I apologize if i overlooked something. I have a very complicated report which is a main report that is unbound and 3 subreports in the detail section of the unbound main report. I am getting...

Thank you for the reply, but I have already tried that. In order to only have one label this option does not work. Thanks anyway.

I am trying to create a report that looks much like a spreadsheet. Such as this: Location1 Location2 Location3 label1:location1data...location2data...Location3data label2:location1data2...etc....etc They would like to only see the label once and the data in columns...

Thank you Pat. Right now I have them all set to text, but I will keep that in mind in case I make any changes. Thanks again

I am sure it won't have more than one, but your code looks like it is going to work great. I am going to give it a try right now. Thank you so much!!! ***That worked great.****

Thank you for the reply. Is there a better way to compare the two values in the table? There will never be more than 1 value in either table and they will either match or not. If they don't match I am going to run a batch file which I have setup and that works fine. This is my only problem area...

I have been working all morning to figure this out and I can't seem to find any information on it. I am trying to produce some code to check a query and see if it is empty. Here is what I am using: Option Compare Database Public Function VersionChk() DoCmd.OpenQuery "Version Qry" If...

I am sure this is a simple setup, but for the life of me I can't get it to work correctly. I have 7 pivot charts that I would like to display on one report for easy viewing. They don't have any parameters or anything fancy. Right now they are all displayed in one form, but when trying to print...

I have been working on this for about 2 days and I really need some help. I am using this following syntax in a form =DLookUp("[%DM]","[RATION INFO]","[YARD]= forms![BREAKEVEN FRM]![YARD] And [RATIONDATE]=Forms![BREAKEVEN FRM]![RATIONDATE]") and after I enter this I get an error that says...