Re: Refer to the first row of the table

In 76c9ea6dc6e2e@uwe">news:76c9ea6dc6e2e@uwe,
samotek via AccessMonster.com <u15330@uwe> wrote:
Thank you fo your reply. Your suggestion seems to me as a solution.I
get however the error "Too few parameters".What may be the reason ?

If you just copied my code, it could be because there's not actually any
field in your table named "WhenCreated". The code example I gave was
based on the idea that there is such a field in the table, containing
the date/time the record was created. If there's no such field in your
table, you have to either find a field that *is* in your table and is
suitable for sorting to find out which record is "first", and then
change the code to refer to that field, or else create such a field and
ensure that it is populated with the appropriate values.

If you think you did that, and you still got the error, then most likely
you misspelled the name of a field. As far as Access is concerned, any
name in a query that it doesn't recognize must be a parameter, so it
gives that error telling you that you didn't provide a value for it.
But really, it's more likely that it just didn't recognize the field
name because you spelled it wrong.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Export to Fixed Width File
    ... Export a query that is based on that table (don't export the table ... Ken Snell <MS ACCESS MVP> "Newbie" wrote in message ... For some reason the export routine creates a text file with the> following: ...
    (microsoft.public.access.gettingstarted)
  • Re: Problem with Update Query
    ... I tried putting "as Jan" in the update to: field of the query and it will not ... "John Spencer" wrote: ... Unless you specifically refer to the fields by the tablename.fieldname ... Access MVP 2002-2005, 2007 ...
    (microsoft.public.access.queries)
  • Re: Text Box Question
    ... order the list in the combo box's dropdown list by using a query as the ... <MS ACCESS MVP> ... > order, for some reason they are not in serial order, what can I do to ...
    (microsoft.public.access.gettingstarted)
  • Re: Using a query result in an expression
    ... You can retrieve the results of a query using a domain aggregate function ... MS Access MVP ... "Phil Hood" wrote in message ... > My question is how do I refer to this result and use it in ...
    (microsoft.public.access.queries)
  • Re: lookup of Excel to Access
    ... create a query that is sorted in the order you need. ... and your query can use an expression to refer ... Jeff Boyce ... <Access MVP> ...
    (microsoft.public.access.queries)