Search results

For rounding to 2 decimal places, try this : =(int((Sum([UnitQty]*[UnitCost]))*100+0.5)/100)

ajetrumpet, Yes,as long as i can get the answer that i want. Can you show the method to me? I want to generate a yearly report which shows the attendance of the sundry workers during a whole year. The report format is looks like below: Month - Jan , Feb , Mar, Apr , May, Jun, Jul, Aug...

I just want to create a query that will automatic show all the days that are available during the specific month. Let say,if i key in february 2008, then the query will shows all the available days, i.e from 1/2/2008 to 29/2/2008. Is it possible? Thank you.

Hi! I want to show all the days in the specific month, e.g. there are 29 days in february 2008 and the records will display all the days that are available as below: 1/2/08 2/2/08 3/2/08 .. .. .. 29/2/08 What is the syntax? Thank you.

Jon K Thanks!!!

Dear All: I have a problem in calculating distance's mileage.Eg: Distance from town A to town B is 10km, town A to town C is 20km and vice versa. I have a table named "Location" as per below:- Town From , Town To , Distance A , B...

Is anyone knows how to design a report that has a fixed number of rows? Example in my table called "Subject", there is a field "SubjectTaken". I want to show 10 rows of the field "SubjectTaken" in the report. i.e if a user key in 5 records only, the report will show the 5 records and also will...

How to prevent other users from edit our data in a multiusers environment Hi! I have a problem in my access database which is located in a server for multiuser environment. The system is allow user to add record and then print out the report. My problem is, if there are two person login to the...

My If Then Else statement will only execute the first record. Example if there are four records, the statement look at first record to execute. Example: If varX = "Hardware" then Docmd.openForm1 else if varX = "Software" then Docmd.openForm2 else Docmd.openForm3 My data are as follow...

Need Help in VBA My If Then Else statement will only execute the first record. Example if there are four records, the statement look at first record to execute. Example: If varX = "Hardware" then Docmd.openForm1 else if varX = "Software" then Docmd.openForm2 else Docmd.openForm3 My data...

How To Make Comparison Between 3 Records Based On Priority? I'm having a problem to select a record which is based on priority. It can solve by the If Then Else statement, but I am new to VBA, therefore don't know how to code. Here is the example of the data,there are three fileds as below...

Find the max record which group by date I have a problem to find the last record of my table which are sort by date. Eg: Date - Time -Product 1/1/04 - 6am - A 1/1/04 - 9am - B 2/1/04 - 7am - A 2/1/04 - 10am - B 3/1/04 - 8 am - A 3/1/04 - 10 am - B...

Use wizard button to preview report You can use the wizard button to help you open report, just follow the instruction

Display message in report I have a report which show orders details by state. Let's say there are 3 states: A,B,C. I do the report separately and combine them using subreport. If there is no order for state B, the report will show "No order for state B".Can anyone help me? Thanks!

I want to open a form2 after I key in a number in form1, the problem is: the number in form1 must be in a range of numbers in field A and filed B in table Order, if the number I key in form1 match the criteria, it will show form2, otherwise an error message will display!How? Thanks!