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...

Can you clarify a little further what you're trying to achieve? 1. Do you mean you just want a Count of the number of Item #'s that falls within a specified date range? 2. Are you trying to create a Work In Progress report or something? If you can give a little more specifics I can probably...

Thanks for the replies everyone.. I found a formula workaround DateValue({Table.FieldName}) Thx again. Nem

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...

Nevermind... I figured it out, thanks.. Left({Store Information Database.WebNumber}, (InStr({Store Information Database.WebNumber},'-') - 1))

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...

Yes, I am using paradox (.db) tables. The application that the database is actually for is written in delphi. I basically have a table browser utility which allows me to execute sql commands on the tables.

Yes, it is a small table with only about 3000 records. Unfortunately though those functions are not supported. Thanks for the query though, I'll try to seek some guidance from the paradox forum. Thanks again. Nem

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...

oh, and yes before someone asks.. i am certain that the files are not in use on the system. even restarting the system where the files are located and then trying to access them immediately from a networked computer still provides the same error.

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...

Thanks for the suggestion, it works perfectly.. :)

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...

awesome, working perfectly except in my case I didn't need the -1 on TheRest statement. :) Thank you so much.

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...

hehe n/m everyone.. I had a brain fart... For some reason I just didn't think of the simple solution of creating a query that displayed the results of the two matching fields. Duh! then selecting which fields I wanted to be displayed in a report. :)

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...

hehe, yep.. I completely forgot I had to add that part on. :)

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...