Search results for query: *

I have finally figured this out, here is the magic query that did the trick: TRANSFORM Sum([Logout Time]-[Login Time]) AS HoursWorked SELECT [First Name] & " " & [Last Name] AS [Agent Name], Sum([HoursWorked]) AS [Total Hours] FROM tblEmployee INNER JOIN tblTimeSheet ON tblEmployee.[LAN ID] =...

I currently export an MS Acess crosstab query into excel spreadsheet, in order to calculate total hours worked by each employee, every week. Time format within each field is similar to numbers e.g, 0.32869213. Formatting 0.32869213 into short time within excel, hh:mm, equals 7:53 (7 hours 53...

Hi Skip, Thanks for the useful advice. I thought i could get away with the Format function by appending "h\hn\". i have removed the format function, and changed "Date to Dates", but still can't figure out why TRANSFORM ([Logout Time]-[Login Time])*24 returned decimal numbers again...

i have designed a crosstab query from a table with fields containing DATETIME datatype, to produce a report showing employee start time, and end time, for sets of specified dates, e.g "Current Week". here is my query: TRANSFORM Sum(Format([Logout Time]-[Login Time],"h")) AS HoursWorked SELECT...

hi, yes I am opening a record set from the query, in order to view calculated totals, based on dates. e.g monthly total. my recordset is below: Dim rstReport as DAO.Recordset Set rstReport=dbase.Openrecordset("qryReport") rstReport.Findfirst("[order_date]='"& me.txtdate &"'") If Not...

hi all, I have a SELECT query (qryReport) based on two tables, tbl_Customer & tbl_Order, I am using this query to generate a routine calculation, of total cost and profit, from periodic sales transactions. I also set up a form, with two textboxes and a button, for users to enter dates and...

hi PHV, Thanks for your response. This database was not splitted into BE+FE, a single compiled .mdb file was installed inside a network folder. A hyperlink of the database path, was sent to all users, to access it at the same time. Thanks.

Hello all, I have an application running on Access 2003 version, installed on a shared network folder. The database is accessible to more than 15 employees at a time. We have installed the full version of Access 2003 on all workstations. Therefore, i don't believe it's a reference or run-time...

@dhookom yeah, i know that, not a common or best way of doing things. But what you have to understand is this, the main purpose of this project is to create "new notes" ...something like an "Auto Noter", whereby entries by a user changes every minute. So, what i did was to collect those...

@dhookom. I decided to nest my data inside my codes because of the following reasons: I have series of notes that needed to be concatenated together with sets of other values, to produce dynamic results. For example current date, current time, 5point signatures of different employee across...

Oh yes, absolutely correct, i have multiple 'option buttons' and they are all in separate groups. See, the problem with Check boxes is this, there's no way to code the "Onclick" Event of a check box. That would have been the smartest way of doing things. Well, problem solved now :) Thanks

this has just been resolved, i tried something along this line, Select Case True Case Me.OptionTerminate1.Value And Me.OptionOther1 Me.txtNote = Tc1 &" "& Other1 End Select Where Tc1 and Other1 are variables, with different values assinged. And it worked, perfectly!

hi Andy, Thanks for sharing that neat trick, Now, what if i am selecting more than one option, at a time? for example up to 5 options. Any clue as to how series of results may be generated?

Hi TheAceMan1, Thanks for adding your thoughts, regarding this issue. You are correct, i initially had series of independent option buttons placed on my form, as specified within my first post. I chose to use each options independently because of the nature/specific requirements of my...

Thanks Majp, i thought about Using a Case as well, but my project involved selecting not more than one option at a time. Although, strange enough, i have now resolved this issue, by twitching around my code a bit. This was how i did it, Validating each options in the group, so that when an...

i have now resolved this, by assigning an operator to line 2 here: Me.txtNote "Welcome on board" corrected as : ME.txtNote = "Welcome on board" Thanks

Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...

Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...

Thank you all for your the input. This is now resolved. I simply altered the table, which the "MakeTable" query is selected, adjust the property Look up option to "Check box", so when my query runs, i have the Yes/No data type retained, and of course the Yes/No field. Thanks MajP

Sorry if you misunderstood my question. I know what a checkbox control is, and how to use it on forms. Here is my SQL for creating a new table, using the make table action query in access: SELECT tblCustomer.MicroBusiness, tblCustomer.Rdate INTO tblRdate FROM tblCustomer WHERE...