Recent content by kaherdin
-
K
Two text boxes, save the first two letters of each input
Hi I want to be able to have two text boxes on my form that firstly concatenate the values inputted and then saves this string to a field. It's a "new record" form that generates a new record in table "tblUsers". txtB1 & txtB2 and the text boxes would represent First Name and Last Name... -
K
i need formula day * time
In "weergave", click till small small down-arrow, click SQL. There you will see the acctual SQL statement. Copy that here inside "[CODE]" -
K
Evaluate how many orders where open on specific day
Ok, so here is my solution. The question I had was; How can I visualize, show or see how many orders, records or posts where open (i.e. not finished or closed) on a specific date? I began with 2 tables; 1. tblDates This table contains only the dates I want to evaluate, in my case all dates... -
K
Evaluate how many orders where open on specific day
pr2-eugin I "just" want a count of how many records (orders) that where open on a specific date. I.e. Date Count(Open) 2013-01-05 3 2013-01-06 4 2013-01-05 7 The Overlapping records-templete is extremly usefull and I will implement it when looking at "Orders open during week XX" or "Orders... -
K
Evaluate how many orders where open on specific day
This is a part of the question at hand; I want to evaluate if; ReportDate falls between DateOrderMade and DateOrderdAnswerd That would result in that that specific OrderID was "open" during that date (ReportDate). To join these two tables at query level wouldnt be an issue, but I dont know a... -
K
Evaluate how many orders where open on specific day
- Yes, true that. This is the complete SQL code from the query SELECT tblDates.ReportDate, tblOrders.DateOrderMade, tblOrders.DateOrderAnswerd, Sum(IIf((([DateOrderAnswerd]>[ReportDate] Or [DateOrderAnswerd] Is Null) And ([DateOrderMade]<=[ReportDate])),1,0)) AS OpenOrders FROM tblDates... -
K
Evaluate how many orders where open on specific day
Access 2010 seems to have som issues with the SQL code here. I tried to tweak and check for missing ")" or similar but it wont run... -
K
Evaluate how many orders where open on specific day
Because of the fact that I'm not using the english version of Access 2010 at my workplace, could you maybe explain (or just attach a screenshot) of how you mean the SQL code should be implemented, including the "count" code. I really appreciate your help, as this is sort of a big deal for me... -
K
Evaluate how many orders where open on specific day
EternalMyrtle This is what I am trying right now. And, from the look of it, it works well. This is what I was looking for and the actual tweak I was lacking before viewing your suggestion was the use of one expression and one criteria together. SELECT tblDates.ReportDate... -
K
Evaluate how many orders where open on specific day
As I am saying in my OP, I'm trying to show per date (day) how many orders that where open that specific date (day). What you are suggesting is great for showing when the orders either were made or answered. -
K
Evaluate how many orders where open on specific day
Evaluate how many orders where open on specific day This is one part of a, for me, large access 2010 project I’m trying to develop for my workplace. Background I want to be able to show a chart, a graph, of how many open orders we have had during the last month (showing per day) and during...