Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Lookups

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Lookups

Resolved · Low Priority · Version 2003

Reply Tue 9 Sep 2008, 16:32Delegate Khim said...

Khim has attended:
Access Intermediate course
Access Advanced course

Lookups

Can I get access to to give me an answer dependent on certain criteria? For example the first order received is a new order, second order is renewal or winback dependent on time between orders.

For upcoming training course dates see: Pricing & availability

Reply Wed 17 Sep 2008, 11:09Trainer Richard said...

RE: Lookups

Hello Khim,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding lookups.

I am not sure that I understand your question. You can get access to give you specific answers depending on your criteria. What I am not sure about is what you are trying to find out about the two orders.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Access articles

· Share And Share Alike With Microsoft Access 2010
· Be Top Of The Form With Access 2007
· Supersizing your databases via Microsoft Access
· Help Business To Go Global With Shared Databases
· A Place Of Trust: How Microsoft Have Made Access 2010 Even More Secure

Please browse our web site to find out more about
access database training and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips