Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 8 of 8
Search took 0.00 seconds.
Search: Posts Made By: canmex
Forum: Access March 7th, 2006, 03:07 AM
Replies: 14
Views: 2,364
Posted By canmex
Mike, first off I would like to say thanks for...

Mike, first off I would like to say thanks for all your help. I am impressed with your prompt responces.

I got it working using a dynamically generated query.

Here is my late night code that...
Forum: Access March 7th, 2006, 01:50 AM
Replies: 14
Views: 2,364
Posted By canmex
Not really much sensitive, allot of invoices. The...

Not really much sensitive, allot of invoices. The front end and back end of this DB is about 70 megs. I could delete a bunch of records in the backend to get the size down. Zip would reduce it a...
Forum: Access March 7th, 2006, 01:26 AM
Replies: 14
Views: 2,364
Posted By canmex
Not yet, no discount is applied to anyhting not...

Not yet, no discount is applied to anyhting not even the recods with the 537 or 536 codes,

Do you have a big gun. not for my head but for my computer.

PriceUSDCode:...
Forum: Access March 7th, 2006, 12:43 AM
Replies: 14
Views: 2,364
Posted By canmex
Once again, thanks for your help I may be...

Once again, thanks for your help

I may be wrong or just dumb but, I think we are not on the same page. My objective is not to have any hard coded conditions in the IIF statement other than the...
Forum: Access March 6th, 2006, 10:39 PM
Replies: 14
Views: 2,364
Posted By canmex
Mike, Sorry to say but it does not work. Here...

Mike,
Sorry to say but it does not work. Here is my complete SQL.

SELECT InvoiceBody.Code, IIf([forms]![menu]![PriceDiscount],([PriceUSD]*0.8),[PriceUSD]) AS PriceUSDCode, [sorprifix] & "-" &...
Forum: Access March 6th, 2006, 07:34 PM
Replies: 14
Views: 2,364
Posted By canmex
Mike, I have tried that in my query ...

Mike, I have tried that in my query

PriceUSDCode: IIf(forms![menu]![PriceDiscountString],([PriceUSD]*0.8),[PriceUSD])
What happens is the query applies the discount to every record.

My text...
Forum: Access March 4th, 2006, 08:46 PM
Replies: 14
Views: 2,364
Posted By canmex
In a query

In a query
Forum: Access March 4th, 2006, 04:58 PM
Replies: 14
Views: 2,364
Posted By canmex
Query with IIF

Basically what I am trying to do is replace the evaluation part of the IIF with a Text String.

Normal SQL that works.
PriceUSDCode: IIf([Invoicebody].[code]="536" Or...
Showing results 1 to 8 of 8

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.