Re: DCount text and autonumber

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

CDbl did the trick. Thankx

-JS

"DevourU" <devouru@xxxxxxxxxxx> wrote in message
news:ggbcf.12089$q%.1064@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Never mind, format did the trick. Thankx
>
> -JS
>
> "DevourU" <devouru@xxxxxxxxxxx> wrote in message
> news:d%acf.12046$q%.2217@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Thankx for the help. It works, but listed ascending, it shows as text.
>> 1
>> 10
>> 100
>> 101
>> 102
>> etc
>>
>> I am trying to sequentially number records in a query and return record
>> numbers < [value supplied from form]
>>
>> -JS
>>
>> "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
>> news:%23wGpj0L5FHA.476@xxxxxxxxxxxxxxxxxxxxxxx
>>> Text and numbers (and Dates) are handled differently in expressions. You
>>> don't need the extra quotes for numbers.
>>> DCount("field1","QueryName","field1 <=" & [field1])
>>>
>>>
>>> --
>>> Duane Hookom
>>> MS Access MVP
>>> --
>>>
>>> "DevourU" <devouru@xxxxxxxxxxx> wrote in message
>>> news:cracf.12039$q%.5793@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>> DCount("field1","QueryName","field1 <='" & [field1] & "'") works fine
>>>> with a text field. What am I missing for an autonumber field? I get
>>>> data type mismatch error. TIA
>>>>
>>>> -JS
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: DCount text and autonumber
    ... Never mind, format did the trick. ... > Thankx for the help. ... It works, but listed ascending, it shows as text. ... What am I missing for an autonumber field? ...
    (microsoft.public.access.queries)
  • Re: Cannot insert/move/copy tabs
    ... thankx that did the trick ... I had to crack the password. ... I have no idea why someone would use a password on this sheet? ...
    (microsoft.public.excel)
  • Re: is it effective/better
    ... i dont know whether what i have written is an effective solution. ... thankx in advance ... (format t "~%"))) ... function to display a properly formatted triangle up to 20 rows. ...
    (comp.lang.lisp)
  • Re: DCount text and autonumber
    ... Thankx for the help. ... It works, but listed ascending, it shows as text. ... What am I missing for an autonumber field? ...
    (microsoft.public.access.queries)
  • Re: Picture changes when record changes
    ... Thankx once again ... I don't understand what you mean by "Problem with the format". ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (comp.databases.ms-access)