DateDiff Trouble Please Help a Newbie!

[JR93]

Hi guys this is my first post so sorry if it is the wrong section (I tried lol)
Iv'e got a DateDiff calculation in a query for my A Level project, trouble is intead of it giving me the actual days between my two desired dates it gives me the actual date between the first date and the date today

BTW this is what it looks like in SQL view: SELECT TBLBIKE.BIKE_ID, TBLBIKE.[CUSTOMER_ID*], TBLBIKE.BSTARTDATE, TBLBIKE.BNAME, TBLBIKE.BEQUIP, TBLBIKE.BDEADLINE, DateDiff("D", [BSTARTDATE],Date()) AS ACTUALDAYS
FROM TBLBIKE;



I would like it to workout the days between BSTARTDATE and BDEADLINE

Any help muchos appreciated!

[pkstormy]

SELECT TBLBIKE.BIKE_ID, TBLBIKE.[CUSTOMER_ID*], TBLBIKE.BSTARTDATE, TBLBIKE.BNAME, TBLBIKE.BEQUIP, TBLBIKE.BDEADLINE, DateDiff("D", [BSTARTDATE],Date()) AS ACTUALDAYS
FROM TBLBIKE;
would be:
SELECT TBLBIKE.BIKE_ID, TBLBIKE.[CUSTOMER_ID*], TBLBIKE.BSTARTDATE, TBLBIKE.BNAME, TBLBIKE.BEQUIP, TBLBIKE.BDEADLINE, DateDiff("D", [BSTARTDATE],[BDEADLINE]) AS ACTUALDAYS
FROM TBLBIKE;
or reverse the 2 date fields in: DateDiff("D", [BSTARTDATE],[BDEADLINE])

the above is providing that BDEADLINE is an actual date value and not a number. If it's a number (ie. designating # of days from the BStartDate), then you'll need to embed a dateadd in the expression such as:

DateDiff("D", [BSTARTDATE],DateAdd("d",[BDEADLINE],[BSTARTDATE]))