customer history

I

ICTkirsten

Registered User.

Local time

Today, 13:10

Joined

Jan 3, 2015

Messages

137

• Mar 7, 2015

• #1

Hiya,

Im currently trying to create a way of displaying a history of the last 10 records of a customer ONLY.

so to try and make myself clearer; basically im a dentist and to perform operation i need to be able to view a customers teeth history for the last 10visits.

So what i have ATM is a form that allows me to create new teeth entries however i would like it to allow me to click a button that shows the teeth history of that customer (BUT ONLY FOR 10 RECORDS- maybe this would require something that would stop the amount of records exceeding 10?)

I have a table that contains teeth id, customerID ,back teeth, front teeth and date ...

Please could someone advice with me with what to do or provide an idea...


p.s i will not b able to post up my current DB so im sorry if what i have provided is limited

 

GinaWhipp

AWF VIP

Local time

Today, 08:10

Joined

Jun 21, 2011

Messages

5,899

• Mar 7, 2015

• #2

Maybe something like...

Code:

SELECT TOP 10 CustomerID, TeethID, DateField
FROM YourTableName
ORDER BY DateField DESC

 

I

ICTkirsten

Registered User.

Local time

Today, 13:10

Joined

Jan 3, 2015

Messages

137

• Mar 7, 2015

• #3

Heya,
where would the code go?

 

GinaWhipp

AWF VIP

Local time

Today, 08:10

Joined

Jun 21, 2011

Messages

5,899

• Mar 7, 2015

• #4

You would use that to create a query and then assign it as the Recordsource of the Subform.

 

I

ICTkirsten

Registered User.

Local time

Today, 13:10

Joined

Jan 3, 2015

Messages

137

• Mar 7, 2015

• #5

Just a quick one..

What does SELECT top 10 customer ID mean? im not too sure about how i would do it?

 

jdraw

Super Moderator

Staff member

Local time

Today, 08:10

Joined

Jan 23, 2006

Messages

15,586

• Mar 7, 2015

• #6

ICTKirsten,

For SQL info see SQL LInk

For Access functions see Access functions

 

GinaWhipp

AWF VIP

Local time

Today, 08:10

Joined

Jun 21, 2011

Messages

5,899

• Mar 7, 2015

• #7

Are you saying you don't understand Post#4? Because that is the answer to your question. I'm not sure how else I would say it.

 

I

ICTkirsten

Registered User.

Local time

Today, 13:10

Joined

Jan 3, 2015

Messages

137

• Mar 9, 2015

• #8

oh dont worry i understand now thank you