Search results

This could be from a number of things, I would have to see your database. Can you post a stripdown of you database. if not send direct to me,

Chester Here you are, this should fill your needs, hopefuly you do not have records prior to 1-1-1900. This will work with or without a datebeg or dateend >= IIf(IsNull([forms]![repdialog]![datebeg]),#1-1-1900#,[forms]![repdialog]![datebeg]) and <=...

Chester When choosing your date, will be a date range or a beg date and any end date

Which choises Fail?

Should Be: like IIf(IsNull([forms]![repdialog]![communities]),"*",[forms]![repdialog]![communities]) like IIf(IsNull([forms]![repdialog]![repname]),"*",[forms]![repdialog]![repname]) >= [forms]![repdialog]![datebeg] and <= [forms]![repdialog]![dateend] like...

Hmmm, Worked fine for me. What do you suppose happen? Would have to see another strip down, send to me direct.

Need more information You are telling us nothing.

What is the deciding factor as to whether these other pages (subReports) print or not.

Add two more text boxes to you report header same as what you have. Use the following as the Record Sources =IIf(([SomeThing])="Deposits",Count([Something]),0)) =IIf(([SomeThing])="Deposits",Sum([Amount]),0)) =IIf(([SomeThing])="Paid",Count([Something]),0))...

This web site may help, there are many free database models, some dealing in Real Estate. It should give you some ideas. http://www.databaseanswers.org/data_models/index.htm

Why do you want the Report it self to be editable. Report are a picture (so to speak) of data that has been edited.

Click the On Open Property of your Report this bring up a Form with three chooses, choose Code. When the Code window opens place this Code DoCmd.Maximize Do the same for the On Close Property except, use this Code DoCmd.Restore Hope this Helps

Well to filter for your Report only the Records with a value of "Yes" in a given Field is very very complex indeed :eek: , you might want to sit down :confused: , if you are not sitting. Just funning you :o , your answer is actually very simple. Add in the underlying Query of your Report the...

Try in the underlying Query Criteria of the Field that the combo box is filtering IIf(IsNull([Forms]![YourForm].[yourCombobox]),"*",[Forms]![yourForm].[your combobox])

billy Here is the SQL for your Query. Make a copy of your database name it something other the actual name. Then copy and paste to query in your database. SELECT Archive.ID, Archive.Type, Archive.Date, Archive.Client, Archive.Title, Archive.[#], Archive.Format, Archive.Length, Archive.Details...

A strip down is a copy of your database less than 100K in size. Post it on this thread so as I can see whats' going on with it.

Can you post a strip down of your database

Will you want to print the Page Header/Footer on any of the report pages or just not with the the Report Header/Footer. This can all be set from the Report Property Form In design view of your report, right mouse click on the box upper left corner of the report this will open a selection...

I think that you are confusing your computer, and its' trying like the devil to do want you want. Your JobNumber Control should be the only Control in this JobNumber GroupSection. Put your Notes Control in the DetailSection. To help any more would require details as to what to are trying to...

Place an unbound text box on you Report. Right mouse click the on the box Property form shows left click Data tab in the first field put =1 last field set your Running Sum This should get your started