I have a query in MS Access that is linked to a searchable report which is linked to a form. Part of the report ask users to include two reasons that will be used as criteria for a query. Currently, the report (screenshot) below does not allow for users to simply enter in 1 reason. Users must enter in 2
Tag: ms-access-2007
Access number identical fields with decimal number
I have a Table in Access and some field values are identical. If the field values are identical I want to have them numbered with decimal numbers. Is there a way to do this with SQL? Below is an example of my table and what I want to do. Answer You can use a query having two subqueries: Output:
How to display a list of departments whose teachers teach DBMS department students?
I have a database in Access. The database has 4 tables: [DEPARTMENT], [TEACHER], [LECTURE], [SGROUP]. I need to display a list of departments whose teachers teach DBMS department students. The …
SLOW running query in MS access
What causing this query to execute long time. Is sub query block creating a mess? Answer I believe that the problem is that for every record of the INNER JOIN you are looping over all the records of the WD table.