Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
-6
votes
1answer
737 views
How do I convert this Access query for SQL Server? [closed]
I have a Query used in Access which does not work in SQL Server as it stands:
SELECT
mstPatient.PatientID,
mstPatient.PatientID AS PKNO,
...
2
votes
5answers
335 views
SQL Query with ODBC, Joins and Group Bys
I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
2
votes
2answers
746 views
Ms-Access 2007-2010 SQL - from single row record how to create multiple rows
I need help in below table updation using SQL in Ms-Access 2007-2010 database.
I've a table called table1 which has below entries:
table1:
--------------------------------------------------
| col1 ...
1
vote
2answers
450 views
Model a family tree database in Access 2007
I designed my database with the intention of implementing it with MySQL, but have now decided to implement it in Access 2007 using form and subforms. While creating my UML diagram, I realised I have ...
