Write excel expression in access

07-01-2009, 12:47 PM

ktmchugh

Windows Vista ktmchugh uses Access 2007 (version 12.0)

Access 2007 (version 12.0)

Novice

Join Date: Apr 2009

Location: Christchurch, New Zealand

Posts: 12

Write excel expression in access

Hi,

I have an expression I have been using in excel, but I want to be able to do this in Access. Could someone help me understand how I would write this/ use it in Access?

Expression in excel:
=IF(F27>0,IF(F26>0,G26,IF(SUM(F3:F26)>0,MIN(G3:G26 ),D27)),"")

Thank you!
katie

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parse a File from a Directory and write data to table	galahad	Database Design	0	04-23-2009 06:38 AM
Excel/Access	vipslat@aol.com	Access	0	03-18-2009 04:40 PM
write a query how to???	flamingo	Queries	0	01-13-2009 12:57 AM
excel to access	college_fellow	Access	0	12-18-2006 05:29 PM
Is Access support CASE Expression as SQL Server?	winwin	Queries	0	11-03-2006 11:31 PM

All times are GMT -8. The time now is 02:58 PM.