New answers tagged

0

You will need three variables or objects if building in a language like c# to specify what you are searching for based on your check boxes. Select * From Pets Where (CatChecked = 1 And 1Cat = 1) Or (DogChecked = 1 And Dog = 1) Or (FishChecked = 1 And Fish = 1)


0

Is this for a school project? I'm going to assume it's for work but typically on this site everyone is very happy to help but I would suggest you add how you feel the query should look like, and ask where you're having an issue. This way you'll get everyone involved and there's less likely of a chance to get your answer closed just to keep the site's ...


0

I have one workaround going which is making a seperate query for each 1:n-relation which connects DNS and SUM(foo) and one query which has the results of all the queries. Then in the little ERM for the query I connect every DNS entry of the queries. For 1:1 relations in the DB I can just use the standard table in the overallQuery. still looking for other ...


0

Assuming your queries are against regular Access tables, you should be able to replace the Access tables with Linked Tables to your SQL Server. The Linked SQL tables have to have the same names and structure to in order for this to work. I don't have the 2008 version of Access so I can't give exact instructions but look in the menus for something like ...


2

Sounds likes you would be best served by using another Query, not a Table. In Access you can use a Query much like a Table, even use a saved Query as a source in another Query. If you are careful you can create an Editable Query, in which changes you make to the Query results directly affect the Base Table. It can be tricky to do so when you have more ...


0

Taken from the MSDN page: Omits data based on entire duplicate records, not just duplicate fields. For example, you could create a query that joins the Customers and Orders tables on the CustomerID field. The Customers table contains no duplicate CustomerID fields, but the Orders table does because each customer can have many orders. The following SQL ...



Top 50 recent answers are included