FAQ Database Discussion Community


MS Access crashes every time I try to open Visual Basic

vba,access-vba,ms-access-2013
So I have a split db. dbBackEnd: Lives on the network drive, users don't touch it except through the front ends. dbFrontEndv1:Stored by me for safekeeping, works fine dbFrontEndv2:Stored by me for safekeeping, works fine dbFrontEndv3:Users are interacting with this now, works fine dbFrontEndv4: Freezes every time I try to...

Dsum Function in Query Field not working properly

ms-access,sum,ms-access-2010,ms-access-2013,running-total
I have a date based query that returns two fields, Week Ending Date and L2N, and I want to add a third field that provides a rolling total of the L2N field. I have tried using DSum as follows: RunL2N: DSum("[L2N]","Occupied Apts & L2N", "Week Ending Date=" & "'" &...

List box and Option group filtering 3 different rows in MAIN list box in MS Access 2013

ms-access,filter,ms-access-2013,query-builder,iif
I've been struggling with the following for a while and would be more than happy for some brainpower ;) I have an Advanced filter form, which filters through orders via many different filters, currently the one that I can't make function is the following: I have 4 controls on a...

db.OpenRecordset returns nothing; but run as queries they do

ms-access,access-vba,ms-access-2013,recordset
I'm trying to generate a bill by route, so I've broken it down by customers belonging to a specific route, and then for each customer totaling their weekly rates to compile a monthly rate. The problem is, even opening a recordset with a SELECT * IN [table] returns nothing, so...

Returning text to a button from a database C# DataColumnCollection

c#,ms-access-2013
Please bare with me, not too sure as to what i'm doing. I'm sure that my language isn't up to scratch too. That'll come with time! I'm attempting to build a POS system, I currently have an access database that stores all my menu items as strings. I wish for...

Ms Access pop-up forms off screen

ms-access,ms-access-2013
I am currently working in MS access 2013, and having an issue with some forms that worked previously. I have gone back and edited them to have different functionality. I need the forms to be pop ups. Now, they work perfectly when they aren't pop-ups, but as soon as I...

Dividing summed field by another summed field in the same query

sql,ms-access,ms-access-2013
How to divide a summed field by another summed field in the same query. Example: lets have the query "querySummary" which its field have been grouped already SID SumOfCredits SumOfMarks 1 3 18 2 2 20 3 4 40 Group By Sum Sum I want to add another field named...

Create a concatenated list of child table values from an Access database without using VBA

ms-access-2010,ms-access-2013
I have an Access 2010 database with a relationship between parent and child tables. I would like to be able to query the database from an external application and show values from the child table as a concatenated list of values in a single column, similar to what MySQL can...

VB.net combobox displaying System.Data.DataRowView

vb.net,ms-access-2013
I am trying to return data from an SQL query via Access 2013 into my VB form my code is below. Private Sub frm_8_IncidentResponseSelect_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim dt As New DataTable Dim query As String = "select ([response ID] &' '&[response date]) As responsedetails from...

Access built-in functions like Year() and Date() are not recognized

ms-access-2013
I tried the simple query: select Year ( #5/1/1990# ); It shows error dialog: Not defined function "Year" in expression Also, when I use Date() in the form it shows #NAME. I added it with expression builder in Access. What am I doing wrong?...

Displaying the top two of summed values by group

database,ms-access,ms-access-2013
I have a query named "QueryTotalGrades" which has three fields (Group, StudentID and Mark). each studentID has more than one mark. What I want to do is to create another query that conduct the following : 1- Sum mark for each studentID as a sumOfMark (Descending order) 2- Display the...

Access, Use a linked table to update a local table

sql,ms-access-2013
I have two tables and would like tbl2 to update tbl1. tbl1 lives on a back end database on our network drive. It contains project information, regularly updated by a half dozen users. tbl2 lives on a remote users laptop. It is a copy of tbl1 which he updates throughout...

How to update a calculated field based on the value of a field in the same record

ms-access-2013
I am developing an app for an RPG. I need to track ability scores and a corresponding modifier. I was going to put this in one table and it would look like this: Table (Ability Scores) Field 1 = Strength Field 2 = StrengthModifier If strength is an 8 or...

Quartile/Percentile in MS Access via SQL with a GROUP BY when some values can be NULL

sql,ms-access,ms-access-2013
I am looking to calculate a percentile of a subgroup for a field that can be NULL. Field IU is either 1 or Null. Specifically: *my table: tblFirst250 *group by: IU = 1 (which is Nullable) *percentile of: GM (which is Nullable) I am starting with the following (but I...

Export an access query in csv without currency symbol using VBA

vba,csv,ms-access,ms-access-2013
I'm using this code to export a query in a CSV file: Dim getFolder As Object Dim sLoc As String Dim sName As String sName = Me.Name Set getFolder = Application.FileDialog(4) With getFolder .AllowMultiSelect = False If .Show = True Then sLoc = getFolder.SelectedItems(1) & "\" End If End With...

Compute sum of hours/day with overlapping periods, SQL

sql,ms-access-2013
I have a table with the start date(event.startdate), end date(event.enddate), and the hours/person (event.hrday) of an event. I have another table with weekdays listed which has another field for each person (calendar.name). I want to populate those columns with the total hours worked each day. I can't seem to figure...

Entering data once for multiple records

ms-access,ms-access-2013
One main purpose of a database is to make user entry concise - enter data once and reuse/display that data in different places without requiring the user to enter it again. In my database, I sometimes have identical data I need to enter in many records, for example, ages of...

MS Access 2013 SQL Type mismatch error

sql,vba,ms-access-2013
I have a table called test with a column of type number (Long Integer) and name CHANGEME. This column has values ranging from null to large integers. I'm attempting to select all null values and update them to 0. I'm doing this in VBA code. SQL = "UPDATE test SET...

How to select the TOP 1 record per group (Partition)

sql,ms-access,ms-access-2010,ms-access-2013
I've got a table called tblRoutes that holds a unique list of from and to routes (f = from; t = to): | fCity | fState | tCity | tState | |========|========|========|========| |New York| NY | Miami | CA | |Houston | TX |New York| NY | ... And then...

Display multiple specific records in a report

vba,ms-access,access-vba,report,ms-access-2013
Let's say I have a single table called "Customers". It contains 2 fields: Name Address I want users to be able to select multiple records by selecting their names. For example something like having a list box containing all the names of the records in the database. I want users...

Access Date Comparison Error

sql,date,ms-access,ms-access-2013
I am working on a sql statement where I'm trying to grab all projects less than or equal to the development date. However, I'm getting an error "Data type mismatch in criteria expression" I've searched and searched, but I haven't been able to find anything. The raw results look similar...

Data type mismatch when using a Select Query to feed a combo box

sql,access-vba,ms-access-2013
I am getting a 'data type mismatch in criteria expression (error 3464) with the below routine when trying to activate drop down box 'cboColleagues'. In short, there are two combo boxes of which the second one ('cboColleagues') is not visible until the user activates the first ('cboEditPersonnel'). The following routine...

me.visible for labels and textboxes access

ms-access,access-vba,ms-access-2007,ms-access-2010,ms-access-2013
I'm trying to toggle conditionally visibility of textboxes and labels using the me.visible = false statements. However, it doesn't seem to function properly in the on format event for my report footer. I tried for onclick and onprint as well but none of them seems to work. Initially i tried...

Acess 2013 - Query for number of payments for month in current year

ms-access-2013
I'm trying to make a query in Access 2013 that shows me how many payments I've received for month in the current year. I tried using this: Expr1: Count([Payment_ID]) However, it shows me all of the payments received without taking into account the current year nor without diving it per...

SQL - need to merge text from duplicate entries, eliminate the duplicates

sql,concatenation,ms-access-2013
I have a table in Access that is (roughly) like this: Name|Description|DocumentNo Jim|ABCDEFG|1 John|HIJKLMNO|2 Fred|PQRS|2 Jim|TUV|3 Fred|WXYZ|4 John|AABBCC|4 We're going to import the descriptions into a different database. The names column is unimportant here, but what IS important is capturing all of the description text along with each document number....

ACCESS 2013 NOT criteria returns wrong values

sql,ms-access-2013
OK, so guyes i have this table the task is to get all the pets names which didn't take the Rabies Vaccine so i made this query SELECT [Pets’ Vaccine Schedule].[Pet's Name] FROM [Pets’ Vaccine Schedule], [Pet Vaccine] WHERE ((Not ([Pets’ Vaccine Schedule].Vaccine)="Rabies")) GROUP BY [Pets’ Vaccine Schedule].[Pet's Name]; the...

How to query a delimited value list generated by function (Access)

sql,ms-access,ms-access-2013
I've got a module sub getFileList() that generates a value list that outputs the following: 10347 C;12-0605 TPX;12-0713 tpx;13-0915 tpx;13-4304 tpx;1345 c;1375 c;14-4201 tpx; I wanted to build a query against this function. In the SQL view I've got the following: SELECT getFileList("\\wwdata\dev\_commons\color","*.jpg") as colors; Right now the value list...

Access 2013 - Form View Issues

forms,vba,ms-access,access-vba,ms-access-2013
I am an access beginner and just recently upgraded Office from 2010 to 2013. I am creating a databse from scratch and the interface is unfortunately a little bit different from what I am used to. When I open a Form that I've created it appears to size to my...

Advanced Ordering Or Grouping Of Query Results (having?), Access 2013

sql,group-by,sql-order-by,ms-access-2013,having
I REALLY need help. I have a list of faculty members that can either be in assigned to a department or just affiliated with the department. I am trying to query but order the results so that any faculty that appear in the specified department appear in the list first,...

MS Access programmatically edit a datasheet cell value

ms-access,access-vba,ms-access-2013,datasheet
I'm validating my datasheet programmatically because it's not possible to do it the "normal" way (linked tables). The "normal" way to tell the user they entered a badness is to punish them with MsgBox popups - I want to display a message in a label on my form (this works)...

Insert from multiple select MS Access 2013 C# Error

c#,ms-access-2013
I've got an error in query I tried this: INSERT INTO Manuacturer_Item (item_id, manufacturer_id) SELECT i.id, m.id FROM Item AS i CROSS JOIN Manufacturer AS m WHERE i.iname LIKE 'PC' AND m.mname LIKE'zaz' What have I missed?...

Query for students passed and not passed

ms-access,ms-access-2010,ms-access-2013
How to make a query to know whether a student passed or not, where each student has ten subjects and the pass grade for each subject is (>49) Student to be passed, he/she has to pass in all the subjects. Any help please ?

Populate Text box on report based on value on another form

ms-access,access-vba,ms-access-2007,ms-access-2013
Very novice question but I have a report that has a couple of columns including usernames. I also have a form where a user can select a user name in a combo box and the report will open up only showing records that pertain to that user. Is there a...

Access 2013 - Set a field value based on value of another field

vba,ms-access,ms-access-2013
I have a combo box (Status) which includes the following: Shortage Allocated Actioned Acknowledged Complete I also have 5 other date fields which are as follows: Shortage_date Allocated_date Actioned_date Acknowledged_date Complete_date However I want this status to be populated automatically based on what data has been entered in my previous...

Disable multiple record navigation for sub-form

forms,ms-access,printing,ms-access-2013
I am working on putting finishing touches on a tool after a developer abruptly quit and left no documentation. I have been able to fix everything except for the following. I am creating a bar chart using data from a select query: Date Facility Bucket Variance 2/5/15 A >$10k >90...

MS Access validation rules not firing in subform

vba,validation,ms-access,access-vba,ms-access-2013
I have a datagrid that is a subform inside another form. I need to validate items inputted into this datagrid subform, but I'm having an excruciatingly hard time figuring out how. Whenever I read about this on forums and on Microsoft's help site, they recommend you use Required and Validation...

Syntax error in inserting values in INSERT INTO statement. -VB and ACCESS 2013

mysql,sql,vb.net,ms-access,ms-access-2013
Forgive me again for asking this stupid question again but... I really cannot figure out how to solve this another syntax error in inserting values In my database(which is access 2013) I have this fields in my table Fields - Data Types NO - Number RANK - Short Text LAST...

Convert Date to Financial Quarter in Access SQL

sql,ms-access,ms-access-2013,financial
I am having some real trouble trying to figure out a nice way to get some SQL in my access database to create a Financial Quarter result based on a date in the format dd/mm/yyyy (UK). I have a Column called 'Date' in the table 'DimDate' and I have a...

MS Access 2010/2013 Transition Issues

ms-access,ms-access-2010,ms-access-2013
So currently my boss and I are the two employees that work on our company's access database. I just got Office 2013 on my computer and he is will working with 2010. We have ran into some inexplicable bugs with the database. Most of these can be fixed by just...

Align Excel cell to center VB - xlCenter is not declared

vb.net,excel,excel-vba,ms-access-2013,excel-2013
Im using Visual Studio 2013 Visual Basic, MS ACCESS 2013, EXCEL 2013 My program Save As the data in my datagrid to excel. I use access 2013 as my database Here is my code: Imports System.Data.OleDb Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Form1_Load(sender As Object, e As...

Securing Access database

password-protection,ms-access-2013
I am trying to secure the database with methods more reliable than hiding the navigation panel and hiding the back-end file. Is there a way to completely password-protect all objects from being modified or accessed? Would this cause trouble when they attempt to modify table data through a form? If...

Data type mismatch in criteria expression Error in VB.NET

vb.net,ms-access-2013
Hi I am getting the above error in VB when attempting the following code, I have 3 text boxes on a form, after the user inputs a stock code I want the form to input the matching product group and product description in the relating text boxes. The code I...

SQL for Aggregate 25 percentile value for subsets in MS Access?

sql,ms-access,ms-access-2013
This gets the 25th percentile value of the GM field when field GICS Sector = "Energy": SELECT tblFirst250.[GICS Sector] , 0.75*( SELECT Max(GM) FROM tblFirst250 WHERE tblFirst250.GM IN ( SELECT TOP 25 PERCENT GM FROM tblFirst250 WHERE tblFirst250.[GICS Sector ]= "Energy" AND GM Is Not Null ORDER BY GM)) +...

Two different formats of field in report Access 2013

ms-access,events,format,ms-access-2013,onload-event
I'm trying to find a way to do the following: I want to have two different formats for a certain text box. To do so, I've done the following: User types one or two digits in a form text box(who's input and format are both "#,0;0;_") and has "yes/no" box...

Select users associated to Approved list/table using Ms Acces 2003/2013 or Sql query

mysql,sql,ms-access,ms-access-2003,ms-access-2013
[Users] ID | UserID | City | Phone ----+-----------+-----------+---------- 1 | John | Rome | 12345 2 | Tom | Oslo | 12345 3 | Simon | Bogota | 12345 4 | Kurt | Tokyo | 12345 [Orders] ID | UserID | OrderNr | OrderName ------------------------------------------------ 1 | John |...

Can you have tabbed windows in access?

ms-access,ms-access-2013
First time ms access user. Just wondering why there are no tabs in access when you open things (tables, queries, forms, etc.) Is there a plugin I can download that fixes this? Access No Tabs...

Sum straight and overtime in single Access query

sql,ms-access,ms-access-2013,jet
I have an Access table containing timecard records for jobs: JobID HoursWorked Rate 101 1.25 101 0.75 OT 102 0.33 DT 101 0.50 103 2.00 I want a query that returns a single record for each JobID that has summed the HoursWorked field. If [Rate] = "OT" then HoursWorked should...

Amount of time between two dates in Microsoft Access in specific format

ms-access,ms-access-2007,ms-access-2010,ms-access-2013
I have a table named "Resolved Request", in which I have two specific columns: Date Assigned and Date Resolved. I have a third column named Time Spent Resolving, which should be the amount of time between Date Assigned and Date Resolved, in days hours and minutes. I am using MS...

Specify Format / set up placeholder for multi-column ComboBox

ms-access,access-vba,ms-access-2013
I want to show a placeholder in a ComboBox if no values has yet been selected or the previously selected one has been removed / deselected. For single-column ComboBoxes that works like a charm using @;"My placeholder" as the Format of the ComboBox. So far so good. The problem starts...

How do I programmatically retrieve the control associated with a given table field?

ms-access,access-vba,ms-access-2010,ms-access-2013
I have an Access database in which every table/view is linked back to a SQL Server object. The tables have been heavily customized. Many of the fields are comboboxes with simple rowsources: SELECT field1, field2, blahBlah FROM blahTable We want to delete a bunch of tables, and I'd like to...

“Merging” tables in Access Web App using Data Macro

ms-access-2013,ms-access-data-macro
I have built an Access Web App (2013) to keep track of device inventory for a client. They want to be able to mass-update the database using Excel spreadsheets that are generated from orders. I already know that there is no way to import/update data into an existing table in...

Where are the MS Access tables I have shortcuts to?

vba,ms-access,access-vba,ms-access-2013
I have a MS Access 2013 file that I am using. There are two possibly related concerns. For some context, this is an MS Access 2013 file with some forms and some tables and a bit of VBA for the logic of how those two interact. For versioning, the file...

How do I avoid the loss of data after I rerun (debug) my program in Visual Studio?

visual-studio,ms-access,visual-studio-2012,ms-access-2013
I want to add a new record into an Access database which is already populated with data. When I initially run (debug in Visual Studio) and add the record, it is saved into that specific table. Then when I close the program and run it again, the record is nowhere...

Syntax error in INSERT INTO statement. (VB and ACCESS 2013)

sql,vb.net,ms-access,ms-access-2013
Forgive me for asking this stupid question but... I really cannot figure out how to solve this syntax error In my database(which is access 2013) I have this fields in my table Fields - Data Types NO - Number RANK - Short Text LAST NAME - Short Text FIRST NAME...

MS Access keep ID field in subform filled with ID from parent form

database,forms,vba,ms-access,ms-access-2013
Everytime I jump to where I can enter e new record, the ID field from the parent is empty and so the connection is lost. I am looking for a workaround. My Setup I have a parent form that deals with two 1:n relationships (school-class --> pupils, school-class --> tests)....

Using LIKE in Count(IIF()) in MS Access, get NA count

sql,ms-access,ms-access-2013,iif
I'm attempting to get a count of NAs in a field in a table in MS Access. I have multiple NAs: #N/A* (i.e. NAs that start with hash & "N/A" & some more text that varies.) NaN NA N/A (They all mean something different for us, so it i actually...

MS ACCESS GROUP BY functions

ms-access,ms-access-2007,ms-access-2010,ms-access-2003,ms-access-2013
What is the function of "where" and "expression" in the groupby? why we are using that in the design query for getting sorted output? Expecting a clear explanation.

Toggle sort order with a command button

vba,sorting,ms-access,access-vba,ms-access-2013
I'm using DoCmd.SetOrderBy for sorting a form by a specific field. But right now it sorts ascending or descending if I use DESC keyword. How can I do a check to see what sorting is active and do the opposite? If that field is ordered ascending and I click the...

Microsoft access embedded macro onclick

ms-access,ms-access-2013
I noticed in the 2013 Microsoft Access Desktop Product inventory template (Go to New -> Desktop Product inventory template -> Explore with sample data button -> A Sample User Login -> Purchases Tab -> Click "New" in the ID column That you will see a pop up when you click...

INSERT SQL Updatable Query using proper MS Access cmd Command

c#,sql,visual-studio-2013,sql-insert,ms-access-2013
Access databse query fails when i run on another machine Config Below Microsoft Word 2013 Visual Studio 2013 Windows 8.1 (64 bit) While On The Another Machine The Same Query Runs Config Below Microsoft Word 2010 Visual Studio 2010 Windows 7 (32 bit) The Query Below con.Open(); string cb =...

How to set focus on a specific radio button within an Option Group

radio-button,focus,ms-access-2013
When tabbing to an Option Group containing radio buttons (Yes No) I want to set the focus to the first entry in the option group but it is being set to the second radio button. I do not want to actually set the value, just the focus. Preferably, I want...

MS Access, populate combobox based on text box entry

ms-access,ms-access-2013
I have an MS Access Form where users enter a store number. Based on that entry, I have it set up so it auto-populates the region that store is in and some other information. I used IIf and Dlookup to accomplish this. =IIf(([Store]>0),DLookUp("[Region]","[Store Listing]","[Store]= " & [Forms]![Project Details]![txtStore]),"") I also...

SQL IF Statement With dates

sql,date,ms-access,ms-access-2013,iif
So I can not seem to enter date or IIF Statement without syntax errors! SELECT iif ([hire_date] = <'#2000-01-01#','Old Gaurd') From L_employees I need to write a IIF statement that checks if [Hire_Date] is before the year 2000 then replace it with OLD PROS, otherwise Young GUNS....

What are the String, LongText and ShortText lengths? Setting Long Text as SQL Parameter results in Error 3001

vba,ms-access,access-vba,ms-access-2013
When I create an append Query in ms-access 2013 with parameters and any of those parameters' type is set to LongText the query fails with error code 3001 Invalid Argument. Changing the type to ShortText however results in a working query. Both version are runnable by double clicking the query...

Access ODBC can't pull from SQL table with more than 255 columns

sql,ms-access,odbc,ms-access-2013
I have a database that I'm trying to query from Access with ODBC. The table I need to read from has 304 columns, and I can only see the first 255 in the Query Builder. I've read elsewhere that the solution is to write an SQL query by hand rather...

Subtract time fields in Access

ms-access,ms-access-2013
I have a table in Access 2013 which will follow the daily attendance at work. In a day, people need to work 8 hours. Here is a screenshot of the table: Column Total is = Time Until - Time From and that is ok. Column Missing has this = 8-Format(24*Int([Total])+Hour([Total]);"0")...

Access SQL query inner join & sum with null

sql,inner-join,ms-access-2013,inventory
Tables: Items, Purchases, QuoteLines. Items has fields ItemID, ItemName, IsActive Purchases has fields ItemID, QtyPurchased QuoteLines has fields ItemID, NegQty, IsSold The goal is to select all ItemID's where IsActive=yes then sum all QtyPurchased and subtract only the NeqQty where IsSold=yes I have tried: SELECT Items.ItemID, Items.ItemName, IIF(NegQTY=NULL, SUM(QtyPurchased), SUM(NegQty+PurchasedQty))...

SQL Calculate the age .use DatePart on DATE()) minus year of birth

sql,ms-access-2013
Find the star number, name, date of birth, and current age of all stars who were born before January 1, 1925 and who are still living. Calculate the age based on the current year (use DatePart on DATE()) minus year of birth. Current Query : SELECT StarNum, FirstName,LastName,StarBorn,StarDied,Datepart("yyyy",StarBorn- date()) AS...

vb.net combobox.valuemember query?

vb.net,ms-access-2013
Hi I have the following code which will pull information from a database table Private Sub frm_8_IncidentResponseSelect_Load(sender As Object, e As EventArgs) Handles MyBase.Load txt_incidentid.Text = frm_6_UpdateIncident.txt_incidentid.Text Dim dt As New DataTable Dim query As String = "select [response id] as responseid, " & _ " ([response ID] &' '&[response...

Unable to update a joined recordset - MS Access

sql,vba,ms-access,ms-access-2013
The following code gives me an error: "Cannot update. Database or object is read-only." I had an implicit JOIN but removed it and it still isn't working. Any help would be appreciated. Thanks! Dim db As DAO.Database Dim rs As DAO.Recordset Dim mySQL As String Dim rsSQL As String rsSQL...

How can I set the window title of a form in dialog mode?

ms-access,ms-access-2013
As the title suggest I would like to now if and how it is possible to change the text that is being displayed as the window title if I open a form as a dialog. Either via macro or vba. I don´t think there is an option in the OpenForm...

Convert rows to columns for a Report

sql,access-vba,ms-access-2013
Using instructions found here I've tried to create a crosstab query to show historical data from three previous years and I would like to output it in a report. I've got a few complications that are making this difficult and I'm having trouble getting the data to show correctly. The...

Importe large csv (>2Go) file into access 2010/2013

ms-access,csv,import,ms-access-2010,ms-access-2013
I'm trying to import a large file (>2Go) into Microsoft Access 2010/2013 but I really can't even start the process of importation. When I choose the file and I validate, I get this error message: The message is in Frensh, and it means; the file doesn't contain any data or...

Access 2013 Complicated SUM on Query/Report

sql,ms-access-2013
I am trying to create a query in Access 2013 that shows the current status and date, while ignoring older status records. I have three tables: customer -id (pk) -last -first status -id (pk) status description status-customer id (pk) customer_id status_id status_date notes I would like to create list of...

Microsoft Access can't represent the join expression “<=” operators

sql,ms-access,ms-access-2013
I have the following SQL SELECT a.StudentsID, a.ClassGroup, a.FinalGrade, COUNT(*) AS ranknumber FROM FinalAVG AS a INNER JOIN FinalAVG AS b ON (a.ClassGroup = b.ClassGroup) AND (a.FinalGrade <= b.FinalGrade) GROUP BY a.ClassGroup, a.StudentsID, a.FinalGrade HAVING COUNT(*) <= 3 ORDER BY a.ClassGroup, COUNT(*) DESC; It works well. However when I switch...

Calculated field with value from another table in Microsoft Access

mysql,ms-access,ms-access-2013,calculated-field
I have a calculated field in a table that needs to take the value from another table but in the expression generator window it doesn't allow me to choose values from other tables. Then, I tried to create a form from the table, and put in the source control the...