Recent content by analyst1
-
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
To paint a more clear picture, it isn't an actual table but rather a view. My DB will consist of a table that is routinely appended to, but will always remain with 5 fields. The view I created looks at how many absences they have in each quarter (1 of the 5 fields). I want to know if theirs a... -
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
Didn't work, as I'm still receiving the same problem. Is it even possible to enter data (via a form) into a union query? -
A
Adding textbox to form based on select query
The Date Delivered field is currently empty, and I want the user to enter in the date of delivery via the txtdelivered text box. I entered in the parameter as you suggested but I'm receiving the following error: "Microsoft Jet Database engine does not recognize 'Forms![Stage]!txtdelivered as a... -
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
Export Access Query to Excel
The exact coding i'm using is: Private Sub cmdtransfer_Click() Function test() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "ASP", "C:\Databases\Access to Excel.xls", True DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "ASP2", "C:\Databases\Access to Excel.xls"... -
A
Export Access Query to Excel
I've tried madrav72's code, and replaced his query name (Master summary) with my own (ASP), but i cannot get it to work. Any help? -
A
Comparing 2 rows in access
I've copied it into 2 separate modules, but am not sure as to how to trigger them? -
A
Comparing 2 rows in access
What if I was to create a reports form in access, where I can click on a preview report button (report would show the query above), but only the report would be outputted in excel? how would I go about creating a report in excel based on access information? -
A
Comparing 2 rows in access
Its not actually a table, but rather a query. I've renamed it to ASP2, but am still seeing the same problem. Would this not be easier to accomplish in excel? It can't be that hard to compare 2 rows (in same table within access). -
A
Help needed in developing different stages on report
Does that clear up any questions you may have? Any advice? -
A
Comparing 2 rows in access
Sorry, if staff has greater than 2 absences then they are in a stage (stage varies based on if this is their first offense). I copied the following with ASP being the table name, and received an error stating: "unknown" SELECT DISTINCT ASP.emp_name, ASP.quarter, DLookUp("[# of...