I am currently a Analyst for the US Air Force but, am separating July 23. I am looking for a software development position in the Kansas City metro area. Please contact me at <email removed by...

Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number.

Example...

My SQL statment would look like:
SELECT table1.value1, table1.value2, table2.value1
FROM table1, table2
WHERE table1.[increment number] > table2.[Value2] (here is the part I can't figure out) AND...

Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number.

Example...

Hello,
I am using TransferText to bring a text file into an Access table. Is there a way to turn off the Import Error file that is produced as a result of improperly formatted text?

Thanks!
Mark

Hello,
Can anyone help me add a column to my Access table? I would like the column to be populated with a number that iterates from 1 to the end of the file.

Thanks for your help!

Mark

My rows are not numbered. Any other suggestions?

Thanks!

Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before:
SELECT...

Thanks for your help. The above statement did work. But, brought on a follow up question, how can I also select the other fields in the table with this statement?

What I want is certain fields...

Hopefully this will be an easy one for someone.

I am trying to write a SELECT statement that pulls the row with the least time for each Special Number.

Example data would be:

Time ...

yep! well HH(Stop)-HH(Start), etc..

Sure, use a tokenizer to separate HH, MM, and SS from HH:MM:SS. Then subtract HH from your other HH, MM from MM, etc. As long as it is in 24hr format it should work. You will have to write some...

This may not be the best way to do it but, you could build a function to convert the times into seconds and use subtraction. Your function would have to tokenize the time format using the : as a...

Hello All,
What I am looking for here is for someone with database experience to provide me with some information on how much time and effort maintenance of the db takes. I am taking a database...

I have created a few projects in VB.NET using Visual Studio 2005. I am wondering how to package the applications for deployment. I would like to be able to upload applications to a server or e-mail...

One little sneaky parenthesis can cause a lot of pain in LISP. You solved my problem. Thanks.

I could not implement the parse-integer, it gave me a type error.

Also, the other tips were...

I am trying to write a simple Lisp function for my Articficial Intelligence class and am running into a problem. The compiler is seeing the line format t "Enter a number, press return and enter...

After taking Lerner's advice I have found that myString is not accepting spaces. If I type in a name... Doe, John Hanes, I expect that entire name to be in the string but when I check this all that...

I am getting a runtime error somewhere in the inputData function, I can't find it. Can anyone help? Thanks


#include <iostream>
#include <string>
using namespace std;
void inputData (string...

My mixed int is getting set to the wrong value somewhere. Can anyone help me see where?

Driver:

#include <iostream>
using std::cout;
using std::endl;
using std::cin;
#include "Rational.h"...

Sorry the code got all screwed up there. Something happened when I previewed my post! Don't worry about helping me out because I think I might have solved my problem.

I am having some trouble with the logic for my constructor. The constructor is supposed to open a object of class Rational. The constructor is also supposed to check to make sure the denominator is...

Can anyone help me get started on converting a float to a fraction?

My while statement does not work. This program is only performing the function on the first word in the sentence. Can anyone help me get the while statement to do all of the words in the sentence?...

OK next question. I am trying to change the array tokenPtr is pointing to. My compiler will not let me save tokenPtr as a char[]. How can I access different array positions using tokenPtr? I need...

Still having trouble with the code. I did what joeprogrammer said and changed all of the *tokenPtr to tokenPtr and now I can't get the program to compile. If someone can help me pass the word into...

OK Can anyone help me understand what a tokenizer does? And why I have to put *tokenPtr? What is the * for?

I am having a heck of a time figuring out how to write a program that takes the last...

It was just an easy way for me to allow the user to select which employee sold a product.

I am back this week with another homework problem. My array is not working like I thought it would. My brain is about to explode trying to comprehend what is going on. This code will compile but,...

I have already taken advantage of it!

Name: Mark
Nickname: Dunno
Height: 5'10"
Weight: 210
Hair: Brown
Eyes: Brown
Location: Feltwell, UK
Age: 24
Hobbies: Outdoors, mountain biking, beer, problem solving

I am new to C++. This is a homework problem. So if anyone gives up their time to help me it is greatly appreciated. I have perfect number program, I can get it to run if all my code is in the...