Search results for query: *

trying to load data from a txt file using this load ascii c:\data\episode.txt ep_number and getting this error Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'ascii'. any help appreciated

try assigning a float expression(no pun intended) enter the expression exactly as follows 360*sin(NT) that should do it

but if you preserve the future by doing nothing, then you have actually done something. So they want you to do something which is actually nothing. Having said that, if current or present events mould or shape the future,then by doing nothing will the future have changed.

this is even easier, make a copy of the colour photo and change the copy to black and white, then place this B&w copy over the original colour photo as a new layer. then get your eraser tool and just erase on the b/w image what you want to see poking through from the colour image undernreath...

is it possible to "bend" text in psp? like ms word wordart

Hi all I have inherited a query with which i am attempting to query a comments field. The following line looks at the field but i am getting a nil return and I know that there are words containing the letter between the wildcards. i am using sqlbase 7.5.1. here is the line of code and @upper...

probably been asked a million times, how do I lift an object out of a phot to place it against a different background?

can any body tell me if psp has equivalent ifles to photoshops action files or if it can use the photoshop files and where do I load them into? many thanks

Hi, I am a total green as grass newbie to macros etc. What I would like word to do is, I have bookmarks on a template to which I want to be able to input text name address etc. I was thinking of doing fillin fields but rather than manually navigating through, I wanted to record a macro where...

I have a field called "given name", now in this field there are some people who have two given names. Can anybody help me with an expression to use in an update query that will delete the second given name? the names are separated with a space Many thanks Peter

Hi all, I have a query which appears to run ok and I start getting a result but then Access just stops responding, I 've tried running it o/nite when there is little network traffic but the same. My sql for the query is as follows SELECT initials.Surname, initials.Suburb...

Well Rudy, What can I say, In case you were in to much of a hurry for the scent of blood, I did mention I was new to this. Sorry about all the joins and stuff, but that's the way the DB is structured. The subquery part of the whole query actually does work. All I was trying to find was...

Hi all please find a query I am trying to get working. The problem I am having is that I am trying to use a date field from the subquery as part of a 'date difference' thing in the main query and its got me stumped. Any help appreciated cheers Pete select count (*) FROM client cl WHERE 1 =...

Hi Gus, Thanks for your reply, I started out with a one to many, but I was not getting a return for families without children. So i was trying this as an alternative. I have come to the realisation that it was not the actual relationship that was the problem, I was using an inner join. I...

I'm a newbie please be gentle, I have 2 tables with a common field I want to join. On the primary table I have indexed the field and set no duplicates. On the secondary table I did likewise but after designing and joining the tables, I went back and allowed duplicates on the field. This...

thanks, worked a treat

Hi I have a report based on a query, The query givesc me the mum dad and the kids. What is happening is, for every kids record that is being returned I also get the parents record. Can I get the report to only send me the parents details with the first child, and leave them blank for any...