Forespørgselskriterier

Er 8#00 et tal??

nej men hvad skal jeg bruge som joker

? og _

sorry selvfølgelig % og _

Så får jeg meldingen at det indtastede indeholder en ugyldig syntax

hmmm.... ja så må jeg være dig svar skyldig.....

try 8*00

and this is taken from Access help

About using wildcard characters to search for partial or matching values

You use wildcard characters as placeholders for other characters when you are specifying a value you want to find and you:

·    Know only part of the value.
·    Want to find values that start with a specific letter or match a certain pattern.

You can use the following characters in the Find and Replace dialog boxes, or in queries, commands, and expressions, to find such things as field values, records, or file names.

Character    Usage    Example
*    Matches any number of characters. It can be used as the first or last character in the character string.    wh* finds what, white, and why
?    Matches any single alphabetic character.    B?ll finds ball, bell, and bill
[ ]    Matches any single character within the brackets.    B[ae]ll finds ball and bell but not bill
!    Matches any character not in the brackets.    b[!ae]ll finds bill and bull but not bell
-    Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A).    b[a-c]d finds bad, bbd, and bcd
#    Matches any single numeric character.    1#3 finds 103, 113, 123
Notes 

·    Wildcard characters are meant to be used with text data types, although you can sometimes use them successfully with other data types, such as dates, if you don't change the Regional Settings properties for these data types.

·    When using wildcard characters to search for an asterisk (*), question mark (?), number sign (#), opening bracket ([), or hyphen (-), you must enclose the item you're searching for in brackets. For example, to search for a question mark, type [?] in the Find dialog box. If you're searching for a hyphen and other characters simultaneously, place the hyphen before or after all the other characters inside the brackets. (However, if you have an exclamation point (!) after the opening bracket, place the hyphen after the exclamation point.) If you're searching for an exclamation point (!) or closing bracket (]), you don't need to enclose it in brackets.

·    You can't search for the opening and closing brackets ([ ]) together because Microsoft Access interprets this combination as a zero-length string.
·    If you're searching for values in a table other than a Microsoft Access table, such as a Microsoft SQL Server table, you may need to use different wildcard characters. Check the documentation for that data source for more information.

Like "8*00"

Again - "*    Matches any number of characters. It can be used as the first or last character in the character string." i 8*00 er * anden character.

Så Like "8#00" er korrekt

hvad så hvis jeg nu skal søge efter et tal hvor det kun er et enkelt ciffer jeg er i tvivl om. * bruges jo til alle tegn før og efter. det vil sige at der ikke er nogen begrændsninger i antallet af cifre

ja men når jeg bruger # få jeg fejl

Så bruger du amerikaners bud.

ja men hvis jeg nu har flere cifre i feltet fx op til 1.000.000
og jeg søger på 8*00 får jeg et resultat med mange cifre fra 800.000 og nedefter

Det er da nogle store postnumre du bruger.

Hvis det kun er et enkelt ciffer, må opskriften være:
Like "8?00"
men det kræver jo, at dine postnumre er tekster. Du kan ikke umiddelbart søge med wildcard tegn midt i et tal.

fdata>> hvorfor? Den her sætning virke i Access 2.0 og op

SELECT DATA_TABLE.NR
FROM DATA_TABLE
WHERE (((DATA_TABLE.NR) Like "9#543"))

Returns:
NR
90543
91543
92543
93543
94543
95543
96543
osv.

"# Matches any SINGLE numeric character"- Billy McGates