Reporting Time Fixed As A Daily Variable
Mar 18, 2012
The previous problem stands solved i.e. ReportTime field shows 9:50 always.But it has created another problem as under
The Formula for ReportTime : Format(Date(),"m/d/yyyy") & " 9:50:00 AM"
The formula for ReportedAt then becomes as ReportedAt: Format(Now(),"hh-nn ampm")
And the next step LateByMinuts:=IIf([StatusID]=1,DateDiff("n",[ReportTime],[ReportedAt]),0)
Where stutusID is
1. Present,
2. AbsentExcused.
3. LeavePrivelege etc.
is correct for the first time.That is when at the first time the Reported time (system time) is recorded it works fantastically but when next time the Form is opened the saved "LateBYMinuts" field is changed with the system date thus disparaging the previous save data.
View Replies
ADVERTISEMENT
Jun 5, 2013
Query of daily activities spent hours
1) to be group as weekly total
2) then need to transpose it for reporting.
My table fields are Date, SpentHrs and Code (activity code description).
View 11 Replies
View Related
Feb 25, 2014
I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent.
i.e.
treatment1 : 8 hours
treatment2: 10 hours
this will give 06:00 in short time. in medium time it will give 18:00.
however if I add another 12 hours to that it will give 06:00.
I want it to show either 1 day and 4 hours /or 30 hours.
View 7 Replies
View Related
Feb 18, 2014
Access Query. I am creating a time sheet / pay roll database and I want to be able to get a total of the daily hours in a query.
For example I have 'Mon Start' and 'Mon Finish' for Mondays in/out times and I have a 'Mon Total' which gives me the total hours worked for Monday.
The problem I have is that Mon Total only works if the hours are say between 07:00 and 17:00, anything after midnight (00:00) like 21:00 to 07:00 and 'Mon Total' goes crazy !!
At the moment 'Mon Total' is the result of CDate 'Mon Finish' - 'Mon Start' (bit rough I know).
View 3 Replies
View Related
Dec 20, 2004
Hi Everyone,
I am new here...need your help.
I am trying to sum a field which is defined as a Date/Time field
and is a substruction of Time1 - Time2. at the end of the month, i would like to sum
all these fields in a query. the problem is, the fact that i sget the SUM result as a daily
hour and not accumulated time (i should get like 92:35 Hours, and i recieve 3.45 coz it divids by 24).
How can i format the field to be (like in Excel) an accumulated sum of the hours...is it possible to do
without VB code?
Thank you very much..
PS - Sorry for my bad English
View 2 Replies
View Related
Feb 3, 2005
i noticed that if access is open for a long time
the globals return null
can i set the time of a global variable?
View 1 Replies
View Related
Jun 27, 2013
I have a variable (dtDueDate as Date) showing as 6/28/2013. I want to append a time value to it (dtMaxTime as Date) which is 5:00 PM so dtDueDate reads 6/28/2013 05:00:00 PM. I have been going in circles trying to figure this out. My goal is to append this date to a table field which has a datetime (General Date).
View 6 Replies
View Related
Feb 18, 2014
In VBA, how to compare date variable with date/time field from table, as when defined the data type in table, date/time option is the only choice for date data type even though I don't want the time portion.
View 13 Replies
View Related
Apr 16, 2013
I am creating a 2 level report to confirm an order. Main report already created, runs successfully called as subform/subreport under "OrderDetails" form. Linked to master using Order.ID. There are two versions of the confirmation report that have different layouts for different program types.
The hangup comes when I try to add a "Class Dates" subreport. It lists dates of individual classes and Skip dates. I have created the subreport as "srClassDates". When I add it to the main report, it lists the records. However, when I try to link it to the Main report, an error message box appears with the "object variable or With block variable not set".
I have tried rebuilding both the main and subreports, rebuilt the query, have not found anything that changes the result.
Linker has been working successfully on other subforms. Report with groupings works fine, but I need data from 2 tables both linked to order.id.
View 2 Replies
View Related
Sep 26, 2005
Is it possible for someone with access xp to look at reports made in an .mde file.
View 3 Replies
View Related
Nov 10, 2006
I want to create a report that will generate from a specific date then have as the second criteria i want the date to change to what ever the current date is
Is this even possible or am i just wishing????
Anyone able to help? :)
View 2 Replies
View Related
Jul 8, 2013
Error 91 - Object variable or With block variable not set
I am getting this error telling me that an object variable is not set.
I know which variable it is but when I step through the debugger it sets the variable and all is fine? Issue is that public variable of a class is not getting set when the VBA Editor is not open?
View 14 Replies
View Related
Oct 3, 2014
This code runs fine the FIRST time, however trows up a message the SECOND time it is run.
The error is on the line ".Range"
I am trying to sort records which have been exported to Excel.
Dim LR As Integer
LR = 5
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set wbRef = xlApp.Workbooks.Add
With wbRef
wbRef.Activate
.Worksheets("Sheet1").Activate
With ActiveSheet
.Range("A2", .Cells(LR, "O").End(xlUp)).Sort Key1:=.Range("C2"), Order1:=xlAscending, Header:=xlYes
End With
end With
View 3 Replies
View Related
Oct 22, 2004
I've got a table with CAR_ID(pk), supplier_id, Company_name, KPI, and warehouse. I need it to do a count total for me.
I.e.
query gives me this:
s4001, 1111, ibm, ship, atlanta
s2001, 1111, ibm, ship, atlanta
s3001, 1111, ibm, price, atlanta
s5001, 1111, ibm, price, atlanta
s6001, 1111, ibm, quality, atlanta
I need it to do this
1111, ibm, ship, atlanta, 2
1111, ibm, price, atlanta, 2
1111, ibm, quality, atlanta, 1
So if the supplier_id, KPI, and warehouse all are the same then it just counts total number of CAR_ID
View 2 Replies
View Related
May 17, 2005
Hello
I have a report reading off of a query, the query shows an #Error
whenever the 0 spend is divided by the 0 potential. In the report i would like
this #Error to show as N/A. I tried =IIf([BY PROGRAM BY UNIT 30 DAYS.AdminRate]="#Error","N/A",[BY PROGRAM BY UNIT 30 DAYS.AdminRate]) but it doesn't work. can you suggest something else?
thank you
View 2 Replies
View Related
Jun 24, 2005
Hi,
I have an issue with reporting in Excel. A table has a Fax Id field which holds unique Fax Ids. The ID is a unique number given to a fax received. The fax is processed by an employee and the table stores the employee id and fax id processed by him. I have a query which pulls up the report. I take the report by opening an excel sheet and running the query through New Database Query from Import External Data from Data Menu in Excel. In the report, sometimes I get same fax id getting repeated for each employee. For eg, if an employee has procesesed 50 faxes for the day, the same fax id gets repeated 50 times, though in the database fax id are stored correctly. What could be the reason?
View 2 Replies
View Related
Jul 29, 2005
I am currently trying to do a total of several fields in a report. The fields in the report do contain null values. I have been trying to write this through VB but I am getting the error that I can not seen to get around. The thing I am trying to do is to us a single variable to add the total up by using if then statements. But in the end it will not let me update the final total. The total field is a unbound field.
View 3 Replies
View Related
Nov 7, 2005
Hello,
This is a simple question.
In my application I have the option of selecting different check boxes (6 different options). My database is storing the values 0 and -1 for nonchecked - checked boxes as it should be.
Now, I would like to create a report to display which values were selected from the options above but I don't know how to do it as if I display the values, I will only get -1 and 0.
Is there a way I can convert again or I can give the check boxes other values in order to be able to report them with their original names ?
Thank you
Gloria
View 3 Replies
View Related
Aug 8, 2007
I am creating a database in order to log in the location of certain files based. I began by creating an entry form with fields for "Individual", "Committee", "SubCommittee", "Issue", and "Location". Once entered into the form, the data is stored in a table. While I managed to do this with relative ease, I also created a search form that mimics the entry form in requested information.
However when creating the query to conduct a search I am missing data. Basically the query pulls information from the "Location" table, the "Individual" table, and the "Issues" table. Unfortunately if the "Individual" is left blank on the "Location" table, even if I am searching by issue, the query will exclude this entry in the final output. In otherwords, if I am searching by an issue, say education and there is an entry that is not related to an individual (in the Location table), that entry will on be displayed by the query, eventhough it falls under the parameters of the search
Any suggestions?
View 4 Replies
View Related
Jul 31, 2006
Hi,
I have read through a few posts but none seem to resolve the issue I am experiencing.
I have a form with a FilterByForm button. This works fine. I also have a button that is supposed to display the results of the filter on a report. Everytime I click this button it prompts me to enter a parameter value.
Here is the code I am using for the button:
DoCmd.OpenReport "Temp", acViewPreview, , Me.Filter
Any help appriciated.
View 5 Replies
View Related
Nov 19, 2004
Hi all,
I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?
Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.
Thanks for any feedback.
View 1 Replies
View Related
May 4, 2008
Hi Everyone,
I have an Access Database with an Appointments and Expences table which are unlinked and have no common fields. I want to create a profit and loss report using these unlinked tables. The Appointments table has the fields "apptdate" and "apptcharge", The expence table has the fields "expdate" and "expcharge". I would like to create a report that shows a summed total by month and a Appt minus exp to show the profit per month.
I am having trouble as no fields are linked, the dates of the expences are usually different to those of the appointments. I have even tried with Crystal Reports but this only lets me do it in sub-reports and I can't use the combined data for any totals.
How do other financial databases do this simple function? is my table design flawed?
thanks for your help
Peter
View 3 Replies
View Related
Feb 2, 2006
I want to create reports for each year my company is in business but by my fiscal year Oct - Sept instead of then normal Jan - Dec. any ideas?
Thanks in advance
View 2 Replies
View Related
Jan 21, 2008
I create a Job with a number such as E649 (excel) I then log each employee hrs by date as they worked on this job. I also put cost of material and outside services charges, shipping and invoicing information. I then have to produce a report for this number with all the time, expenses and invoicing. I have been trying to create this on access. Do not know how to get a report on just on particular number. Help
Thanks
View 6 Replies
View Related
Mar 12, 2013
how to delete footer in reporting? my report form has 4 footers. i dont know how did it all appear. all i need is the page footer. but, i dont know how to delete the extra 4 footers.
View 2 Replies
View Related
Aug 20, 2014
I look at a lot of files to see when they were last updated. I wanted to write a generic procedure to manage that so ..
Code:
Public fDate As Variant
Public vField As String
Public vFile As String
'GTSdata
vField = "txt_gts_data"
[Code] ....
What I hoped Me.vField would do is update the date field [txt_gts_data] on my form with the date the file was last saved.
i.e. me. txt_gts_data = fDate
What actually happens is the variable vfield gets updated from "txt_gts_data" to 19/08/2014 then later code falls over because the fieldname is lost .
Me.[vField] corrects itself to me.vField (and does not work)
Me!vfield falls over (cannot find the field vField, not surprising J)
How do I say update the contents of the variable, not the variable itself?
View 7 Replies
View Related