Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Microsoft Office 2007 Access Queries

22 Oct 2011   #1
DrToxic

Micro$oft Windows 7 Ultimate x64
 
 
Microsoft Office 2007 Access Queries

Hello. I am writing an Access Database which will hold a lot of information about software, books and whatever else I am going to store in there. (Yes, Data entry will take a long time, but not a problem).

I have made a query which will search the Books database for Author, and I was wondering how I can make it a little less accurate. Too weird? let me explain.

So far, It searches for the author using Exact Matching from the input box in the query
Code:
[Search for author by the name of:]
for example, when I want to search for Phillip Pullman, the way that Calibre added the author names, I have to type (Exactly, letter for letter) "Pullman, Philip". Is it possible to make it less accurate so It will bring back results when I search for "Philip" or "pullman" or "philip pullman"?


Thanks in advance,
DrToxic


My System SpecsSystem Spec
.

22 Oct 2011   #2
bbinnard

Win7-64
 
 

Yes, you can do this. The key is to use the * or ? character to represent, respectively, any character string or any single character. Put these in the Criteria part of the query and you should be able to get what you want. For example

Like "b???" will get all names that are 4 letters long and the begin with b

Like "bea*" will get all names of any length that start with bea

Here is the actual SQL query code for a query that works:

SELECT [Non-GrantParticipants].Last
FROM [Non-GrantParticipants]
WHERE ((([Non-GrantParticipants].Last) Like "b???"));
My System SpecsSystem Spec
23 Oct 2011   #3
DrToxic

Micro$oft Windows 7 Ultimate x64
 
 

ah, thank you bbinnard.

Noob question alert!: Where would I put the SQL in M$ access '07?
My System SpecsSystem Spec
.


Reply

 Microsoft Office 2007 Access Queries




Thread Tools





Similar help and support threads
Thread Forum
Microsoft office 2007 updates?
I want to know what happen with the Microsoft Office 2007 updates , after install Microsoft office 2010 ?
Windows Updates & Activation
Microsoft Office Outlook 2007 problem when using Microsoft Office
:sleepy:When I sent a message and when I was using Microsoft Office Outlook 2003, I had an option that enabled me to add a photo following or preceding my text. This option enabled me to put a photo in the text area and place text under or above the photo explaining the photo. I am now running...
Microsoft Office
Is Windows 7 64-bit able to run Microsoft Office 2007?
Hi, My current machine is running Windows XP SP3 with Microsoft Office Small Business 2007. I am wanting to upgrade my operating system however I would like to know if the Microsoft Office Small Business 2007 is able to run in a Windows 7 64 Bit operating system. I've also included the specs of...
Microsoft Office
Microsoft office 2007
I have MS office 2007, and I wanted reinstall from ultimate to professional plus. After that on desktop appeared nameless folder, and I can't delete it. How I must delete that folder? It's right-click menu contains only cut, create shortcut and delete. When I press delete, it says: "Are you sure...
Microsoft Office
Microsoft office 2007 problem
My problem Please help me
Microsoft Office
Microsoft Office 2007 License
I've got the Home & Student edition of Office 2007 which allows installation on 3 computers. I've only installed it on 2 so far but on one of them I've done a clean install of windows since the installation and then reinstalled office. I was wondering if this will be counted as 3...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App