Search results

In the attached spreadsheet, I want to find the total resource loading for a particular day. Each task has a start and end date and I want to find to sum of all tasks that fall within that date. I don't even know where to start with a formula...

I have two tables, tblProducts and tblShopping_List. Each table is configured as described below: tblProducts: ProductID - Primary Key (Autonumber) ProductName (Text) CategoryID (Number) - Linked to tblCategory tblShopping_List: ShoppingListID - Primary Key (Autonumber) ProductID (Number) -...

I would like to do a crosstab query, but also display all possible Null combinations, not just the rows and column where a value is present. Is this possible and how would I do this?

I have a summary form based on a query. I want the form to automatically update and reflect any new or updated records when I select the save record command button on a "Add Record" form. Currently, I cannot get the form to update, but the query itself shows the new info. It isn't until I...

I have a table with a three digit number field that I query and concatenate with another field to display an ID. However, the three digit format is lost during the query if there a leading zeros in the number. How can I maintain the three digit format during the concatenation?

I have a form the the user selects a domain via a combo box. I want to create an incremental ID so that the actual ID generated is a concatenation of the Domain selected + a three digit incremented number as text. How can this be done? I am currently inputting the IDs in by hand but want to...

I currently have a select query that counts the number fo child records for the parent record as follows: SELECT tblAV_Fail_Cases.Failure_ID, Count(tblFMET_Test_Cases.Failure_ID) AS NumofTestCases FROM tblFMET_Test_Cases RIGHT JOIN tblAV_Fail_Cases ON tblFMET_Test_Cases.Failure_ID =...

I want to include a count field on form to indicate to the user how many child records belong to the parent record. The form's source is a table and the source for the count is a result of a query. The key fields are related in both the query and the table. How can I show the count info on...

I have a table that shows the the status of the record as "Not Started", "In Work" or "Complete" I want to count the number of records that fall into each category. I am currently doing the following SQL: SELECT tblTest_Case_Status.Test_Case_Status, Count(*) AS NumberofRecords FROM...

I am trying to filter data on a form based on user selection of criteria from two independent combo-boxes. Here is the code I have so far: Private Sub Combo9_AfterUpdate() Forms![frmDF_AV_Fail_Cases_Summary].Form.Filter = "[1st_Fail_Domain] = '" & Me![Combo9] & "'"...

I have a field on the form that is suppose to indicate when the last edit to the record occured. I was trying to get it to fill in the date on the users machine when the save record command button was depressed. How would I do this?

I have a table that lists single failures, I then run an append query to create a table of dual failures of every combo of the single failures. I am trying to create a form that lists only the dual failures associated with a particular failure and here is the criteria I have below...