Questions tagged [ms-access]
Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
578
questions
0
votes
1answer
53 views
Access Send Email. Loop Not Building Table
I’m stumped on this one. I have an action item list on a fairly large Project Management DB. This list is datasheet that is embedded as a subform on a PopUp form from the Main Menu. On the Action Item ...
1
vote
0answers
102 views
link multiple MS project to Access/Excel
sir
I have a large project tracking database used to track PMs, status, help needed, action items, reports etc. I keep the project schedule in a large MS-Project file. I've exhausted all efforts to ...
0
votes
1answer
252 views
SQL query using an adjacent field value as a criterium
3 tables in a database. Table1 is tabCategory, Table2 is tabSub, Table3 is Parts.
Table3, Parts, is populated with 3 columns, multiple entries, thousands of them. Column1 is the part number, ...
1
vote
1answer
60 views
Query to determine percentage composition on a specific grouping of records
I want to analyse the Market capital of the Industry per Counterparty of the following table:
--------------------------------------------------
| CPTY | Industry | Value |
--------------------...
0
votes
1answer
20 views
Moving Reporting Processes from Access to MySQL [closed]
I am soon due to be given SQL access to our CRM system, which will allow me to automate some reporting processes. At present I use Access which I update with Excel imports.
As one example I have ...
1
vote
1answer
729 views
Access - SQL Server: cannot generate SSPI context
I actually understand why this error messages pops up, but I do not know how to implement my solution.
There is a SQL Server network instance I am providing some MS Access forms to interact with, ...
1
vote
1answer
393 views
Updating records in MS Access linked table will activate triggers?
I have a simple yet undocumented (or I could not find the documentation to solve my uneasiness) question, I hope I have come to the right place:
I am using MS Access to act as a poor front end for ...
1
vote
2answers
13k views
Compare Two Rows and Find the Difference Between Them Which is In The Second Column?
I have a table that has the following data:
ID Name LastName
1 William Johns
2 John Adam
4 William Smith
3 Mark Stephan
I want to Find all those ...
1
vote
2answers
396 views
How to Use SELECT DISTINCT
I have a question about using the DISTINCT keyword in SQL.
I have a table named Customers. Each record contains
3 fields: CustID, CustName, CustCity. 5 records show
a CustCity of "Chicago".
I want ...
2
votes
1answer
688 views
ORDER BY clause with Alias
I am trying to get the sum of the market values for each given CPTY. Each CPTY can have several market values. In my output list, i want to see the top 5 CPTYs, ordered by the sum of their market ...
3
votes
1answer
2k views
INSERT INTO with UNION Alias ERROR
This question is derived from the following post UNION query not working
Fails:
INSERT INTO AssetControl
SELECT *
FROM CSVImport
UNION SELECT *
FROM AssetTemp;
Works:
INSERT INTO ...
2
votes
3answers
12k views
Easiest way to import access db (.accdb) into SQL Server 2016?
I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance.
While I found posts online discussing using import/export ...
2
votes
1answer
2k views
Link MS Project to Access [closed]
I have a large project tracking database used to track PMs, status, help needed, action items, reports etc. I keep the project schedule in a large MS-Project file. I've exhausted all efforts to have ...
5
votes
1answer
207 views
Design a relational database (Access) that identifies breaches in records based on user defined limits
I am trying to create a structured database in Microsoft Access that monitors trading risk. Let's say an organisation wants to analyse all of the trades that it has in its books at any given point in ...
0
votes
1answer
1k views
Access Gantt Chart
I designed and maintained a database used to track my organizations projects. Access frontend with a SQL backend. I have a table for all the scheduling events. Task, Start, Finish, duration etc. ...
-1
votes
1answer
46 views
How to know a downloaded database file is secure?
maybe it's two questions but maybe someone has already faced with my issue exactly, and just knows ONE precise answer during this conversion target described below. I have downloaded an empty .mdb ...
0
votes
1answer
30 views
How to create a CSV file which imports data from an Access Database on a Weekly Schedule?
I have very little experience in database management but have come across a problem I am unable to find a solution to online. I currently have access to a database which is updated in real time with ...
1
vote
0answers
289 views
Creating a Relational Products / Package Database
To prefix this, I am stuck using Microsoft Access, or at least relating to it, so my capabilities are a bit limited. I also do not want to use an EAV model. I could put the new tables into SQL Server, ...
0
votes
2answers
6k views
How do I select distinct on one column and return all other columns?
I am using vb.net/access/Microsoft.Jet.OLEDB.4.0/DbaseIV to do this. The syntax varies between vb.net and SQl Server so I am having trouble.
I need to select one of each version in the data (using ...
0
votes
1answer
125 views
MS Access Many-Many Query/Form Assistance
I have somewhat of a beginner-type question.
Could someone look at the below relationships and let me know why I can't get the following form/query to only show the unique Appointment letters? I have ...
0
votes
1answer
47 views
Migrating MS Access application
I'm advising a small non-tech company that outsources their software, hardware, and support services to a local IT provider. This company is preparing to migrate several of their internal applications ...
4
votes
1answer
83 views
Fill percentage of total field conditional on some other field with MS Access SQL
This question is an extension of Fill percentage of total field with MS Access SQL.
I have the following 2013 MS Access SQL query:
UPDATE MyTable
SET F = f / DSUM("f", "MyTable") ;
This query ...
1
vote
1answer
78 views
Fill percentage of total field with MS Access SQL
I am trying to fill, with a SQL query, a field F with the percentage over the total of some field f, such that each record F(i) in field F is given by:
F(i) = f(i)/SUM_i(f(i))
Both fields f and F ...
0
votes
1answer
106 views
ms-access: issues with form and subform interaction
There is a main form bound to the main table, public_OUT_Detalle_PMC. And there is a form bound to a smaller table, public_ficha_negocio, which is a selection of fields in the bigger table. This ...
1
vote
0answers
47 views
SQL server schema to accomodate duplicate PK/FK values from autonomous Access data bases
I have several test stations with Access databases that have identical structures (12 related tables each). They are independent and all internal PK & FK values (Autonumber PK & Long Integer ...
0
votes
1answer
64 views
Access 2013: Merging the same table-field with different data
I have six tables with identical fields. the group was tasked to input the data with the same fields and I need to merge all into one dataset--- table and form.
1
vote
0answers
299 views
Access-PostgreSQL: Link tables as readonly, edit registers in form
I have a PostgreSQL database working as backend and I have to develop an Access frontend solution for regular users of this database.
I decided it best to create some forms to manage the input, ...
-1
votes
1answer
309 views
Concatenate fields in Access
How come my statement is getting marked wrong? The question is:
Create a query based on the tblCustomer and tblPurchase tables that will concatenate the member’s first and last names (separated by ...
0
votes
1answer
28 views
express builder [closed]
I have a question about Access database. I'm creating a form. I have a retail price that I want to get a 5% discount from to make a sale price. The sale price is the retail price - the discount but I ...
0
votes
1answer
33 views
Returning 1 Max Value when Some Counts Are Equal in Access
I'm building a database that needs to return peak traffic data for Month-over-Month and Year-over-Year Comparisons in Access. We are trying to determine what our busiest Monday is, Tuesday, Wednesday, ...
0
votes
1answer
941 views
How to import excel to MS Access table design?
NOTE: This is NOT asking how to export MS Access table design to excel. This is the opposite direction.
Given a excel sheet, it has field info (name, start position, and width). I want to export this ...
1
vote
1answer
13 views
Is there a way to input field information by cvs file?
I am importing a new database. I am asked to input field information in MS Access manually. Is there a simpler way? For example, import a cvs version field information into the following
1
vote
1answer
37 views
MS Access fail to recognize correct field width
I am trying to import a very large text file (200 fields +) into MS Access.
The text file is not comma separated. I am not sure if it can be called fixed length, since each field has it own length.
...
-1
votes
2answers
838 views
Select parent value if all child values are in a query
I have three tables similar to the example below
T1 T3
------------------------ --------------------------
T1ID X ... T3ID ...
0
votes
1answer
66 views
Archiving tables with Access frontend and linked SQL Server
I'm working on a project where the user has an Access 2013 MDB database with forms, reports, and queries. We're converting it to use linked tables to SQL Server 2008 R2. All the linked tables seem to ...
0
votes
0answers
24 views
Are there negative effects to creating multiple copies of an access database?
I've been working on updating an existing database for a company and for version control have been making multiple copies (so far I'm at 10) and making different kinds of changes to each one. I am ...
1
vote
1answer
224 views
Does modifying an access file copy affect original file?
This might me a stupid question, but it is crucial for me to know, so please bear with my limited knowledge of Access 2002 application.
Let's say I have an original database file, let's call it ...
1
vote
1answer
108 views
Join two tables and create a new one in SQL
I am new to SQL and trying to apply a concept of Joins in MS-access.
I have two tables Table 1 and Table 2:
I want a query which will create a Table 3:
Ideally i want all the data from both tables ...
1
vote
0answers
735 views
Using Microsoft Access front-end with PostgreSQL
We are using a MS Access database at work and I am exploring the idea of using the MS Access front-end and use a Postgres back-end to better manage concurrent uses and add spatial capabilities with ...
-1
votes
1answer
164 views
Access 2016 Web App View allow query null
I'm designing an Access 2016 Web App for inventoring our computers.
Here you see the view:
Some of those are queries. The problem is with SSD-Storage and HDD-Storage.
The query looks like that:
...
0
votes
1answer
27 views
Concatenating time values
I have a problem.
In my access database I have two fields with DateTime. I use them for when a meeting starts and ends.
I would like to concatenate them for a report, but 09.00 ends up as 9.0 so my ...
3
votes
1answer
55 views
How do I duplicate a row in a source query to (X) identical rows in a destination table when (X) is qty in the source query row
Looking for help in below table using VBA in Ms-Access 2007.
I have 39 columns to copy and repeat col40 times
Just starting to learn VBA. Any help would be appreciated.
I am attempting to take the ...
3
votes
3answers
3k views
JOIN ON syntax error in Microsoft Access 2016
I am querying a couple tables, and for some reason Microsoft Access 2016 continually informed me that my SQL query JOIN ON syntax is incorrect. Specifically, the JOIN syntax is highlighted, followed ...
0
votes
1answer
624 views
Simple access query based on many to many relationship
I have a simple many to many relationship set up on access with "List", "DayJunction" (Junction Table) and "Days". I am trying to query for records in "List" that have no related records in "Days".
I ...
1
vote
2answers
339 views
Exclude table's data from another table
Is it possible to create a query and ask the following?
I have two tables (each one has one column with data) and I want to obtain as a result all data from the first table MINUS the data from the ...
0
votes
2answers
4k views
How to restore SQL Server bak files in Access?
I backuped some SQL Server 2008 R2 databases using .bak files within SSMS, I sent them to a client and they're willing to open them within MS Access.
Can you please tell me if this is possible and if ...
1
vote
0answers
79 views
Table Relationships: Table 1 (Field 7, Field 8, Field 9) to Table 2 (Field 1)
I'm sure that this is probably 'Databases 101', but I can't seem to figure it out.
So, I'm setting up a database in Access - that I will want to move to MySQL, and I currently have 4 tables, set up ...
-2
votes
1answer
2k views
MS Access SQL multiple rows into one row with new columns
I have a table which contains individual test items (responses) from a 20 item test. There is a Person_ID, a Item_Number, and a Item_Response. Example:
Person_ID| Item_Number| Item_Response
1 |...
0
votes
2answers
36 views
Make custom query from two table access
I have two table that table 1 contains Number, code, ID and table 2 contains Name, Family name, Number, ID, code, Phone number,...
Now I want to make a query that contains table 2 fields but the ...
1
vote
1answer
321 views
How to simplify this query?
I am somewhat new to Access and I need help with a query that Access does not execute because of Not enough space on temporary disk.
I have one table. A product may have up to 3 IDs and a place to ...
