Search results

The Doc Man... Yes it is a just 4 characters.

Ray H - that is what I want. I think the sample data which I took a cut from a larger file did not start and end on the right field - records 2 to the next to last are what i need. So how did u do it, please... Thanks

Thanks for the responses: I have been trying File/Get external data and browsing to my text file, this opens the wizard, there is no option in get a .csv file. The wizard shows hundreds of columns - one per piece of data, the (cr) or ^p part of every third heading. I don't see where I tell it...

Can anyone help me sort this data out please. I attached a file of the typical data. It consists of three fields: ID Number, Name, DataString. The (cr) signifies the next record. Two records are below. The data is justy one long text string. ....(cr)"429088930","Robert E Watkins...

Yes, that is what I did with no change.

Many thanks, worked out just fine. Steve

Tell me how...... please

Many thanks - at the moment I do run a macro in Excel to rename all of the columns to add a DOT. I was just trying to remove that step. I will pursue the client and see if they can remove the need for a DOT. thanks again

I have to have the DOT. The excel spreadsheet is used to upload into a Client's system and he wants that format with a DOT. Can I do it?.

I need to export an excel spreadsheet file from a query or table made by a query and the field names need to be PO.Item or say PO.Company. Access will not let me use a . in a field name is there a work-around? Thanks Steve

Thanks - same result. Here is a few lines from the output file.. "09F20F00F00Roster" 333333333Eli Aburto 222222222Timothy L Anderson Any other iseas?

Hello, Below is a converted Macro - basically I want to export to a txt file a col of data with a heading of the field name. The heading and field name is always the same 09F20F00F00ROSTER. If I run the code below or macro it works fine except for the quoteds on the heading eg...

I'll try the attachment again....

I have been using Access 2000 for sometime and most of the time I can do what I want, however I am stuck and do not know how to proceed. It would be too much to describe so I have attached a pdf file showing what I want to achieve - it is to get time entered for an employee in a time monitoring...

The way I have been calculating the day punches is by using the Max and Min of the punch information as I explained in my first post. I think I can use this for the night shift if I first subtract 12 hours or 720 minutes from all the 2nd shift night punches and then deal with it as a day punch...

Here is some test data. I need to be sure that if there is only one punch per shift either in or out that the punch is still selected. If there is no in or out data the in or out can be equal. Many thanks Steve

Jon, This looks good, I have tried my best to understand how it works but that will take a while. I tried some test data and it needs modification to take care of missed punches - i.e. where people forget to punch. What I have been doing so far for the day shift is - if there is only one...

Yes its cast iron. Always the last Saturday of the month. The first day is the dat after. Using periodID twice would work but where do I put it - in a cross tab. SQL is as follows: TRANSFORM Sum([qryDataPreparation].[JCAmount]) AS SumOfJCAmount SELECT [qryDataPreparation].[JCBudgetCode]...

No they do not. The period ends on the last Sat, so the next period starts on the Sunday but that is not always the last Sunday in the month.....actually for this year the period does start on the last Sunday. Last year however September and December both started on the first Sunday of the...

I agree that this would be the best way but unfortunately I don't have that sort of data. I get it as I showed. I think I would still need a way of linking the pair of punches. (Last Nights In and this mornings Out). My data also does tell me if the person scanned in or out; only that he...