Search: Browse by Category:
FAQ Main Page > Queries
ASK QUESTION
View Questions by Category:

No category found

Browse "Queries" Questions
There are 6 questions found in this category:
How can I add an automatic deduction record for every employee record?
This example adds an automatic deduction record "S" for every existing employee record (in the pr3mstr table) that doesn't already have one, to the pr3eded table. Replace any items (deduction letter, ......
●●●●● Last Update: 2007-05-22 Views: 8
How to show tables in an external database
select * from [;database=c:\citicentral\transfer\TransONG.mdb;pwd=onlyme;].currentbatch...
●●●●● Last Update: 2007-02-23 Views: 6
How to create a currency rounded overtime billrate using the regular bill rate - SQL code
UPDATE placements SET overtimebillrate = int(((RegBillRate * 150) + .5)) / 100...
●●●●● Last Update: 2006-06-28 Views: 5
Parsing the Last and First Names from the Applicants.LastNameFirst field
The applicant name in Temps Plus is stored in a "LastName, FirstName MI" format. If you wish to design a report with formulas for the first and last names reversed, the ......
●●●●● Last Update: 2006-06-13 Views: 9
How can I make changes directly to the Reports Library?
You can use the following query: SELECT * FROM [Reports Table] in "F:\npath\tpreport.mdb" Substitute the location of your npath folder. Now you can make changes to any record/field in the table, ......
●●●●● Last Update: 2006-05-15 Views: 18
Query to show changes or deletions from the CheckHistory table that were performed using the Edit Applicant Check History option.
select * from checkhistoryaudit...
●●●●● Last Update: 2006-04-26 Views: 23