Search results

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.

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...

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!