Pages

Search

Microsoft Works - Database formulas (again).

Microsoft Works - Database formulas (again).

Database formulas (again).

Posted: 16 Apr 2005 01:23 AM PDT

On Sat, 16 Apr 2005 23:31:33 +0200, Erik <com>, in
message ID <#phx.gbl>, in the newsgroup
microsoft.public.works.win wrote:
 

OK then Erik and the others who posted.
I've had a bit of unexpected spare time on my hands and have done some
experimenting.
The newer formula posted by Kevin (and written by Michael) works for
me. It succesfully printed the trailing zero as needed. However, an
issue that has not been overcome so far is that blank, number
(currency) formatted fields always seem to return £0.00 rather than ""
(null string). As my document contains currency subtotals - often
null strings - this meant that I was printing £0.00 quite a lot when I
would have preferred it just to be blank.
When I tried the .csv method proposed by Erik, this fixed that issue.
I have heard of .csv before and actually used it for something
entirely different some time back but wasn't aware of its
possibilities in overcoming some of the print-out issues of higher
level software.
Anyway, I have decided to dispense with those formulas in the Works
database. After each change, I will now save the database twice and
merge from the .csv file overwriting it each time with the new .csv
file.

I haven't quite got the guts to totally remove the original .wdb file
(with the formulas) in case something unexpected goes wrong so I will
store it somewhere - just in case.

Thanks for your input everyone.
--
Paul

Use the reply by email facility in your
newsreader to send email

have works suite 2005,can I install only money???

Posted: 15 Apr 2005 12:42 PM PDT

Kevin, thank you so very much... have printed off both replies and am now
relieved that not only do I have a solution to my query but homepages to
help in the future..


"Kevin James - MSMVP Works" <org> wrote in message
news:phx.gbl... 

Why no answer?

Posted: 15 Apr 2005 12:28 PM PDT

Thanks Erik and Rodney, much appreciated.

"Rodney" wrote:
 

Open .wps file in Word

Posted: 15 Apr 2005 10:41 AM PDT

Hi Mario,

Perhaps these help:

Works Converters for Word
http://www.gmayor.com/Zips/WorksTextConv.zip

and

Product Updates and Downloads
http://www.microsoft.com/products/works/downloads.mspx

Also, to discover the version of Works, and the Product ID:

How to find the product ID that you must have to register online
http://support.microsoft.com/default.aspx?kbid=832799

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Mario" <microsoft.com> wrote in message
news:com...
| I've installed the MS Office XP converter pack but still get the following
| error when I try to open a Works file:
|
| Word cannot start the converter WORKS532.CNV
| I click on Ok and get:
| Word cannot start the converter WORKS332.CNV
| I click on Ok and get:
| Word cannot start the converter WORKS432.CNV
|
| This goes on about 5 times and then the file is opened with garbage in it.
|
| I appreciate your help.
|
| PS. I don't know the version of the Works file.
| --
| Mario

Synchronize trouble with Palm device

Posted: 15 Apr 2005 08:50 AM PDT

Hi Andre5,

Perhaps this helps:

Works Suite: Error Message After Synchronization with Pocket PC
Device: Wkscal.exe Application Error
http://support.microsoft.com/?kbid=309501


HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Andrea5" <microsoft.com> wrote in message
news:com...
| Works hangs during HotSync and and I end up having to CTR-ALT-DEL to shut
| down Works, and the data does not transfer. I tried restoring Palm Desktop
to
| the default, two ways: 1st by uninstalling/reinstalling both Works AND Palm
| Desktop. No go. 2nd way I tried was by opening the Custom setting of HotSync
| manager, but Date Book and Address Book do not even appear on the list
| anymore for me to change them. I tried clicking Default to restore the
| default settings, that also didn't work.
|
| I ended up going to our other, older computer and installing Palm Desktop
| there, synced and had no problems. I am working on a Presario R3000 running
| XP home, Works 8.0
|
| Thanks for the help

calendar datafile

Posted: 14 Apr 2005 05:13 PM PDT

Yes, that is correct Rui.
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Rui Pinto" <microsoft.com> wrote in message
news:com...
| Just more one question: There is only one file to all users of the same pc?
|
| "Rui Pinto" wrote:

Works Database formula for report

Posted: 14 Apr 2005 04:43 PM PDT

Hi Tee,

I have responded by email and returned your database updated and
functioning as requested.

The main issue was that the report used two Record lines, one to display
the purchase details, the second to show shopper's Notes, if present.

The database designer wanted to condition the second line to appear
ONLY if there were Notes to display, thus removing blank lines. There
is not a feature/function within Works' database to conditionally display
Record lines. However, ...

I used CONDITIONAL CONCATENATION together with spaces
to cause either a single line, containing the field 'Item' to print, or a
wrapped line with concatenated fields 'Item and 'Notes separated by
spaces to be printed. The spaces cause a line-feed, to place 'Notes on
a separate line, as required.

A new field, 'Item_Notes' was used to store the concatenation of fields
'Item and 'Notes, using this formula:
=Item&IF(Notes>"",REPEAT(" ",128-LENGTH(Item))&Notes,"")

Two Record lines, the second containing the field 'Notes, were replaced
with one line; the second line was deleted and the first line's entry with
field 'Item' was replaced by the new concatented result field 'Item_Notes'.

This field was formatted, in List view, to wrap-text and sized so that its
width displayed Notes on the second line.

In the Report, the column was also set to wrap text, its field width adjusted
to cause wrap text and further Formatted to Row Height of Best Fit.

Hopefully, I will soon place a sample on my website, for those interested in
seeing this in action.

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Tee" <com> wrote in message
news:supernews.com...
| Hi Kevin.
| Thanks, I've taken you up on sending the database. Just sent it out.
| thanks for the offer.
| Tee
|
| Kevin James - MSMVP Works wrote:
|
| > Hi Tee,
| >
| > If you care to email your database to me, perhaps we can work
| > it out together, off forum.
| >
| > org
| >
| > HTH,

My first Test Post

Posted: 14 Apr 2005 04:02 PM PDT

Its never too late to have a happy childhood. I'll avail myself of the link
to Find a Therapist in My Area link...DavidF

"Kevin James - MSMVP Works" <org> wrote in message
news:#phx.gbl... 
is 
confused 

Searching a range of dates in works spreadsheet

Posted: 14 Apr 2005 03:27 PM PDT

Ooops, sorry

Spreadsheet :)

If your date reference lies in cell C7

=IF(AND(C7>'23/03/2004',C7<'24/04/2005'),"yes","no")



| G'day Mario,
|
| I use MSWorks 4.5a.
|
| If you have 3 date fields
| =IF(AND(date3>date1,date3<date2),"yes","no")
| If you have just 1 date field
| =IF(AND(date3>'02/03/2003',date3<'01/02/2005'),"yes","no")
|
| you can transpose the "yes" "no" answer with
| whatever you like.
|
|
| HTH
|
|
|
|
| | Does anyone have or know of the correct formula to see if a cell's contents
| | are between two set dates? I am using Works 7.0
|
|

Microsoft Works Calendar 8.0

Posted: 13 Apr 2005 11:45 PM PDT

Hi Sandra,

Perhaps this helps, a clean before a reinstall.

Windows Installer Clean Up Utility (msicuu2.exe)
http://www.stationeryisbad.com/movie2.html

together with the Works CleanUp Utility

Utilities to help with troubleshooting Microsoft Works
http://support.microsoft.com/?kbid=297061

Full details, for similar error, included here:
http://support.microsoft.com/?kbid=892614

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Sandra G" <Sandra microsoft.com> wrote in message
news:com...
|I can open every Microsoft Works 8.0 program I have, except for the Calendar.
| When I try to open it, it looks as if it is about to open, but instead i get
| the error report message 'Microsoft Works 8 has encountered a problem and
| needs to close. We are sorry for the inconvenience' and it gives me the
| option to 'Send Error Report' or 'Don't Send'. I can never open it, it never
| works. This seems to have happened at some point after I did a System
Restore
| to my computer. Is there a sepcific file that could have been corrupted?
What
| could the problem be? I have already tried to uninstall it and reinstall it
| and that has not helped. Any suggestions?? Please help!

record limits?

Posted: 13 Apr 2005 10:47 AM PDT

Works and Excel are siblings,
just copy and paste suits us.

MSWorks will happily work with 30,000 records
until such time you employ fields with resident formula,
the Database then becomes very quickly impotent
and you will spend time waiting for it to compute.

You will have to work with the matrix you build
but for just sorting and filtering pure data the speed remains blinding.

We copy and paste 20,000 records to excel at a time, and paste as
"text only" excel then deals with the filtering and sorting with speed.

The more you become accustomed to excel, you probably will migrate there
full time, it's the "Big Daddy"

Creating separate databases as you suggest is OK, we refer to it as
"segmenting" sub sets.
If you get to 30,000 customers, no doubt you will employ your own
IT professional :)

HTH





| hello and thanks for the speedy response!
|
| I don't quite know how you would shift information to excel, but if things
| reached that point maybe I would just create separate databases based on the
| customer's last name or something...
|
| Very encouraging to hear I can work with that many records!
| cheers,
| kc
|
|
| "Rodney" wrote:
|
| > 256 fields, 32,000 records.
| >
| > We still use Works for shuffling records of a 5 million record database,
| > so you may not "outgrow it" :)
| > We have found though for shuffling a matrix of filters, of dumping
| > large blocks of data to Excel.
| >
| >
| >
| > | Hello all,
| > |
| > | I'm starting a small business and right now only have access to Works.
| > | Eventually I expect to outgrow it, but can someone tell me how many records a
| > | Works database can handle? I'm going to be entering basic customer info -
| > | names, addresses, phone and maybe 10 fields beyond that... say 20 fields per
| > | record.
| > |
| > | Also, when I do outgrow it, will I have a problem exporting my information
| > | to Access. I don't have the resources to start with Access at this point,
| > | unless I use the old Office 95 version.
| > |
| > | Thanks thanks.
| > | kc
| >
| >
| >

Works database filter problem

Posted: 13 Apr 2005 02:59 AM PDT

Hi Peter,

Could you publish the filter formula, here, please.

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Michael" <com> wrote in message
news:UqY7e.996$lga...
| "Peter Strong" <microsoft.com> wrote in message
| news:10c201c541b6$071ecec0$gbl...
| > I'll try this. At the moment I filter the database with
| > Excel. Works fine! But I do not like that I everytime that
| > I have to filter have toe export the whole database. I'd
| > prefer to filter in Works.
| >
| > Thanks for your advice.
| >
| > Peter Strong.
|
| Peter, one suggestion follows: in your filter try preceding the text
| value with a double quote ("), no spaces. I have found that Works 7.0 seems
| to save the text field data with a single double quotation mark. By adding
| this in the criteria for the filter it may work. I have to do this all the
| time.
|
| mike
|
|