Tagged Questions
0
votes
1answer
31 views
Get Maximum Value
I am using MS Access database. I have a table (Proposal) with the following properties:
ProposalID - PK, Title, RequestedAmount, ResearcherID - FK
I want to run an SQL query to get the candidate that ...
0
votes
0answers
14 views
Performance Slow After CompactRepair Access
I am performing a large number of insert operations using VBA - Access. the VBA code is in a file "control.accdb" performing operations on "data.accdb"
Few tables in the process are created from the ...
0
votes
0answers
55 views
How to update column value in MS-Access by comparing two columns?
I have an Access 2000 table with 10 fields. I want to compare the 2 column and update the third one.
To elaborate :
keyfield cno entno uno
(Text) (Text) (int) (int)
...
0
votes
2answers
46 views
How to write a script to push the server time to out?
Background:
I am programming a database in Ms-Access and using SQL-server as the Back-end. But since my database will be a multi-user platform I need to make sure that whenever a user is posting data ...
1
vote
3answers
152 views
Database Design Relationship for Patient Visit in MS Access
I am designing a database to store records for research purposes, and I am having trouble picturing how I can create a relational database based on the information I have.
There are a total of 6 ...
1
vote
1answer
73 views
Database Relational Design for Multiple Categories
I am building a database for participants who are grouped into studies. There's a total of 5 different studies - A, B, C, D, and E. The participants may be in more than one studies, and participants ...
0
votes
1answer
78 views
MS ACCESS: sql query not showing results expected [closed]
I'm having a little problem.
In my Access DB, I have a table named customers.
In this table I have a field DateEntered that is set to short text data type.
I am trying to run a query to pull all ...
1
vote
1answer
64 views
What is a proper way to handle a “sequence number” like field?
The fields of a trimmed-down version of a database I'm working with looks like this:
Model Number, Model Name, Customer, Date, SeqNum
The customer can purchase the exact same item on the same date ...
3
votes
1answer
316 views
Removing duplicates from a query with conditions in Access 2007
I have a table of transactions with 880,095 records that I am querying.
There are duplicate Transaction ID's in the table that I would like hidden/removed when querying the table.
Eg 1.
...
2
votes
1answer
1k views
Joining 3 tables using SQL Query?
I'm having problems joining three tables. It works well when I use the same query for joining two tables (after removing LEFT OUTER JOIN C ON B.No = C.No). However, it doesn't work when I use three ...
0
votes
1answer
420 views
Access query to select multiple records with matching field
I have a table with a list of people ([FirstName], [Surname], [Age]). Some of these people are in the same family. I'd like to return a list of people who have another family member in the table (same ...
0
votes
0answers
28 views
Duplicate Customer Records for SQL Query from ODBC with Joins and Group Bys [duplicate]
Possible Duplicate:
SQL Query with ODBC, Joins and Group Bys
I am getting duplicate customer records with the query below. The main purpose of the query is to pull a list of customers into ...
2
votes
5answers
324 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 ...
3
votes
1answer
208 views
How can I conditionally summarize multiple rows in Microsoft Access?
I have a table of data, in Microsoft Access 2003, listing multiple rows for each person.
I want to conditionally summarize a subset of these rows for each person, for instance, if entry for columnA = ...
1
vote
1answer
290 views
Unable to add records to query in Access 2007
I've found this excellent resource that covers why a query might be read-only. I have a query that is not read only, yet I'm unable to add new records to it.
There are three tables. Let's call them ...
0
votes
1answer
461 views
Access 2007 sql editor
Is there an ACCESS 2007 JET SQL editor or client (not sure the right term is) that can be used to code Access Jet SQL queries? It is very difficult to write SQL queries in ACCESS 2007 since it's like ...
0
votes
1answer
242 views
Select DISTINCT records with extra information
I have a MS Access database full of customer names and addresses. I want to send out a mailing but only one per address. Therefore if there are 3 different customers at the address I want only one ...
0
votes
2answers
372 views
Is it possible to join derived tables to actual in Access 2007
Is it possible to join derived tables to actual tables in Access 2007 like in SQL Server 2008? I have an example below:
SELECT *
FROM
--MyOtherTable is a "real" table
MyOtherTable ...
4
votes
5answers
1k views
What is the easiest way to get started using databases with real data?
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
1
vote
1answer
57 views
Rename cell based on duplicate compound key in MS Access
I'm using MS Access (I know, I know...), and I'm trying to rename a cell when there are duplicates of mutliple columns.
Here's an example:
Col_1 Col_2 Col_3 Note
A1 B1 C1
A1 ...
3
votes
3answers
95 views
~15 data sets w/ 25k rows & ~20 columns + quick one time reports = Access VS SQL?
I am working with around 10-15 datasets each containing around 25,000 rows and around 20 columns. Data is text in name/adress/desc and the rest numbers.
I need to be able to calculate certain fields, ...
2
votes
4answers
3k views
Full Outer Join in MS Access
I have two staff lists:
List A:
StaffID Supervisor
====================
0001234 NULL
0001235 0001234
0001237 0001234
0001239 0001237
and
List B:
StaffID Supervisor
...
5
votes
3answers
393 views
Querying special characters
I work with language with special characters (example: e -> é). I have a query with a LIKE but when I search a word with special char and my query doesn't have the special char, I don't get the ...
4
votes
3answers
588 views
Query best possible matches and order them
I'm trying to write a query along these lines:
select *
from tbl
where
col1 = 1
and col2 = 2
and col3 = 3
order by
...
;
I want first all the results where all 3 WHERE ...
1
vote
2answers
426 views
Access exporting to CSV is weirdly slow
I have searched but could not find anything similar. If I just run the query, I can get the result pretty quickly (~5 mins); but after I saved the query to export as CSV, the exporting part is ...
-6
votes
1answer
727 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,
...
5
votes
3answers
332 views
Online resource for writing Access SQL statements
I am looking for an online resource for writing Access SQL statements. I write queries using SQL because the UI puts limitations on what can be queried. I have been using w3schools for reference, ...
