Search results for query: *

WHERE Date = #" & Format(Forms!BookingForm!Date,"mm/dd/yyyy") & "#.... Also Date is a reserved word in Access, if that is a field name in your db then you should change it

Look up the HasData method

save the record before opening the Report

You have to put the expression into the grid Expr1:Abs([MyField]) or as the control source for a text box on your report.

Look up the IsDate function

DateByMonth: Format$([TableNme].[DateField],"m yy")

Do the calculations on the form

Change the format on the property sheet to Yes/No

Use a report with the query as its record source.

Since the subform already has the records concerned you only need to Sum the relevant sales in the subform footer. ie.=Sum([Sales])

Have you compiled and saved all modules, compacted the db. Failing that try importing everything into a blank new db.

What is [Text] try Between ([Forms]![fAG_Articles]![txtStartDate]) _ And ([Forms]![fAG_Articles]![txtEndDate])))if you are trying to define the field as text then you have to define the parameters, which should be Date/Time

Why not just use an Autonumber?

Quintios Look up the HasContinued/WillContinue functions

Private Sub Collections_subform_Enter() If IsNull(Me.CustomerID) Then Beep MsgBox "There are no Customer details entered yet, please correct this" txtSurname.SetFocus End If End Sub

Store the exchange rate at the time of the purchase

Sum(Iif([option1]=True,1,0))

Why not just set the date field to short date, the only time UK dates cannot be used in queries is when using strSQL ,filters etc.

Look up the HasData method.

Article ID: Q121509