Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

lookups

ResolvedVersion 2003

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.

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 tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.