Search results
-
A
Finding second to last value
I'm trying to find the difference between the last integer and the second to last integer in a query. Any tips? -
A
Display last column in which row contained data
Hi there, I have a table that looks like the following: Name, Q1, Q2, Q3, Q4, Q5, Q6 ABC 3 , , , , , 2 CCC , , 4, ,5, 4 Sorry for the messing output, in essence, ABC has values for Q1 and Q6 only meanwhile CCC... -
A
Display last column in which row contained data
Hi there, I have a table that looks like the following: Name, Q1, Q2, Q3, Q4, Q5, Q6 ABC 3 , , , , , 2 CCC , , 4, ,5, 4 Sorry for the messing output, in essence, ABC has values for Q1 and Q6 only meanwhile CCC... -
A
Adding textbox to form based on select query
I am using a union query to show the # of absences of staff, and if they are classified as "stage 1" they are to be given a letter stating that they are in "stage 1". Now the date in which the letter is delivered is to be inputted. That's where i'm stuck. How would I go about adding a input... -
A
Comparing 2 rows in access
Hi, I need some help with a report i'm working on in access (but this will essentially be based off the control source a query). What I have is a table with data that lists delinquency in terms of staff attendance. For example, if person A has more than 3 absences in Quarter 1, then they are... -
A
Adding 2 time fields together
Hi, I have 2 time fields and I want to add them together. First, i think that i would convert them into minutes then just add the minutes together. For example, time 1 = 07:30 time 2 = 02:15 answer should be = 9:45 or 9 hours, 45 minutes how would i go about doing this? -
A
Help needed in developing different stages on report
Comparing 2 rows in report Hi, I need some help with a report i'm working on in access. What I have is a table with data that lists deliquency in terms of staff attendance. For example, if person A has more than 3 absences in Quarter 1, then they are in stage 1. If Person A has more than 3...