How would i check a string for blank spaces and if there is more than one blank space between two words, how would i convert it into just one blank space between the words?
Another question i have is.. how would u check a string to see if its a valid floating point-number?
Marvstyles
Last Activity: Mar 22 '09, 02:53 PM
Joined: Nov 24 '08
Location:
-
Check string for blank spaces
-
Subtract values in a field from a number?
I wanna take 300 and subtract it by a value inside a field and i want the results to display in a new field called "Oustanding Fees."
The field is called "FeesPaid" and the field contains the amount the person has paid. Anyone who hasn't paid 300$ still owes money. For example there is a value inside the field 125.... how would i subtract that and all the other values in the field from 300? -
Display data from more than 1 table without using join?
How would i make a query that displays fields from 2 different tables without using JOIN?
I need a query that shows PlayerID and PlayerName from the table tblCompPlayers along with TeamID and TeamName from the table tblTeams. I am not allowed to use JOIN. -
Need help with intersect and subselect
Here is what i have to try and do:
Use INTERSECT and a subselect to display Coach ID and Coach Name for those coaches who live in Oshawa and that DO NOT have a team assigned to them.
the fields CoachId is in the table called tblCoaches and same with a field called CoachCity. The CoachId is also in another table called tblTeams but the field is called TeamCoach instead.
Here is what i have so far:...
No activity results to display