Re: Table with only the last record

In addition to my question I guess that i should build a make table
query that contains only the last order.To this end i have tried to
build the following function:
Public Function Alan()
Dim SQL As String
SQL = "SELECT * INTO orders1 FROM orders WHERE orders1.orderid =
DMax(orderid,orders)"
CurrentDb.Execute SQL
End Function

However i get the error "too few parameters".Where am i wrong and i can
i do in that way ?

.

Relevant Pages

  • Re: Filtering "A" An" "The"
    ... Public Function TrimArticle(ByVal strInput As String) As String ... and a query ... ... GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.forms)
  • Re: combining multiple address fields into 1 address field
    ... Public Function AddrLines(ParamArray adLine()) As String ... understand how I should create a module or how to write the SELECT query. ...
    (comp.databases.ms-access)
  • Re: Datatable
    ... Public Function GetRecordSet(ByVal query As String, ByVal tab As String) As DataTable ... Public Function ExecuteQueryAs DataTable ... Dim myConnection As SqlConnection = New SqlConnection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Question Re: InStr or other function
    ... Public Function countWords(strToLookIn As String, strToFind As String) ... Unfortunately, my PC crashed and I cannot find the query that I used, so I ...
    (microsoft.public.access.queries)
  • Re: creating a compound iff statement...
    ... >>> Is it possible to create a compound IF Statement in Access Query? ... Switch and (in a public function) Select Case. ... Enter SomeName in the Name box. ... Public Function SomeName(StringIn as string) as String ...
    (microsoft.public.access.queries)
Loading