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

learn more… | top users | synonyms

-1
votes
0answers
25 views

Can anyone please help with converting this to Access [on hold]

SELECT Rank () OVER(ORDER BY sum(il.qty) desc) as Rank, il.Part, il.PG, p.Range, il.Branch, il.bopdes, sum(il.qty) as qty, sum(il.unit*il.qty) as Value FROM ILines as il with(NOLOCK) LEFT JOIN Product ...
1
vote
1answer
11 views

Is DISTINCTROW in MS-Access the same as selecting all the fields and doing a group by on all of them?

I was looking though some queries in MS Access, and I found an SQL keyword I was unfamilar with called DISTINCTROW, from what I can tell, it's the same as an SQL GROUP BY which includes all the ...
0
votes
0answers
13 views

How to create a table in access and automatically fills it with information from a query?

Is it possible if I create a table that will lookup for a value filtered from a query (consult), in this case is duplicated "Name"s from a Employees registring table and automaticly fills up that ...
0
votes
0answers
6 views

In a Registry Formulary (Table origin), how to show an image (Object ole) that is linked with the “Name” Collum in the table? [closed]

I got in a table a Collum named "Register Time" and another "Name" that is the name of my Employees. Then I got a Formulary that is where I register my Employees "Monthly income" inputed in same ...
0
votes
0answers
11 views

Using Microsoft Acess from remote computer

I work for a non-profit that has a part-time worker who works from her home, and she needs to use a Microsoft Access database that we have on our network. I'd really like to stay away from VPNs, and ...
1
vote
2answers
24 views

Help with Access many-to-many relationship (beginner)

I'm a beginner with MS Access hoping for some help with a database I am trying to create. This is (will be) a database of land parcels in a given area, and their associated landowners. Here are my ...
0
votes
1answer
23 views

MS Access Data Type for time in hh:mm:ss format

My database contains three different sporting events with finishing times imported from an Excel spreadsheet in the hh:mm:ss format. How do I customize the Access data type field to accept this ...
0
votes
1answer
14 views

Can't list columns or query in MS Access 2003 linked server in SQL Server 2008 R2 using Microsoft Jet 4.0 OLE DB Provider?

I can however list the tables... If I run Exec sp_tables_ex 'LSTest' I get a result with a list of tables. But if I run Exec sp_columns_ex 'LSTest', '<one of those table names>' I get an ...
0
votes
0answers
31 views

SQL Server accepting Access queries?

I am currently working on migrating a legacy codebase from VB6 and Access to VB.NET and SQL Server. I have run the Microsoft SQL Server Migration Assistant successfully and populated a SQL server ...
0
votes
0answers
12 views

Using a button/toggle switch to hide records meeting certain criteria on a subform [migrated]

In my Access 2013 database I have a form, which opens with a filter using VBA. It is sort of a schedule. It is looking at a table and the split into a tab separator, with each tab having its own ...
0
votes
0answers
12 views

Restrict Front Ended User access to Form entry only

I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in ...
0
votes
1answer
22 views

Remotely Connect to MySql from MS Access

Does anybody know if it is currently possible to remotely connect to a MySql server from MS Access? What does one need to do to go about doing this?
0
votes
1answer
20 views

Records creates double entry, should only be one

Need an assist on a database design. I'm creating a system to track students in a course. Currently, I have courses. Courses are made up of modules. A given module can be in multiple courses (eg 2 ...
0
votes
1answer
34 views

VB.Net error with CASE SELECT

The following VB.Net code runs fine on SQL Server but gives an error on Access: sql = "SELECT sr.itemcode, sr.itemname, SUM(CASE WHEN sr.transdate='4/14/2016' THEN sr.temunits] END) AS [Units Sold], ...
1
vote
1answer
48 views

How do I calculate a field based on multiple non-numeric records

I have a several tables that I have joined together to get raw data. Some information about my query in the most basic form: Table1 has a column [FacilityID] that is a unique identifier in that ...
1
vote
1answer
17 views

Updating a table with a not-joined query

I'm using Access and have a task that I want automated using an query. I have a table (IncentiveAssignments) that lists out all of the Gift Card numbers (GiftCode, all are unique) I currently have ...
0
votes
0answers
24 views

How can I prevent users from accessing certain data?

Here is a screenshot of my database in MS Access 2016: On the left, I have all my tables, queries and forms. I would like to prevent users from accessing these data as well as the VBA code (i.e ...
0
votes
0answers
30 views

Group by periods in SQL

Each register is an event in a location with an id, but events take place "in clusters" (e.g zero to two events every day from 31/02/2014 to 10/03/2014, all with the same id). I need to detect the ...
0
votes
3answers
29 views

Aggregate and GROUP BY conflict with HAVING?

I don't know if my logic in my query is incorrect, or if I simply have a syntax error, or both. For each customer that had more than two orders, I want to list the customerID and the total number of ...
1
vote
1answer
24 views

How to create a form that allows user to enter a variable number of items

I am a total beginner to Microsoft Access 2010. I need a form that allows a user add items from as list to a list. The items can be added until initial list is exhausted. Here's the most basic ...
0
votes
0answers
10 views

Access Database VIewing Area

Somehow I've made my area where the tables, queries, etc too small and I can't find line to enlarge. where can i go to default back to normal view
0
votes
0answers
15 views

Update MS Access table from Constantly changing Excel Spreadsheet

I have an excel spreadsheet that looks something like this: modelNum | serialNum | Data ------------------------------ 478389 | 1Z431G | 4 478389 | 1Z43A1 | 6 438584 | ...
1
vote
0answers
52 views

SQL Server Linked Server with Microsoft OLE DB Provider for Visual FoxPro?

We were having some issues with our old Microsoft Visual Fox Pro ODBC driver that we shoehorned into Windows 7 and is no longer supported by Microsoft and has not been for quite a long time... So ...
0
votes
0answers
25 views

Microsoft Access Form's Combo Boxes Help

I have a database in access and I am creating a form to enter transactions for investors in our hedge fund. The form is supposed to create new records in the table tblTransactionsAccrued. I created a ...
1
vote
0answers
40 views

Database table(s) to record investor activity

I've never asked a question here before. I am currently designing my first database by learning from the web and some books I got, using MS Access to start. I work in operations for a small hedge ...
2
votes
1answer
24 views

De-duplication method for fields that are identical except for Unique ID

I'm looking for a decent de-duplication method. Basically I have a table which has five fields plus a Unique ID (key) field. I've run a duplicate which detection query which finds any records where ...
1
vote
3answers
66 views

Using JOIN statement with a WHERE

This is probably a basic question, but I'm trying to build an SQL query for an access database that returns orders from a certain customer and I want to cross reference the customerID with the ...
1
vote
1answer
86 views

SQL Server Trigger does not update all table records

This is my first question so please go easy on me. We are using Access 2013 as a front-end and SQL Server 2012 with MS SQL Server Management Studio 11.0.2100.60 backend with ODBC connections. I am ...
1
vote
1answer
32 views

Back-end with encription and user-control for MS Access2003-VBA

My client has an Access 2003 "multi-user" (<6) "database" (<3k records) with "encryption" located in a LAN folder and an easy Form I polished with VBA(DAO library). Access 2003 encryption can be ...
0
votes
1answer
35 views

Syntax Error CREATE TABLE Statement [closed]

i am getting a Syntax error in CREATE TABLE statement. Microsoft Access 2007. CREATE TABLE ROOMS ( RoomNum Int Not Null, RoomSize Char(6) Not Null, RoomBedCnt Int Not Null, RoomRate Numeric(18,2) ...
0
votes
1answer
6 views

How do I get a linked list to display more then just the first search item in Access?

I just feel like I'm missing something really stupid. I have a simple access database I'm using for tracking my projects. I have multiple individuals and I have multiple projects. For the project, I ...
0
votes
1answer
21 views

Access 2010 Need help connecting/updating database data

I have a large database that has sporadic fields with incomplete or missing data. Quite the inherited project, I have to say. I'm new to Access, so if you have any ideas on how to simplify this pile ...
0
votes
0answers
17 views

MS Access - Extract Data from Proprietary mdb file

my friend has this "software" that manages financial records, with a lot of user data per record. This "software" is really an access file. To launch it, you use msaccess.exe program.mdb, and it ...
3
votes
1answer
27 views

Create a form solely for inputting data?

I am looking to create a form for a database in MS Access, that will be used solely to allow users to input data into the database. However, all the options I have found do not allow for this, they ...
1
vote
2answers
72 views

How to get MS Access to reach a Linked server on MSSQL

We have an MS Access DB that has been in place for 16 years in a Front End/BackEnd configuration. It is now running under the latest version of MS Access using ACCDB files. Since its inception, we ...
0
votes
0answers
19 views

How can I make microsoft Access update fields that are linked in several tables?

I am working on a database for clinical observations in cancer mouse models. Usually, the animal care staff reports an observation that the vet checks. Sometimes, we have false positives that I need ...
1
vote
1answer
39 views

Query that compares dates

I'm trying to create a query that shows if students are mature or not, based on their date of birth. However when the query is executed it returns all students as not mature. Any students that are ...
-2
votes
2answers
53 views

Query that finds the oldest driver

Given two tables: driver=(d_id,name,gender,birthday,address,country) event_list=(o_id,d_id,odate,oplace) The event list table represent the driving violations of the driver , o_id is the violation ...
0
votes
1answer
59 views

MS Access Run Multiple Queries

I have eight 'append' queries in MS Access 2010 that I want to be able to run. Each query also needs to take one parameter (a project number). I want to run all eight, entering the parameter only ...
0
votes
2answers
108 views

Combine multiple row's records in one row with MS Access Query?

I have a table (name- tbl2) with 21 column but I want to combine multiple rows records in a row by using a unique reference number as below: Table Field and Records Type Expected Result: Please ...
0
votes
1answer
24 views

Create new table values based on partial column value - access

I am trying to remove a ton of unnecessary rows in this table. Currently there are 1.3m of them which are all an individual transaction id - with the country and destination assigned for each which ...
0
votes
0answers
42 views

Microsoft Access - Use table from excel to update all other tables in a database

I am working with a database on Microsoft Access 2016 in a small company. What I would like to do is create a table (imported by Excel) and update all related fields in the other tables. The Excel ...
0
votes
1answer
35 views

Beginner Question: Trouble turning a field with comma separated values into a multi-valued field

It's my first time using Access, and I have my first of what I assume will be many questions. Yay! So I imported some data from Excel to a table, including a column with a comma separated tagging ...
0
votes
0answers
11 views

Simple Microsoft access 2000 database to count product quantity

I have made a simple 2 colomn database in microsoft access 2000 (thats what I have to work with). The first colomn is the product name like "pack of paper A4" or "pencil blue". The second colomn is ...
1
vote
1answer
59 views

Combining two queries

I am trying to write code for this query: Find the names of the actors that played at least in one movie since 2000 and where not directors of any movie at this period of time. My thought was to ...
1
vote
1answer
67 views

INNER JOIN for 3 tables [duplicate]

I am doing a small course in SQL during my academic degree, I am very new with this material. I saw Inner joinning 3 tables on StackOverflow, I tried to do INNER JOIN between my three tables, the ...
-5
votes
2answers
130 views

Query that finds the names of the directors that played in movies that they directed

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names of the directors that played in movies that they directed The tables: ...
-2
votes
0answers
39 views

Query that finds the names of the directors that played in movies that they directed [duplicate]

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names of the directors that played in movies that they directed My attempt: ...
-2
votes
0answers
40 views

Query that finds most common genre [duplicate]

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds most common genre (with the biggest number of movies) The tables: My attempt:: ...
-4
votes
3answers
164 views

Finding the most common genre for “eMovies”

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the most common genre (that have the biggest number of movies) The tables: Actors ActorID ...