Search results for query: *

I have a folder that contains 500 different lists. I need to create a perl script that will compare each of these files to a master file layout and verify that they are all the same. I need it to log which files don't match the master layout.

I have an Access table that has the following fields; FacID Loc # Inn Brand TableTents 3864 1179 RWCEX.pdf HIEX 75 5749 7629 SFOPF.pdf HEXS 75 7258 4648 YRMAB.pdf HIEX 75 I need the records in the table to repeat based on the "TableTents" field. This is what I have written so...

I have a table that has 17 sales representatives (over 15,000 records). How can take 20 records from each Sales Rep and put them into 17 different tables?

I have two tables one table is called BuyerGuideCodes and the other is called BuyerGuideCodesDescriptions. Below is a sample record of table BuyerGuideCodes: ID: 1 COMPANY: CJ Systems Aviation Group CodeID: SS, OP, AS, AL, AN, AO, BS, GA, HD, IT, RO, PS, TR, MK...

I have joined to tables based on Group_ID. This has added nineteen different contact fields to my new table. I need to sort the contact fields according to Position order. see below sorted by postion in the following order: Program Director: Operational Manager: Medical Crew Supervisor: Medical...

I am new to both XML and SQL Server so please be patient. I have ten excel files that need to be imported into SQL server. This part of my job is done. What I need now is to export these files as tagged XML files. How do I export as XML from SQL server?

I am totally new to using SQL Server so please be patient. I have ten Excel files that need to be imported into SQL server and saved out as XML files. Can anyone help me with this or at least give me direction? Thanks

I have multiple files in a folder that I need to rename.I need the first three characters in the filename placed at the end of the filename. Can someone give me some direction on this?

I have multiple text files that I need to import into multiple tables within Access using VBA. I have a module that will import all of the files but it puts them into one table and this is not what I need. How do I do this?

I have created a module that will change the structure of a table. However now I need to know how I can update all twenty different data files at once.

I have a recurring job that requires quite a bit of changes made to the structure of over twenty tables and I would like to automate this process instead of having to go into design view and making the changes there. Here is what the original structure of the table looks like. ID Long Integer 4...

Is there anyway in an Access Form to calculate two fields and have that auto fill a field in my data file? Ex: Mastermailerhours = mailquantity/2800 I need mastermailerhours to be bound to a field in my table. The only way I can get it to work is if I place a command button on my form that...

I have two table in Access that are relational based on the customer account number. I need the information that is in the Header table to be appended to the end of the records in the Detail table. I need it to look like this Record 1 in table Detail Fname lname company account# address...

I have two data files in Access. The first data file holds all of the customer info, such as name, company, address etc. My second data file holds all of the magazines that each client has ordered over a period of time. Both files have one field in common, that being the client account number. I...

I have two data files in Access. The first data file holds all of the customer info, such as name, company, address etc. My second data file holds all of the magazines that each client has ordered over a period of time. Both files have one field in common, that being the client account number. I...

I have a text box on a vacation report that holds a beginning date and a text box which holds an end date. Beginning date is the beginning of vacation End date being the end of vacation. I have another text field to show that the person is on vacation but I don't want it to show until the...

I have a command button that I want to carry all the dates on my form by 1 day. However, where there is a box with no date I need it to do nothing in that box. I want it to only carry the date where there is a date already in the box. Can anyone help me with this? Here is what I have now: If...

I have a text box on mu report that is bound to a numeric field in my table. The reason this feild is set to numeric is so that we can calculate the total amount of time a job will be in a department. I need to be able to put an "X" in this box to show that the job is done. I need to...

I have a form where you input information for scheduling. I have a checkbox on this form that lets people in certain departments know that their material is here. I want to be able to update a text box on my report based on whether the check box in my form is checked. Here is what I have...

I have a field where I input a date. Based on that date I want another field to add a day to the date.