Search results

I have a report that needs to show total for current year and a total from previous year side by side. My field is incnumb and i will do a distinct count on that field to give me a total count of each incident number. Here is sort of what i am trying to make it look like...

Looking for some help on this or at least some sort of example Thanks

I have a report that prompts for date range of startdate and enddate. once ran, it takes the starttime and endtime and calculates total time per day. however if somone works on the last day of the month, it needs to only calculate the time up til midnight for that current month. Here is what I...

I have a report that pints by date range selected. However, instead of putting in the date range, I would like to run the report and let the user select only the month, then print data for that current month. Example. field= startdate If the start date is 10/1/2011 I want the user to be...

I dont understand what the heck im doing wrong. Neither of those options are working. Does anyone know of a sample working form that i can use to compare with mine. thanks for all the help on this Castaldo Skyland Fire Rescue

No that did not work unless im am missing a field name there. the field name i want to clear is called IsSelected I added a command button and placed your code in there but no go. Any Ideas Castaldo Skyland Fire Rescue

I have a small form that has 3 fields from my employee tbl. Field1-IsSelect ( yes/no) check box Field2-lname Field3-fname I want the users to be able to put a check mark next to each emp name that they want to print the timesheet for. I can get that all to work, but now I need a button to...

R. Hicks Can you send me that same example to dcastaldo@skylandfire.com Thanks

My db has 4 fields name,phone,email1,email2,week My current records have data in email1 field. Email2 field is currently blank. I want to move the email addresses in email1 over to email2 but keep them inline with name,phone,week. Will this command do it for me Update tblName set fieldA =...

Ok, I will try to explain myself as best as I can. I am trying to replace our timesheet system which is nothing more than using many many excel spreadsheet files to keep track of our time for shifts work. I need the db to include a frm and a subfrm. at the top i need to be able to enter the...

The tblEmphrs holds the hrs, sick,vac per employee every day they come in the captain will add his crew and there hrs (24hr) shifts

He should, Im not sure. The tblEmplist has there name, station#, shift Could it be a joining issue in my relationship >

Jal, If you hols the shift key down while opening the mdb file it will disable. pbaldy, The shpk is supposed to be my primary key in the tblempList

Pbaldy Thanks for the response, I almost have mine working, I have attached a copy of my db. Would you mind looking at it and tell me why the following happens: when i open the fromOpenTimesheet and then select my employees, It then needs to run the rptTIMESHEETbystanumber which inturns runs...

I have built a small timesheet app for our fire depatment. I want to create a form that allows me to select an individual FF or multiple FF, then when you click on a button it runs a query i have that prompts for date range, then it opens a report that is the timesheet for each of the selected...

I have a small form that I want to put a list box on that will allow my users to select several names in the list. Then by selecting a command button i want it to run a report that looks at a qry which prompts for a date range already. the report already calls the qry and and displays a time...

Any Ideas on this last post i did Thanks

{@time2} in Time (17, 00, 00) to Time (7, 00, 00) and {in5basic.ALARMDATE} in {?from} to {?to} Still returns records for 8am 9am 10am etc

begdate - 01/01/08 ending date 08/31/08 then i want it to return all the records that are from 5pm - 7am the next day

I have tried this {in5basic.ALARMDATE}in DateTime ({?from},time(17,00,00)) to DateTime ({?to},time(23,59,59)) and it does 2 things. 1. it returns some duplicate records. anotherword it returns incident # 2008025 twice, but not all records are dups. 2. It pulls in records from 02:00 etc. I only...