I did this kind of operation on previous access version I have no troubles at all.

Interesting. Post the SQL.

Richard please help me I am stuck with this. Can I send you an screen shot so you can see what happen?

Disregard the previous one.

SELECT SARs.MemberID, Members.CustName, SARs.Continuing, SARs.Analyst, SARs.Comments, [FillingDate]+([Continuing]*90) AS Next90Day, [Next90Day]+30 AS ContinuingDate, [AcctOpenDate]+30 AS FillingDate, Round(([ContinuingDate]-Date())) AS DaysCount
FROM SARs INNER JOIN Members ON SARs.MemberID = Members.MemberID
WHERE (((Round(([ContinuingDate]-Date())))30) AND ((SARs.NotFiled)=False) AND ((SARs.SARFiled)=False));

First, you can upload screen shots. See the Upload Images link at the top of the thread (on the right?)

Second, your SQL looks fine to me, aside from you're MULTIPLYING by 90 days instead of adding. What does it return?

You can't use a calculated field in the same query, it's too complex.
Save the Query with ContinuingDate first, then create a new Query based off the first and add those extra fields

Yep. Exactly what Alex said. Your query is too complex. You'll have to create nested queries. Or don't rely on that value, redo the math again in the next column.

Richard what video do you talk about nested queries?

Hi another question! My boss is asking me to change the alignment of the data on the Query it this posible?  I pressing the alignment ribbons but don't works.

Hi Leo. I don't really have one lesson on nested queries. I've done it a bunch of times throughout my lessons though. It's basically making one query with calculations and then saving it. Now make a second query that pulls from those results. You do this when you run into the problem you're experiencing. Another one of my members actually asked a question about this a little while back, so it's in the TechHelp queue. Video coming soon.

No, you cannot change the alignment of fields in a QUERY. That's what FORMS are for.

Ok thanks for everything I solved the problem of the original query.

Richard please help me.  I did split my data base therefore I have my tables in a separate file. Now I need to create a new table but I have no idea to added to the front end file.  Pleas help.

Use the Linked Table Manager.

How to un split can I put back the database as how was before? Is that explained in this link you sent me?

Did you use the Access Split Database Seminar?

You can just copy the objects from the BE back into the FE.
Question is why?

Yeah, just delete the links to the tables you've got and IMPORT the tables from the BE file.

This is all covered in Access Expert 21.

Richard please help me! How can I set a parameter in a query using ,greater than or less than and so on.  I am tiring this but don't works "less than[Enter days]" Note I have to write in letter since did not appear when I summitted.

Yeah, my site strips out < and > to prevent HTML from being added. When you type in a parameter value like that in a query, it's treated like TEXT, so you need to convert it to a number value:

< CLng([Enter Number of Days])

That should do it.

Someone else asked the same question recently in the TechHelp queue. It's in the list for a video.

Rick please give an heads up I am preparing a quality control questionnaire that will  be completed for all accounts an I am stuck I do not have idea how to relates this tables.  Any idea? Or any course you recommend me to see?

Is this related to your previous question, or is this something new?

new