Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access query criteria
Name: Mark Pratt Date: June 5, 2003 at 14:47:19 Pacific OS: Windows 2000 CPU/Ram: p4 2.5g 512mb
Comment:
I am trying to setup a query that prompts the user with a dialog box that will accept text for the search, and then return all entries that contain any portion of that text.
On the criteria line of the Select Query box I try and enter the following: * [Enter search:] *
Access reformats that to: Like "*" And [Search For Name] And Like "*"
Can someone offer a tip? I am brand new to access, as may be obvious with the question.
Summary: Hello, I am working on a program in access and am stumped how I do this particular calculation. I have two tables i'm working with: 1) Sheet1 - has all the information about my files (airwaybills like...
Summary: your example kinda confuses me. But I can tell you how to write queries. MSAccess and well as any database that can be accessed via ODBC (Object Database Connectivity) can be queries via TSQL (Transa...
Summary: Hi friends ... i have to solve the following queries in ACCESS...can u please help me solving these...i am not into IT background but i HAVE to do this for my assignment...Please For GODS SAKE,,,help!...