I have one account but it continues to receive the same emails over and over. It will duplicate the same eamils every day and does not delete them off the server.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.