Help me wit this database creation

[vijay]

I am attaching a ms access databse file in zip format. it is patient information and investigations database with two reports printing. i can print report for given patient UHID field but how can i print reports for given range of Patient UHID, exampls print from UHID No 1 to 10. Also can someone make the input forms and reports look more presentable for me ??? I am new to MS Access.



Thank you very much.

[June7]

Advise avoid spaces and special characters/punctuation (underscore is exception) in naming convention.

Not going to do design for you. You will just have to do the tedious and time-consuming exercise of 'prettying up'. The design wizard groups controls, which is what I see on the forms. If you want to rearrange and resize controls, maybe best to 'ungroup' them. Select all the controls, right click > Layout > Remove.

If you want to print a range of patients, then criteria needs to be a range parameter, something like:

WHERE UHID BETWEEN 1 AND 10

One way to allow user input of the range values is by input into textboxes on form. Then options are:

1. parameterized query, review http://www.datapigtechnologies.com/f...mtoreport.html

2. code to construct the filter string, review: http://www.allenbrowne.com/ser-62code.html

[vijay]

Thank you very much. Rite now trying my hands on options you gave for input range.