Search results for query: *

I need to sum up volumes by weeks. I wrote the query but the problem is my company weeks do not match access start week. Example 12/26/2004 - 1/1/2005 is week 53 in access but for my company this is week 1 for 2005.

My graph has data from 3 different areas. When I run the graph it displays all the data from all areas on one graph. I want to display one graph per area.

I want to not change a text and combo box each time I enter data. If I enter a "5" in a text box I want that "5" to keep being entered as I click my add data button. The only time this number will change is when the user changes it. I also need to do this with a combo box.

I have a table that I record products we order. One table has all the products and everything about them. From a form I select a product (from the product table)and record the # of units ordered and current price from my master products table. This works great, the problem is when I have a new...

I write the date on my report with this statement from a form. What I need to do is show this information minus 364 days. I can do it in a query but can not doit on my report... ="Previous " & [Forms]![frm_bm_Report]![txtStartDate] & " to " &...

I want to query between 7:00 am and 8:00 am on my list of time and date stamps. I have a table filled of numbers each number has a date time stamp. I want all the records between 7:00 am and 8:00 am over a date range. When I do the date range it brings all the records between the dates not...

In my form (frm_bm_Report) I have this code Select Case optuniloy: Case 0: txtuniloyReportHeader = "All Uniloys" txtuniloynumber = "*" Case 1: txtuniloyReportHeader = "Uniloy 1" txtuniloynumber =...

I want the information on my report to look like this list. What I cannot do is I want to have 2001 one the right side and the 2002 on the left side. Then give a percent change between the two numbers. I can do so code just can not get started.... Reason Sum Of time down...

I have a continous form that requires when I change the date txtbox at the top of the form. What I want to do is bring up a date look at the records that add to those records with the date I type in the txtbox at the top of the form. What is happening whan I put a date in the box it requires...

I hope this can be done NEED THE HELP. Counting in binary I have a excel worsheet. Cells a - p are my cells I want the ones and zeros to show up on. In cell Q I want to type a number and the correct 1 or zero will show up in the cells a - p that make that number up. For example if I type a 3 in...

The query below does just what I want it ot do, but I want to add one more thing. I want to add total minutes for the same date range but one year prior. If the date range is 1/1/01 to 1/1/02 I want the same data for total minutes dates 1/1/00 to 1/1/01. I am doing a minutes comparison for the...

This gives me all the info I want but does not sort by weeknumber. It sorts by the average. I need to sort by weeks for the graph. I tryed all the normal ways of sorting I can think of I know I am n\missing somethie easy... TRANSFORM Sum(qry_first_hour_weekly.AvgOfGPH) AS SumOfAvgOfGPH SELECT...

I want to display information from a excel cell onto a form txtbox any ideas how. I'm sure it is easy can not think how...

In excel I have one row with all the data that is linked to another app(rslinx). Each cell is updated real time each second with data. What I want to do is at a time I request (say each hour) it will add this data to a access table. I know how to link everything what I can not do is add a new...

I want a report that will display the data this year and last year at the same time.

some how I turned off the promp to save the changes on my data base. When I make a change to a form and close the form it just closes and saves the changes with out a prompt to ask yes or no to save the chages.

Problem... I need the combo boxes to keep the data selected and not clear when the enters a new record. Also, I need the data to stay until user selects something else in the list. It is not necessary for the data to be tied to a field in the table. I can not figure out how to get this result...

I have a combo box with a parts room number say 800d23da All my parts room numbers have the 800 prefix number. I do not want to look at this prefix. In my combo box I would just see for the above part nummber is d23da not sure how to hide the first couple ot letters? I am sure it's easy not...

I want to sum my items by the criteria I choose. I have a status coloumn and a items coloumn and qty coloumn. I want to sum up the qty by items by the criteria in my status. Item qty status stuff 5 on order stuff 10 received stuff 2 adjust inventory...

If the user types in a box lets say date then exits the form I do not want to record this. I have code to check that all the information on the form is filled out before adding the record, but how do I not record the information if they exit the form with out filling out all the fields?.