Search results

Yes, it is possible!

Make subreports out of each of your 5 dates and put them on the report. I have done the same thing and for each of my subreports, I only show one day for instance, Monday and you don't have to link your report either. I hope this helps.

This is known bug in 2000, so go to tools/options/General and take the check mark off the Track name autocorrect info. Then go to your design of your report and file, Page setup and choose landscape, save and you should be ok :)

You can have one checkbox but you can make a table for your items and that field can be a dropdown list. So, when each customer is chosen out of the dropdown list, the item can be chosen and then putting the checkmark. I hope that helps :)

You can put Is Not Null in your query and just show the records that have values in them, then do what you where doing. That might help.

Maybe I should have given you an example: If you have two fields called [FirstName] and [LastName] you can combine them with a space in the middle in one text field like this: [FirstName] & " " & [LastName]

You need to concatinate. Go to search and just type concatinate and you will find how to combine text fields or use the help in the access :)

Go to design of your report and look under the Text Align properties of your text box. You should be able to justify your text box any way you want. As far as moving it anywhere in the actual report, you have to manully drag it where you want to. I hope this helps :)

You have to do this: =Count([YourTextBox]) I hope this helps:)

Then don't distribute! You can Left justify it and make your lable streach until the desired look you are looking for. You just have to play around with it to get it. Sometimes seporating your lables into several ones, and putting them excatly where you want them to be helps too. You have to...

Maybe I misunderstood you! On your lable you should be able to left, right and center justify. If you click on the actual field, you will be able to see what I am talking about. I hope this is helping. :(

Go to File and page setup and set your margins there in the design mode.

In your query put "Is Not Null" and it will show all the fields that are not empty:)

On your on open event of your report do this: Me.Visible = True

You can go to the properties of your field and use input mask to automatically do this (xxx) xxx-xxxx. As far as the extension the only thing I can think of is make a query and play around with it to seporate the #'s with the extension. :)

:cool: Thank you David, I thought I was going crazy:D I haven't tried that yet, but it sounds like it's going to work;) Thanks again

My form does not open. Instead of one dialog box which is my form it asks me two differnt questions. One is [Forms]![Report Date Range]![BeginningDate] , so I put the beginning and the other one [Forms]![Report Date Range]![EndngDate], which defeats the purpose of having the form!

Maybe I should explain this a little bit more! I have a button on my switchboard that the user clicks that it asks them two questions. One for beginning and the other for ending date. When they are done, a table is made out of the range they want and then they can look at their report based...

I have a form that the user can put the beginning and ending date for a report to show up. I was wondering if it is possible to use the same form to open up a make table query, instead of asking the user with two different dialog boxes. Thank you in advance

It seems to me that you need to create a many to many relationship between your tables. Sohaila