Search results for query: *

Hi everyone, I have an access database that is set up like a giant spreadsheet. I'm tasked with trying to turn it into a relational database but am having trouble with the field that holds a plan approval date. I've extracted the data from the database to an excel spreadsheet, and it comes...

Hi! I have been given a project to update an old Access 2000 adp created by a vendor to Access 2010. It gives the end users various VB errors. When i try to debug it, i get the User defined type not defined error on the following code: Public Function Add(tag As String, _ Value As String)...

Hi! I have a database that stores payroll information in seconds. Our payroll person would like the crystal report to show hours and minutes for each employee. The SQL query we're using produces: Badge Name Type Time (in seconds) 66666 Mephistopheles HOL 28800 66666 Mephistopheles REG...

Hi! I'm actually working on a CR for my google export, and the lat/long for our bus stops in one of my programs (TransitMaster) is being displayed without a decimal point. Right now I am manually putting it in using excel and word, but they change the values and it's very cumbersome. I'd...

I have a query that is producing a report of Full Time employees and i still need to group them by those having over 80 hours and under 80 hours (which is the rollup total), and the rollup seems to be positioned at the beginning of each employee's records, I'd like it to be at the end. If you...

Hi! I'm very new to SQL and have been asked to select Full time employees only (EmployeeTypeId = 1 for Full Time), and have been asked to add a total of Pay hours to the Query below: SELECT E.BadgeNum, E.LastName + ', ' + E.FirstName + ' ' + E.MiddleName AS Name, TKP.PayrollCode as...

Hi! I'm working with SQL 2008 and CR XI. I have a field in the database that is supposed to be a date field, but it is held as a number - for example: 20100323. I need the report to have real date parameters so I need to convert it to a date. I have tried CDate({TKPay.LDate}), CDateTime and...

HI, I'm clueless with creating databases, and have been asked to create a database for tour bus information. I can't figure out how to create a table for the vehicles and link it properly - some of them have up to 100 vehicles - what is the best way to accomplish it, and what is the best method...

Hi Everyone, Any assistance is much appreciated! I am working on a report and it has to differentiate between Resident Permits and Visitor Permits, and need a formula that will separate the permits in question. They would like to be have a distinct count of resident permits and visitor...

Hi! I've been asked to modify this code to have both functions displayed in one message box, but my VB is very poor. Any help would be much appreciated, thank you in advance. The code is below: strComputer = "." ' Function ShowBIOSInfo() On Error Resume Next DisplayOutputHeader("BIOS -...

Hi! I was given a pair of spreadsheets that has some custom VB code applied to the main sheet. Currently, the code allows them to pull up the member name by putting in the pass number. What they need is the member name to pull up the number and place the data in the proper cell. I'm new to...

Hi! I'm new to these forums and hope i'm posting this to the right place. I'm working on a report using CR11 developers ed., that is designed to calculate the time difference between when a user logs on to the internet and when they log off. The problem is that the data is inconsistent. For...