Search results for query: *

Hey Everyone, I've got a customer that has gotten himself into a situation. Our software utilizes SQL Server for it's database engine. In every case before, our software only utilizes a single data.mdf and data.ldf file for the SQL database. Through some form or fashion, this customers seemed...

Hey Everyone, Our software package is sold to a number of different countries that use different date formats obviously. Certain fields in our software applications database store the date/time values in a single field that is formatted for DateTime. When I drop these types of fields onto a...

I'm working with Crystal 8.5 and I have a particular field that is stored as a text in the database. The consistency of the data entered into the field varies for each of the databases we have, for instance. Field: WebNumber Values: 001- 002- 3- 393- 2993- 500 As you can see from...

Hey everyone, Need a little help with creating a query to split some data. If there was a common character associated with this field then using the substring and trim functions would probably allow me to do this, however my sql is a little rusty when it comes to this nature of things. I've...

SQL Syntax help needed (splitting a single field) Hey everyone, Need a little help with creating a query to split some data. If there was a common character associated with this field then using the substring and trim functions would probably allow me to do this, however my sql is a little...

Hey guys, I've got a problem here and it's really blowing my mind on what is doing it. First of all, let me simplify things. I'm having the problem on a global scale from several different systems, however we'll just focus on 2 of them. System Information: Dell Dimension 2400 (XP Pro) Dell...

Hey everyone, I'm not sure if what I'm wanting is possible or not. I'm not very knowledgeable with MS Word, so maybe someone can tell me if this can be done. I want to create a header that will go on the top of all the documents for my dad, it's basically just his business logo and address...

Hey everyone, got a little query I need some help with. I'm sure it's not too complicated, but I'm quite a beginner when it comes to constructing sql queries. I need the query to be in sql plz, because I have no experience with VBA. Basically I have a field "Name" I need to split...

Hello everyone, hope everyone is having a nice day. I need a little help plz. I have two tables, which are "Venire" and "Voter". I have "Voter" linked as a subdatasheet to the common field between the two of "JurorNo". Is there a way to create a report...

Hey everyone. :) Ok, I've got a question. If I have a field, say "Address" and it contains a full address ie " 1392 Old Highway 342 ". Is there a way I create query a query that will take the 1st set of numbers it sees and insert them into a new field called...

Hey everyone, left me give you a brief rundown on what I've got going on. I've got a table with 1000 records, each record contains last name, first name, address, etc. Then I have a series of yes/no (checkboxes) for each record. These checkboxes are "LA Claimant","MS...

Hey everyone, yep I need help again.. haha.. :) I'm working with a table that contains records for every registered voter. Ok, well it is only current to 1997 and there is an excel update for it, but all the fields are messed up so I'm having to convert and move stuff around to make it all mesh...

Hello everyone, A guy made a post a few pages back about this, but I can't get the suggested procedure to work correctly for me. So I'd like some help if possible. I have a number field that contained dates-of-birth, well these were just numbers like "7121980" or...

Hello everyone, I need some guidance please. I have a table [Voters] that has a DateofBirth field, well the field is not in date/time format. Instead the data type for the field is "number" with a field size of long integer. However, the dates aren't in a floating point form. An...

Hey guys, need a little additional help with a select query. Basic Rundown: I have a (2) tables, Voters and POC. The Voters and POC tables have varying different fields. However, some of the fields match up that I would like to do a select query for. Fields: LastName FirstName DateofBirth Sex...

Hello everyone, bare with me if I seem a little newbish to you. Ok, here's the scoop. I am trying to update a voter's database that I'm working with. I have one table with all the current voters in it from 1997-2003. Well an update came out that has all the cancellations in it. I need to...