Search results

If you do this it will work. Format([Date],"mmmm dd\,yyyy") Sohaila

In the control source of your text box on your report put this: =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy") Sohaila

Remember when you split your database, you are completely working with 2 different databases. One has all of your tables and the other one has all of your forms, queries, macros, etc. So, you have to find out what name you chose when you split your database. If you can't remember, go to tools...

I have a report that runs Quarterly and is based on a crosstab query. I have some calculations that are related to the month of January, February and March. I don't want to creat 4 seporate report for each quater. Is it possible to use the same report and try to hide the first 3 months and...

Do this instead: Format([Date],"mmmm dd\,yyyy") and see if it works. Sohaila

Use CrossTab Queries

Put a text box on the actual report in the control source: =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy") Sohaila

Why do you have "=" everywhere? I got rid of the = sign in your code, maybe it will work for you. =IIf([LINE_ITM_UOM]="ME",[LINE_ITM_QTY_ORDRD]*1.094*2/3000,[LINE_ITM_QTY_ORDRD]*2/3000) Sohaila

Put this code on a text box on your report: =Format([Enter Begining Date:],"mm/dd/yy") & " through " & Format([Enter Ending Date:],"mm/dd/yy") This code should take care of the beginning and ending date. Now if you want to show every single day, the best way I know is to make subreports just...

Go to File, Page setup and choose landscape! Sohaila

Open up your report in design view and click the sorting and grouping button. Choose the field you want to be sorted from your list of fields and your filed will be sorted the way you want! Sohaila

I had the same problem, but it took me a while to figure it out. There might be easier ways to do this! First make a "Make table query" and call it "Dynamic Data", out of the information that you want. Then make 2 crosstab queries out of your Dynamic Data for each of the values that you...

I have already done that, the part that I don't know is how do I reference that to my main report. I thought subreports work individually and I know that I can show my data by linking my subreports with parent and child. Anyway, could you elaborate! Thank you Sohaila

Thank you for your response, I am hoping to solve this today! It is the total count of the record that I want. I have Driver Numbers that are associated to Bill of Lading numbers. For instance, the driver number 100 did 45 jobs(Bill of Lading Numbers) in a period of 3 months. What I want is...

Is it possible to lookup a value from a subreport and use the value for calculating other fields on the actual report? Thank you in advance for your help, Sohaila

Set the Can Shrink property of your text box to true Sohaila

Check this place out http://www.mvps.org/access/reports/rpt0008.htm Sohaila

If you want it to appear on your report, this is how you do it: You have to put this in a control source of a text Box =Format([Enter Begining Date:],"mm/dd/yy") & " through " & Format([Enter Ending Date:],"mm/dd/yy") Sohaila

This is how you do it in the query: Between [Enter Beginning Date:] And [Enter Ending Date] I hope this is what you wanted! Sohaila

Thanks jack, That seems to work, I will give it a try. Sohaila