Search results

You've probably got a Null used in the multiplication. Use a conditional If with an IsError, e.g. IIf(iserror(a*b,0,a*b)

And your question is?

Quite often multiple queries run faster than a single complex query. I'm a big fan, if it ain't broke and isn't glacially slow, don't fix it.

I recall that a report can be saved as a pdf.

It seems that you want 8 queries: 2 time intervals plus min, max, avg for each. The join those queries on time interval in a query to produce the desired columns you want.

Jdraw's solution is incorrect, that is, the SQL ORDER if incorrect, it should be "ORDER BY totsec DESC".

Queries run perfectly if constructed correctly. Improper joins or improper filters create unwanted and unexpected results.

The database has been corrupted, probably because of an abnormal termination or closing of the program.

Use the Format property of the textbox.

I don't think that the "In(..)" does anything for your. Merely query a query. That's lightning fast.

Use a linked table, possibly a list box, combo box or subform for multiple telephone numbers. It's not rocket science.

The requery is probably killing you change. Think about the data source of updated field is. Don't requery after the update.

It definitely in the Navigation Pane on the left side of the Access window.

Add the filter to which is SELECT is appropriate.

I don't think tjat your using the instruction correctly. Take a look at this.

Ordinarily subforms usually tumble wit a main form. What's the subform to display before the combo box row is selected? One method is to use the subform Filter and FilterOn properties be set of th combo box AfterUpdate event. What are you going to do on the subform, after the records are...

Sounds like you need to Requery the combo boxes.

You can't select the subreport after the report is opened except by using a blank subreport, the sourceobject of which is determined on the format {whatever} section the subreport is located. Alternativlely, have several reports, each with a different subreport and determine which t open.

Your SQL is wrong in syntax: Try DoCmd.OpenReport "R_APdailyplan2", acViewReport, , "tTaskDueDate <=#" & Date() & "#" Adjust the other SQL strings accordingly. Think about what the why with what I've displayed.

if me.[Clearance Date] < me.[loading Date] AND me.[loading Date] < me.[clearance date] then dates failed - do whatever else dates passed - do whatever end if It looks like you dates have a time component, if so use the Date function to clear the time component of the dates. Sorry...