Search results

Can you give some detail about table and field names

enter from to year in your query row field

If you get this error because you are dividing by zero than you can change the expression as below =iif([text36]=0,0,[Text111]/[text36])

sum(iif([TradeStatus]="Completed" and [Product]="Spot",1,0))

Your can limit data in the query by filtering the date field such as where year(orderdate)=year(date())

Try this sum(iif([TradeStatus]="Completed",[Trade Amount],0))

I misunderstood you can use aggregate query to get this in the criterea row of query enter "completed" and count the column tradestatus

this expression has to be used in report

Use this expression sum(iif([TradeStatus]="Completed",1,0))

You can use update query to fill empty cells

You can use dlookup to check whether this id already exist

Add some validation for fields in vba in before update event of form

Try this sql SELECT TbleDailyReports.ID, TbleDailyReports.ReportDate, TbleDailyReports.ProductNumber, TbleDailyReports.SerialNumber, TbleDailyReports.Status, TbleDailyReports.EndingNumber, TbleDailyReports_1.ProductNumber FROM TbleDailyReports LEFT JOIN TbleDailyReports AS...

Yes these are enough

Start by downloading three things which i told you these are free

That is mysql 5.1

Here is the link where you can find all stuff http://dev.mysql.com/downloads/

You download it from mysql web site (search in google) you have to download database, odbc connector for mysql and graphical user interface tools to manage and link mysql databases to access

Do you mean sql sever by microsoft Sql if yes then both are different database products

then if form names are correct it should work