Questions tagged [ms-access]

Microsoft Access is a relational database management system that is part of the Microsoft Office suite.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

SQL Query Statement with Group By

I am trying to analyze how far players of the game progress as a function of age. The age is measured as the number of days since game installation. For active players who played the game at a certain ...
0
votes
0answers
22 views

How do you modify query to include additional fields in the results?

I have the following MS Access query: SELECT * FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData UNION SELECT [cnPart], [qty], "qty" FROM PartData UNION SELECT [...
1
vote
1answer
19 views

Find Max Date from a Distinct Row Then Add Value to a Table Column

Quick disclaimer - I am familiar with Access, but a novice at MySql within Access. I have a table with activity data that I pulled into a query to filter down to only necessary data. The query table ...
0
votes
0answers
20 views

Creating a report with multiple sub-reports, grouped on one field - Microsoft Access 365

I am trying to create an MS Access Report (Microsoft Office 365) with more than 1 subreport, to be grouped under a field called "City". The report is based on a linked table and the sub-...
1
vote
2answers
29 views

Return results with several LIKE and NOT LIKE requirements

I am trying to create a query that selects only a set of values, but excludes other ones. The column I am selecting it's called "Participants" and the values therein are not a single text ...
0
votes
1answer
21 views

How to Stop MS Access From Undesired Cascading Delete? [closed]

When I delete a record from one Microsoft Access table, it deletes the corresponding record in another table. I need to stop that. Table 'items' has ID (the key), item_name, and some other fields. ...
0
votes
1answer
28 views

Q: Updating multi table linked view with MS Access

I have an MS Access db with a linked table pointing to an MS SQL server database view. We have been using MS Access as a simple front end to change data contents via this view. The view was ...
0
votes
1answer
54 views

Expressing A Composite Key in a Data Dictionary

I am looking for an example of expressing a "Composite Keys" in a data dictionary. I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the ...
0
votes
0answers
17 views

Error 2105 on Northwind derived Access database when trying to opening a blank form after changing the table source

I have an Access database which was built from the Northwind template, which is referenced here: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases I ...
1
vote
1answer
18 views

How to design a query to pop up input with two text boxes in MS Access

I ask this question while I could not find any similar question neither on Google nor DBA Stackexchange, this question might be duplicated. I wrote this query in MS access to check for first name and ...
0
votes
1answer
28 views

Consolidate / sort / combine / merge data for dummies

I am looking for a non-scripting solution to combine data from 3 different tables (preferably using spreadsheet software like Microsoft Excel but a database would also work e.g. Microsoft Access). I ...
0
votes
0answers
10 views

how to Manipulate duplicated records using access

Using Microsoft Access, I have a number of records that have duplicated field-1. I need to form a query such that the duplicate records get unique ; BUT the next filed-2 data must be seen in columns ...
0
votes
0answers
8 views

Two table left has multiple rows, right has 1 row. Need right table to return value only in left table 1 time

Newbie Here, looking for guidance. Please and Thank you! I have two tables where I am looking to see where Alice (left & right) is forecasted and to what role(s) and to what client(s) (left) and ...
1
vote
1answer
45 views

3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

The First Question is: "List the name of each trip that does not start in New Hampshire (NH)." SELECT TripName FROM Trip WHERE State!='NH'; /* works with State='NH' */ The Second Question ...
0
votes
1answer
19 views

query for showing columns from various tables, grouping and showing calculated field in each row of the result

I am doing a stock management system. In one table I store items: ITEM<br> id_item<br> item_name<br> ORDER<br> id_order<br> date<br> ORDER_ITEM<br> ...
1
vote
1answer
16 views

Return only records with a date after the most recent September 1st

I have a table with data with a date column called "dtAssessmentDate" in a table called "tblAssessmentRecords". What I want to achieve is for a select query to return only the ...
1
vote
0answers
7 views

Autofill spreadsheet data from Excel [closed]

So I've got an Excel template I send to clients and they fill in one cell with a type of resource they need, and I check an Access database for available resources to find what we have and fill out ...
1
vote
1answer
22 views

MS-Access Beginner Replace Textbox Caption With Combo Box Selection on Button Press [closed]

I'm a complete beginner, just trying out/looking into Databases as more of a hobby, and think Microsoft Access would be an easy way to start with the whole front-end forms and back-end combination. I ...
-1
votes
1answer
23 views

Job Opportunity and difficulty (or not) for me to learn to use msaccess and surveygizmo/alchemer [closed]

First, if my question fits better elsewhere, please advise. My question is: Based on your experience with relational databases like MSaccess and perhaps survey tools like Alchemer (formerly Survey ...
-1
votes
1answer
122 views

Using an independent textbox to write different values for different rows/registers in a continuous form, repeats the value in every row [closed]

I have a form that is using a continuous form view to show the following: The name of the different products I have. In another column I have the actual quantity of the product.ç This is made using ...
1
vote
2answers
28 views

Use filters instead of queries in MS Access? [closed]

I realize many things could be done in Access like instead of using queries for filtering things, it is posible to use filters. I'm not sure if the program makes SQL with VBA queries under the hood or ...
0
votes
0answers
26 views

How do I write my SQL Code in MS Access SQL?

Table Name: Records ID Date Time Status BoxType Material Rack EmployeeNr Transaction 1 25-05-2020 13:11:12 70 36757 4 4 188 2 2 25-05-2020 13:12:40 71 31178 2 5 188 2 3 25-05-2020 13:13:31 71 ...
1
vote
0answers
9 views

Span a record on multiple pages in MS Access [closed]

MS Access has a limitation in its Reports functionality that is max Section height is 22.75 in. (57.79 cm). I want to create a report that will use data from a single record to span on 12 pages in a ...
1
vote
1answer
36 views

What is MS Access ODBC SQL syntax for a table with AutoIncrement and Memo columns?

I am migrating a full framework .NET app to core. It used ADOX to create an MS Access database and tables. It used OLE DB to populate data. In ADOX, the data type was ADOX.DataTypeEnum.adInteger and ...
0
votes
1answer
34 views

Why i can't use table name in subquery?

I have a MS-ACCESS database. When i try to do this query: SELECT * FROM (SELECT * FROM tblClients AS a1 LEFT JOIN (SELECT TOP 1 lVersion, lRequestID AS lVerReqId, lClientId FROM ...
0
votes
1answer
23 views

How to select maximum row value using optimal way

I have a large table: +----+-----------+------------+--------+--------+--------+ | Id | lClientId | datAccess | lProp1 | lProp2 | lProp3 | +----+-----------+------------+--------+--------+--------+ | ...
0
votes
1answer
144 views

Is it better to have multiple tables with the same primary key or one big data table?

So there is one primary key so far used for IDs of locations. Currently there are multiple tables (sheets) in Excel for the following Events (Location ID, Date, Title, Description) Animals (Location ...
-1
votes
1answer
137 views

How to rewrite IIF and dlookup function from Access in SQL Server as we have recently migrated from access to SQL Server

I need to rewrite the IIF and dlookup part of this query so its can work in SQL Server . I would preferably like the CASE and SELECT statement as SQL Server doesn't have dlookup function so code is ...
1
vote
2answers
219 views

SQL server Login failed for user [duplicate]

My MS Access Application uses SQL Database as backend. The permission to SQL database is granted with Windows Authentication mode to a specific user group. Most of users in the group can get access to ...
1
vote
1answer
18 views

Update query using two tables

I want to update the ProductStock field in tblProduct when this query is run. The ProductStock should minus the Quantity field in tblOrderProduct. (ignore the * sign, I just wanted to see if ...
0
votes
1answer
38 views

Table Diagram and Access File of Contact Database for Church

I have volunteered to design and develop an MS Access database for contacts at my local church in Jamaica, which has no budget to hire a database expert. I have attempted to design a database for the ...
2
votes
1answer
26 views

Microsoft Access: Using other fields in an Autonumber

I'm trying to use Microsoft Access to start an employee database. However, I want the display of the Employee ID to be the initials and then their number. For example, John Smith with the ID 0002 is ...
1
vote
1answer
50 views

How to refer to Field Name with a ? in it in MS Access VBA code [closed]

Simple question, but I am new to databases. I have a field called 'ActorRetired?', and in some VBA code I need to set the value of it to -1. But When I try: Me.ActorRetired?.Value = -1 I get the ...
0
votes
1answer
62 views

Microsoft Access Move Multiple Rows In Table1 To A Single Row In Table2

I'm new to Microsoft Access so my terminolgy and understanding are limited, please bear with me. I am interfacing a piece of lab equipment via Serial/ASTM/ODBC to MS Access for Office 365 MSO 16.0.12....
0
votes
1answer
356 views

Combine Multiple Rows Results From Left Join in a unique cell

¡Hi guys!, I don't have any idea how to create a new column that contains all information of results from a Left Join if exists the value Example Table 1 -------------------------------------- | ...
0
votes
1answer
512 views

Backend on server keeps getting into an inconsistent state

I built an Access database. It was originally meant to be for 6 people but I see that it's up to about 20, so that could be the problem. Anyway, the backend gets into an inconsistent state a couple of ...
0
votes
2answers
189 views

Microsoft Access Listbox Query

I have 2 tables in Microsoft Access. Table 1: ID Val1 Val2 Val3 1 a b c 2 e f g 3 h i j Table 2: ID Val Chosen 1 a 2 ...
1
vote
1answer
71 views

Database software solution [closed]

Our company has user data (name, email, phone number, systems of access, AD username) in a large Excel workbook. The Excel workbook is becoming very slow because of the 1000s of entries in it, and we'...
0
votes
2answers
106 views

Guidance on strategy for serving files remotely using SQL Server

Thanks for the help. "I" am the IT department for a small business and my ignorance may keep me from asking the right questions so please bear with me. Currently, we are using MS Access ...
1
vote
1answer
47 views

SQL Trigger that creates new table when a new record is added to current table

It's been quite a few years since I have done DB work. I am working through mysql workbench (using MS Access as a frontend). I have a base table that I am multilinking (basically a name index type ...
0
votes
1answer
23 views

how to convert query related to calculate work hours in MySQL to MS Access [closed]

I want to calculate work hours in each day using MS Access.I have query for same thing in MySQL but this thing is not working in MS Access using pdo php. query in MySql SELECT MachineNo, ...
0
votes
0answers
21 views

How to optimize storage of sales details with multiple products in each sale in Microsoft AccessDb

I have created an accdb with customers and products tables. Now, I want to know how to store the sales order details in the Sales table, WHEN each sale has multiple products, each with different ...
0
votes
2answers
3k views

Split a string into multiple rows and get the count for each of them

I have a table "Production Database" in Server. I am using MS Access as a front end interface. I have some forms there. I want to create a query which will split records in "Reviewer" column and give ...
1
vote
1answer
38 views

How to move geographical data from MS Access to SQL Server

For 20 years I've been working with MS Access, with much VBA involved. I have a lot of geographical data in Access and I'm preparing to move to SQL Server because it supports geographical data types, ...
0
votes
1answer
49 views

Cannot login to a MS Access database

Below is some VBA code to authorize users to login into an MS Access database. I am trying to fix this code and I don’t understand what is the issue in this code snippet. Private Sub cmdLogin_Click() ...
0
votes
1answer
30 views

Small site / online database [closed]

I have to develop a small website and I wanted to understand which language to use. The main purpose of this site is to access various tables, for example customer table, orders, warehouse, etc. by ...
1
vote
0answers
25 views

Rolling multiple rows into single row

I need help getting multiple rows of data to all pull into one row based on a primary key. I have four teachers rating a student's academic and behavior performance through the year. At the end of the ...
0
votes
1answer
696 views

How to convert columns into rows in MS Access [closed]

Please help me to understand, how to convert columns to rows in MS Access. I have the below table, I would like to convert as the below result table. NoOf_A NoOf_B NoOf_C NoOf_D 200 300 400 ...
0
votes
1answer
13 views

How to create columns with Count and percentage using MS Access Query

I have a data table below, I would like to create a query to produce a result table like below, with count and percentage, using MS Access Query. I am unable to create this. Name Alex Alex Bob Bob ...
0
votes
0answers
69 views

how Access can communicate to SQL without using ODBC?

Access will be the front end but I don't want to use ODBC on everyone's PC. Do you have any suggestions on how Access can communicate to SQL without using ODBC?

1
2 3 4 5
13