K
kaosyeti
i have a db that i'm trying to construct to track customer contacts in a car
dealer. when finished, it needs to be VERY easy to use because most of the
end users are not that proficient with computers. that being said, my
methods described here may seem unnecessarily complicated but please believe
that they're necessary.
i have a form that asks a user to fill in a few fields and then creates a
query based on the data put into the form. the query is created, immediately
prints a report, then closes. part of the data from the form is a startdate
and enddate that is the range of time that the query calculates. the table
which holds the data has just one date field.
now, on my report i have a date range text box that is almost TOO accurate.
it pulls the lowest and highest values of any of the dates from the query and
looks like this:
="Date Range " & Min([qrycontactdata]![Date]) & " through " & Max(
[qrycontactdata]![Date])
the problem is that there may be no data for a customer on a specific date
towards the beginning of the month. so, for example, the report for october
of 05 may state "Date Range 10/03/2005 through 10/31/2005" when the user had
actually entered 10-01-05 as the startdate. this may not seem like a big
deal but when someone is looking at this report down the road, it won't make
sense to them why is doesn't reflect data from the first 2 days of the month.
so, how can write an expression that pulls the startdate from whatever the
person put into the form that creates the report? i'm more than happy to
email/upload this db for anyone who needs to see it to answer this question
(you'll just have to tell me where/how). Thanks.
dealer. when finished, it needs to be VERY easy to use because most of the
end users are not that proficient with computers. that being said, my
methods described here may seem unnecessarily complicated but please believe
that they're necessary.
i have a form that asks a user to fill in a few fields and then creates a
query based on the data put into the form. the query is created, immediately
prints a report, then closes. part of the data from the form is a startdate
and enddate that is the range of time that the query calculates. the table
which holds the data has just one date field.
now, on my report i have a date range text box that is almost TOO accurate.
it pulls the lowest and highest values of any of the dates from the query and
looks like this:
="Date Range " & Min([qrycontactdata]![Date]) & " through " & Max(
[qrycontactdata]![Date])
the problem is that there may be no data for a customer on a specific date
towards the beginning of the month. so, for example, the report for october
of 05 may state "Date Range 10/03/2005 through 10/31/2005" when the user had
actually entered 10-01-05 as the startdate. this may not seem like a big
deal but when someone is looking at this report down the road, it won't make
sense to them why is doesn't reflect data from the first 2 days of the month.
so, how can write an expression that pulls the startdate from whatever the
person put into the form that creates the report? i'm more than happy to
email/upload this db for anyone who needs to see it to answer this question
(you'll just have to tell me where/how). Thanks.