Search results

Hello, I have yet another question in regards to Access. I was tasked to figured out how to graph data historically by day that is generated by a SQL query of expressions. I currently coded a SQL query to formulate the numbers needed, but have no knowledge of how to graph it historically...

Hello, I have a table in a form to track changes to items in source table. Items are copied in by selecting the items in drop downs and after a button click the item needing editing is copied into this tracking table. Now what I want to accomplish is too build a query (ultimately to drive a...

I have created a form that will allow a user to browse for a excel file and then import the excel spreadsheet into a tempTask table and then I want to do a update query on the main source table called Task. Both tables have the same number of columns and same field names but the update query...

I have form that displays mutiple queries in pages (the queries are subforms). What I am trying to accomplish is that upon selection of a value in the combobox I want to have the ability to filter all the queries based on that value. Currently, I can get it to work halfway where the filters I...

I have this query setup to produce summed values and it works fine. Now I am trying to display the output of the query in a pivotchart however it does not seem to pull all of the data in the query. My mock data table has three test cases in it. And it seems that this query will only show 2 out...

Hello, I am trying to create an export function in Access to export a query with filter that is controlled by a combo box then export the query to Excel. So far I browsed this forum and other sites and put together the VBA code that was used by other to try and accompolish what I want...

I have a select query with a number of expressions and I cannot seem to get the expressions to work. Access keeps giving me syntax error on the following code: SELECT Run.Test_Case, Sum(IIf(DateValue([Attempted_Actual]) < DateValue([Attempted_Actual]),[Points],0))/Sum(IIf(Not...

I have encounter a rather wierd error within Access where it seems that somehow when I was making alterations to the form(adding a page) then saving the form Access seemed to have deleted the query the drives the form and the form becomes blank. A message pops up saying there needs to be a...

I have a problem trying to sum a numeric column based off another column in the same table. What I am trying to accomplish is to sum a numeric column if a corresponding column is Not Null. I have uploaded my sample DB that to illustrate my problem. The query I am testing with is called Query1...

I have a sum query issue I am trying to work out and I have trouble trying to coordinate it.I am trying to build sum queries inside one select query that would allow me to sum point values in a separate table. The problem I am foreseeing is that I have three tables all connected with...

I have a form with drop down boxes that list 3 related fields and I have a search button that will requery based on the the input from these boxes. These boxes are all prepopulated with the data and I want to be able to select something from Box1 and then based off Box1 change whats populated in...

Hello, I am struggling writing criteria that is based off of multiple combo boxes in a search form. I basically have a form setup in several pages the first page being a search page. This page consists of three combo boxes which are populated from the tables. These three boxes are all related...

I have a main form setup with pages the first page (page0) is a search page which has combo boxes to list the items in 2 separate tables and the user will be able to pick selections and view those selections in the other 4 pages. The other four pages consist of a subform that is a query. These...

I have a chart to build using data from my Access Database. Most of the data is coming from one table but I am having a hard time finding a way to build a chart in Access. So my thought was to import data from the Access DB and send it to Excel that way I could format the data into columns and...

I have a query that pulls out dates from a table and I am trying to build a formula in the query so it can tell me whether or not that item in the record is either on-time, due today, or overdue. There will be two date inputs a planned date and a actual date. A simple example is this: Status...

I have a from with several pages that house queries. What I wanted to accompolish was a simple search to narrow down the data in the queries. I added another page to the form and setup combo boxes that have a record source to the appropriate fields I want to search by. I also have this line of...

I have a issue where I have a relationship that is a one to many relationship that relates FieldX in TableA to FieldY in TableB. The problem I have is that I made separate forms that inputs data into the tables but it does not relate the two. How can I make the forms establish the relationship...

I have a table that has two fields which I want to sum the one field based on the other field. The field I want to sum is a number data type and the other is a text data type. My research has pointed me in the direction of using this line of code. totalP = DSum("[FieldX]", "TableName"...

I am trying to build a function that allow me to compare dates and based on the dates relevance to current date. I have a table that has several fields of dates and I wanted to be able to color code them accordingly. My questions are I want to be able to do this in a form or series of subforms...

I have general question about queries and data entry form working together. I have made a drop down list that queries a field spitting back all of the entered data in that field. The next action I want to do is upon selecting a certain item from that list I want to enter in the selected item...