Date Range from a Single Field

  • Thread starter Thread starter NippyLnR
  • Start date Start date
N

NippyLnR

I have a database for payroll information. There are 3 quries that run to
get the necesary information. There is a prompt for Begining and Ending Pay
Dates.
How can I get this to appear on a Report as a Start and End date?

I am not an advanced user so the simplest way is the best way for me at this
time.
Thank you
Brian
 
Open the query that has the prompts in design view showing the grid.
Copy the portion of the criteria enclosed in brackets that reads something
like 'Enter Begining Pay Date' and scroll to the right to find a blank
column.
In the Field row of that column type 'Beginning:' and paste so it will
appear like this --
Beginning: [Enter Begining Pay Date]
Do the same for ending.
The reason for copying and pasting is to make sure there is no diffferences
in the two places.
Use the new query fields in your report.

Many people recommend not using prompts but a form with unbound textboxes
for the criteria data entry.
 
Thank You SO Very Much Karl. That will do the trick for sure.

I am not an very advanced user, what I know I tought myself from trial and
error. The prompts work well for others that will be using these databases
eventuall.

Again THANK YOU!!!!!!
Brian

KARL DEWEY said:
Open the query that has the prompts in design view showing the grid.
Copy the portion of the criteria enclosed in brackets that reads something
like 'Enter Begining Pay Date' and scroll to the right to find a blank
column.
In the Field row of that column type 'Beginning:' and paste so it will
appear like this --
Beginning: [Enter Begining Pay Date]
Do the same for ending.
The reason for copying and pasting is to make sure there is no diffferences
in the two places.
Use the new query fields in your report.

Many people recommend not using prompts but a form with unbound textboxes
for the criteria data entry.

--
KARL DEWEY
Build a little - Test a little


NippyLnR said:
I have a database for payroll information. There are 3 quries that run to
get the necesary information. There is a prompt for Begining and Ending Pay
Dates.
How can I get this to appear on a Report as a Start and End date?

I am not an advanced user so the simplest way is the best way for me at this
time.
Thank you
Brian
Click to expand...
Click to expand...
 
Back
Top