how to create query relating to due date + 10days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having problems in creating a query, which amongst other things producers a
due date for payment, which is the order date + 10 days. Does anyone know how
to do this?
 
Thank you Rodney, I'm not sure if that will work but will suggest it to my
friend. Its been quite a few years since working with Access but my friend
was actually thinking that the function needed is DateAdd, but we cant figure
out how to accept the date from another field on a table, and how to actually
include the function in the query.

Rodney said:
Try this
In a blank field say naxt to orderdate type,
due date: [orderdate]+10

Jsmn_Can said:
Having problems in creating a query, which amongst other things producers a
due date for payment, which is the order date + 10 days. Does anyone know how
to do this?
Click to expand...
Click to expand...
 
In the query grid,

Field: DateDue: DateAdd("d",10,[Order Date])

This will produce a new column in the query. The value of DateAdd is that
you can add days (d), months(m), or years(yyyy). Also, quarters(q),
weeks(ww), hours(h), minutes(n), or seconds(s) to a datetime field.

Jsmn_Can said:
Thank you Rodney, I'm not sure if that will work but will suggest it to my
friend. Its been quite a few years since working with Access but my
friend
was actually thinking that the function needed is DateAdd, but we cant
figure
out how to accept the date from another field on a table, and how to
actually
include the function in the query.

Rodney said:
Try this
In a blank field say naxt to orderdate type,
due date: [orderdate]+10

Jsmn_Can said:
Having problems in creating a query, which amongst other things
producers a
due date for payment, which is the order date + 10 days. Does anyone
know how
to do this?
Click to expand...
Click to expand...
Click to expand...
 
Hi John and Rodney - thank you so much for your help with this. It help and
the problem is now resolved. We were also able to use the following formula

just DueDate = OrderDate + 10

Thank you again
Jasmine

John Spencer said:
In the query grid,

Field: DateDue: DateAdd("d",10,[Order Date])

This will produce a new column in the query. The value of DateAdd is that
you can add days (d), months(m), or years(yyyy). Also, quarters(q),
weeks(ww), hours(h), minutes(n), or seconds(s) to a datetime field.

Jsmn_Can said:
Thank you Rodney, I'm not sure if that will work but will suggest it to my
friend. Its been quite a few years since working with Access but my
friend
was actually thinking that the function needed is DateAdd, but we cant
figure
out how to accept the date from another field on a table, and how to
actually
include the function in the query.

Rodney said:
Try this
In a blank field say naxt to orderdate type,
due date: [orderdate]+10

:

Having problems in creating a query, which amongst other things
producers a
due date for payment, which is the order date + 10 days. Does anyone
know how
to do this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top