hey there,

hpe u'll help me throw more light on this ....i have build a query for a report. I want to generate records based on a single text input...my system is based on scholarship 4 students. i want to generate all records for a particular scholarship scheme.

In the Critera below scheme field in the query design..i've placed "WHERE [Scheme]'........is this rite?? becoz am not getting any prompt.lol.

am kinda newbie so i hpe u'll help me fix the problem.

thanx 4 the time

Regards!.

In design view, just put:

[Enter Scheme]

Hey thanx paul.

i wan t to ask u another thing. If i want to generate a report for a particular scheme and a particular scheme year...can i du it via the criteria stuffs again??
i.e i'll put [scheme year] under criteria for year!

Regards

That should work.

kool that works

thanx for ur great help.

great mind think alike, lol