Query Help

[MTSPEER]

Hey guys Im new to Access and SQL. But my database is survey information. I have 3 tables. [Customer] has the info about the customer. [Survery Info] has the survey questions and answers. And [HealthPlan] has that info. But I want to make a query within the HealthPlan Table. The fields are Phone 1, and Phone 2. If the phone call is not returned within 15 days to display the records. I tried the codes.

Select [Phone 1], [Phone 2]


From HealthPlan
Where [Phone 2] - [Phone 1] >15

and

Select * from HealthPlan
Where [Phone 2] - [Phone 1] >15

And they just show blank records, with no information. anyone know why?

[JoeM]

Are your fields [Phone 1] and [Phone 2] formatted as Date fields (or Text)?
Are they always populated (or sometimes blank)?
Can you post a few examples where you think it should be returning records and it isn't?

[MTSPEER]

Nevermind I figured it out. thank you anyways.