Search results

I believe that I have the jest of it. Taking for granted that you have created the Query "qry[YourReportName] Open this query in Design View, the query will open showing the pane and the grid. Place your pointer in one the top most grid cells. Press the Tab Key until you come to an emty cell...

Place Code in the On Open event of the Report To do your Sorting, Something like the following Private Sub Report_Open() If Forms!YourFormName!CheckBoxA = True Then Me.OrderBy = "ColumnA" Else If Forms!YourFormName!CheckBoxB = True Then Me.OrderBy = "ColumnB"...

When you send the report to excel it will look messy. Sending to Word will give you a view of your report with out any lines that you may have.

How you calculate your total cost Where do these other numbers come from, the 8, 7, 2

You could use in the OnOpen event property put this line of code DoCmd.Maximize and in OnClose event property this line DoCmd.restore The first will open the report in full view the second will close the report and restore your Form size. Just another way of doing

Be so kind as to understand that I can not see your database. And that I am trying help you with the problem that your are having. What I would do say to do just as a band aid job is to add a field to your Table make Yes/No field. Also add this field to your Form. If you manualy choose in...

Those controls that do have data will hold the space open What kind of report is it

For your check boxes =[Forms]![Sort].[NameOfCheckBox] the other four should be in this query

I take it that there is more then one section number

Yes Save your CrossTab Start a new query bring your crosstab into it, change query to make table query. and run it

Using the comboboxes what would you choose to make these records the ones' that you would Delete

What are the names of your comboboxes are they Named "Cortact" and "State" What is the Name of your From is it "Sort" Do the other criteria fields have anything in them.

What would you use to deside which records would go to the Temp Table

I'm reading to fast The way to Filter these Records that you want to Delete must be unique. Something that we can Filter on, to tell the query these Records and no others are to be Deleted.

What is the SystumLoc

We want to filter these records not sort, there is no need to sort something your going to Delete. With what you choose from these comboboxes what would make these records unigue.(Differant than the the record you want save.

Queries are you friends Try this: Select Query Select New The query window will pop up, and a little window box will be right in front of it. You'll see three Tabs "Table"; "Queries"; "Both". The one that is displayed is "Tables". You do not have any Queries so if you select the "Queries"...

If you had to choose manual which records to delete how would you choose them. I understand that you want to automate this. I just trying to get a better feel for what we are doing.

Just need a little more information NotBuilt: Status etc. etc. are these differant fields in your table(s) do they have 0 or -1. Are they in the same field. Where do these words come from. If they all answer 0 or -1, just use the Count Function. To use the Sum Function will add them up...

We'll take this a step a time For you first 3 parameter the ones' that are working In the criteria field of the query under "Contact"; "State"; "Industry" Like IIf(IsNull([Forms]![YourFormName].[Contact]),"*",[Forms]![YourFormName].[Contact]) Like...