Recent content by sdk

Is it possible to scan documents from the form, and place them as attachments to the table?

Problem solved.Thank you both.

SELECT Table1.Job, Table1.start_date, Table1.end_date, Table1.period, DateDiff("d",[start_date],[end_date]) AS datedif, IIf([datedif]>[Period],"True","False") AS Expr1 FROM Table1 WHERE (((IIf([datedif]>[Period],"True","False"))=True));

thanks for the answer Hm, when I enter "true" in the criteria and run a query, the query ask me to enter data for the first new field (I called it datedif), when I leave empty criteria, the query normally runs

Hi.I need little help. table has columns: job, start_date, start_time, end_date, end_time, period. I need a query that will extract all jobs for which it is needed more days than it is provided in the period column. I'm new in Access, so I have no idea how to do it...

Hello everyone. I just started learning access. I need help on some things, so I hope I came to the right place.