Criteria selections 1

[ProtegeV2]

I am preparing a report based on a query. I would like the user to enter the invoice number so I have [Enter invoice number] in the criteria for that field. There are four digits in the invoice number, however some have extensions such as "####.1" and I would like to include them in the report. Is there a wildcard character or something that I can add to my criteria to include them in the series?

Thank you!

 

[Blorf]

Try like "" & [Enter invoice number] & "*"

in your criteria.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[Telumendil]

That is if you're with Access 2000, the wildcard character is something else in access 97, but I can't remember what...

 

[Blorf]

Are you sure? Seems that I remember always using the *, even in 97.

Course, that was eons ago...

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[Telumendil]

No, not sure, but I've read something about this somewhere not so long ago...
I'll check that tomorrow, I'm not at wor today...


Have a nice day...

 

[Telumendil]

No, you're right, it was already "*" in 97, sorry...

 

[lespaul]

but you use % when using other SQL flavors! (TSQL and others)

Leslie

 

[Telumendil]

That's it... I there was a difference, but I couldn't remember where...

Thanks Leslie...

 

[ProtegeV2]

Thank you, that's what I needed to know!

 

[Blorf]

Glad to help.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert