Search results

Try this... ((Date()-[date of birth])\365 so you don't have to rewrite the current date on the next run...

For example: i have only 1 table tblMainTable -mainID -Date -Wages how do i used this data to query the prev wage and prev date of the next consecutive wage and date? (I want to query the prev.date and prev.wage column to see the pattern in change) . Should i break this data into 2 queries...

Good advice. Thanks!

That makes sense. Thank you for explaining this to me. Much more to learn.

Hi I have a follow up question similar to this. I'm new to Access. I saw IIf(Weekday(Date()=2,Date()-3,Date()-1)). What does this mean? Thanks.

What if there's no begin date or end date? For example: i have only 1 table tblMainTable -mainID -Date -Wages how do i used this data to query the prev wage and prev date of the next consecutive wage and date? (I want to query the prev.date and prev.wage column to see the pattern in...

Hi I'm new to Access and would like to use the Dlookup to set criteria to look up some data. I heard this is a valueable function. Can someone provide an example, possibility a database uploaded for me to see. I don't understand the sql language. :( Thanks.