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

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

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

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

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