Search results

Query or Code - Can You help pleeeese I posted this question a few weeks ago and did not get much / any response probably because my Q was unclear – I have reworded it - sorry it is long but not complicated. An entry scanner provides 2 lines of raw data per employee each day. Using a query I...

I used Excel cause its easier to get a column of dates and then to add the period. I did that for 5 years in a few minutes, then imported the table into Access. A query brings the cost and period data together. Our periods end on the last Sat of each month. It works fine -...

Thanks I think that will work - it will get me out my current crunch but I don't think it is the right way or a permanent solution? There is no formula to the periods - the object is to make 12 full week months i.e. either 4 or 5 weeks. Many thanks

Yes, That is exactly what I want to do - however I have 175,000 records so need to do an update query or have the report query assign the period as the query processes - either way I dont know how. Any ideas,

No, they are 4 or 5 week months. e.g Dec 29 to jan 25 jan 26 to feb 22 mar 23 to mar 29 Thanks

Thanks, but does this way mean I will have 100 Cases is I have a 100 cost periods?

Thanks for helping. I think the update query may be a way of accomplishing this. I use update queries for other things but still stumpt on how to assign the period number depending on the date. IF it were just a few periods a nested if would work: if entrydate is between dateA and DateB then...

OK, I can add period ID to the cost data table, but how to I get the field to fill - i.e. if date is between fromdate and todate = period x OR if date is between ........ Thanks

I have 2 tables one with costs by date e.g. Ref1; Amount; Date The other table has accounting periods: period1; from:12/30/02; to 01/26/02 period2; from: 01/27/02; to 02/23/02 etc Where or how do I link this data to do this. Thanks Steve

My problem is not calculating the interval between the in and out punch - it is specifying the correct pair of punches on which to perform the interval calculation. A day shift has an in and out punch on the same day. Minutes on site is the difference between the two punch values. A night...

I posted this Q on the VBA board but no answers – So I am reposting here…. I have a database which reads data from a table in a handscanner database for time in and out of work. I have to link to a payroll system and so unable to use the handscan software to do what I need. The scanner...

I am not getting any reply to what I thought was an easy problem - Let me explain some more. The punch data that I get is in minutes which are zeroed at midnight. So my data will be as follows: Typical Day Shift - Shift 1 01/20/02 JoeDayWorker; Punch 360 01/20/02 JoeDayWorker; Punch 960 From...

Help PLEEEEAAAASSSEEE I have a database which reads data from a table in a handscanner database for time in and out of work. I have to link to a payroll system and so unable to use the handscan software to do what I need. The scanner provides 2 lines of raw data per employee each day. I use...

I can't change the record source of the form. As it presently exists the form accepts the date entered which becomes part of the file name. The report which I am trying to send to the file is based on a query which requires a date parameter. So after I start the procedure I need to tell it to...

I am trying to publish a report to our server using the following code. I have an input form which sets the date of the report Me![SetDate]- this all works fine however when the OutputTo ac-report line runs, it requests a date parameter from the query on which the report is based - ptc Date...

I do have the one record in the table and still get a grey form with no fields............................. So something is wrong - I started again and it works fine...no idea why but something somewhere must have been checked or corrupted. Thanks all for your help. Steve

Believe it ot not that's where I started this morning but when I set "Allow Additions to No - when I open the form it is just a grey box and no fields ...

I think "Hi There" has the right answer. When I open the form I want to see Record 1. I want to be able to change record 1 but not add any other records. I tried the following but the form still shows a blank record when i open it. Thanks again...

Thanks for responding - I have been storing the info in a table but had some problems keeping it to one record. Via the switchboard I want to be able to open the form showing the name and title values and allow an edit. I tried the table but when I opened a form based on the table I could not...

Just when I think I am finally starting to understand things I get tripped up by a simple problem - I need the user to enter the Project Name and Number and then store that information. On each use of this mini-app the Project Name and Number will be the same. I want it to be a one time entry...