Subtracting Dates in Queries

[seanpbent]

My form consists of a textbox with a selected date. I have a combo box with integers 1-15. I have a table with 15 people and their birthdays.



I am trying to find the birthdays after a selected date by the integer selected in the combo box. For example, if I select 2/1/2013, and pick 7 in the combo box, the subform should show me people with birthdays 2/1 through 2/8.

I have a query with a datediff function. This is my query expression Expr1: DateDiff("d",[DateofBirth],[Forms]![Calendar]![Text1]) The criteria is <=[Forms]![Calendar]![Combo3].

It displays some data, but it's not consistent at all. I'm hoping to fix this without any SQL changes or form code. But if that's what I need, I'll do it.

I'm using access 2010, and I'm fairly new at it. Sorry if I'm posting to the wrong place.

[ketbdnetbp]

seanpbent -

You could try...

Between [forms]![Calendar]![Text1] And DateAdd("d",[forms]![Calendar]![Combo3],[forms]![Calendar]![Text1])

in the criteria row of the "DateofBirth" field. Delete the column "exp1" or delete the criteria row text in that field. Assumes [Text1] is a date field.

See if that produces the desired results.

All the best,

Jim