Search results

One thing you can do that's super easy is to create a linked table and connect to one of the CSV files. You'll have to define data types, but then you can just query and append etc. Doing this manually sounds really painful. Post some sample data (doesn't have to be real... I don't want...

What do your CSV files look like (what's the structure?) How many files you do you need to import and how often? Assuming you have a "ModelParts" table that consists of (ModelNo, PartNo) at least and maybe some descriptive attributes (like Quantity), then your tables would be Model(ModelNo...

If you put that in Excel, you can unpivot it and you would end up with (ModelNo, PartNo), which would be useful. Then that's your junction table. Ideally, it would include a Quantity of each PartNo for each model, so it would be (ModelNo, PartNo, Quantity) Part #s have a UID, Part #...

How are Parts and Models related in the real world? A Model consists of one or more Parts? Model--(1,M)--ModelParts--(M,1)--Part Say the primary key of Model is ModelKey and it's a unique integer. And Part's Primary Key is PartKey. So, by definition, PartKey and ModelKey are both unique. Then...

"I wondered whether Power BI might make it easier to develop ad-hoc queries. However I expect it may not be any simple for an untrained Power BI user to extract and format data, any more than an unskilled Access user. Is that a fair summary?" Not quite sure how to put this. Comparing DAX and...

PowerBI is helpful for interactive graphs and visuals, which is something that Access has never been good at. PowerBI wouldn't replace Access/SQL Server, but would work with it. PowerBI is helpful for drilling into totals and seeing what makes them up etc. The kicker is that PowerBI doesn't use...

I guess it does work. TBH, I haven't seen ANY or SOME since 1999.

I'm sorry, I thought I answered your question. ANY is an Oracle keyword. AFAIK, doesn't exist in Access or SQL Server as a valid keyword. The logical equivalent is to use EXISTS and a correlated subquery. Sorry, TheDocMan's answer is on the mark. Totally missed it somehow.

The short answer to your question is that this is a variation of the "Students and Classes" database. I did one like you're describing like 25 years ago. You will save yourself a LOT of hassle if you find a template or whatever that does most of what you want. (Unless you really understand...

Transformed to equivalent statement without ANY. SELECT e1.empno, e1.sal FROM emp e1 WHERE NOT EXISTS (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 20 AND e1.sal <= e2.sal);

What are you trying to do? Tell us the question you're trying to answer. Are you trying to find all subscriptions without a Closure record? SELECT ... FROM Subscription s LEFT JOIN Closure c ON s.SubscriptionID = c.ClosureID WHERE c.ClosureID IS NULL? or likely easier... SELECT ... FROM...

Sounds like you can save yourself a lot of trouble by just starting with Duane's "At Your Survey" DB. Basically, your call is analogous to an interview (consists of many questions to a single person). Then just grade each question and average them. Or if it's a quiz model you want, I would...