Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 15747

Microsoft Access is a relational database management system that is part of the Microsoft Office suite.

2
votes
Rather than calculating the distance between two points on the fly, you can narrow your selection by approximation. Since we know that one degree of latitude is a nearly-constant 111km, a search for …
answered Jun 22 '14 by dartonw
2
votes
You shouldn't need to concatenate the fields at all. You can find out whether a customer has filled out the survey for a given month and year by using all 3 columns: SELECT * FROM Surveys WHERE Cus …
answered Sep 7 '14 by dartonw
3
votes
Access doesn't support the IF EXISTS syntax in queries; I think your error is coming from that. It's also very difficult to do any sort of procedural logic using Access SQL. Your alternatives are to r …
answered Apr 3 '15 by dartonw
1
vote
A common solution to this problem is composite keys or indices. You can specify any key or index as unique, so combining the PartNumber and ManufacturerID into a composite and then marking it as uniqu …
answered Jun 8 '14 by dartonw