All Questions
130
questions
-1
votes
2
answers
39
views
how to have a calculated field viewable within a form in real time?
How do I have a database field that provides a calculation in real time, i.e when the user is entering data into the form?
I tried to run an afterUpdate event from the field in the form labeled ...
- 11
0
votes
0
answers
108
views
How do I make an MS Access Query to show totals by ID
I have been trying to make a MS Access database to record and report on my organization's volunteer hours. Our volunteers give us monthly timesheets, which we input through a form as we receive them. ...
-1
votes
1
answer
572
views
Creating a relationship with a calculated field
I am trying to create a relationship between 2 tables in Access. In one table I have customers, in another I have areas by postal region. In the customers table I have all the usual address ...
- 223
0
votes
1
answer
109
views
Best way to organize junction table
I'm currently building a small database on MS Access for upgrades (45) on several machines (30) on a factory. The info is on an excel spreadsheet where rows are the upgrades and columns the machine. ...
0
votes
0
answers
49
views
Adding multiple hyperlinks MSAccess
so I am creating a database that contains news reports.
For many rows, I want to be able to add multiple hyperlinks as the content is based on multiple articles online. I came up with making two ...
- 135
0
votes
0
answers
136
views
Make a DB only accept a record if a column contains a certain string
I'm writing a simple database to record some entries about swimwear.
Consider the following table:
Genre
type
unique-code
man
boxer
b-150
man
boxer
b-151
man
slip
s-200
man
slip
s-201
I'm ...
-1
votes
2
answers
26
views
Why does not this expression work in MS-ACCESS SQL View
SELECT
Pname,
Dname,
COUNT(WO.Essn),
SUM(WO.Hours)
FROM
PROJECT AS P,
WORKS_ON AS WO,
DEPARTMENT AS D
WHERE
P.Dnum = D.Dnumber
AND P.Pnumber = WO.Pno
GROUP_BY Pno
...
- 1
0
votes
1
answer
32
views
Primary Key in Access
I should create a database on ms-acces. I uploaded the relational database schema. I've created the tables for employee,department,dept_locations,project and dependent.I've assigned the relationships ...
- 1
-1
votes
2
answers
606
views
Is it possible to force a relationship to be one-to-one instead of one-to-many? if not, then what?
I have a database assignment due very soon and I am wasting a lot of time on the wrong things.
To keep it simple, I have a table called Character that draws info from many tables, one of them being ...
- 33
0
votes
0
answers
90
views
Save inputted data from a bound form to a table
I'm having trouble saving inputted information from a form to a table on MS Access, any help would be greatly appreciated.
I have a table : Inventory,
and a bound form to that table : InventoryForm
I ...
- 1
0
votes
0
answers
51
views
Using tables to categorise resources with
I'm trying to design a database that allows for filtering according to if a specific resource fills certain categories. I've gotten to the point where I can input data that seems to be how it should ...
- 13
0
votes
0
answers
29
views
In Microsoft Access (for 365) is it possible to automatically create a new table depending on entries made in another table?
I have one table with orders (Orders Table). In the Orders Table I have a checkbox for production to run. When the checkbox is ticked in the run column I would like it to create a new table ...
- 1
0
votes
0
answers
43
views
Can I Fix the a lookup field in Access database based upon a calculation or another field?
I am trying to create a database with field descriptions for a very large excel file that I have at work. I have created 3 tables- List of sheets, list of variables(including a lookup field pointing ...
- 85
-7
votes
2
answers
284
views
Query for students passed or not passed in specific Subjects [closed]
I have a Table with Column Headings:
ID Student_Name
Roll_Number
Subject1MarksObtained
Subject1TotalMarks
Subject2MarksObtained
Subject2TotalMarks
Subject3MarksObtained
Subject3TotalMarks
...
0
votes
1
answer
58
views
In a form, how do you display data from 2nd, 3rd degree child tables that are separated by different relations?
I am trying to display data on a form taken from a table that is immediately linked to one relation, and data from a third table that is linked to this second table by another, unique, relation.
I ...
- 9