Pivot Table showing date range from query

[Bibi]

I posted this in forms design and didn't have a response - I really need help.

I need to create a form or report in pivot table format for data from a
query based on a date range - I can do this BUT I am not able to get the
start and end dates to appear on the final form, leaving the manager
guessing.....not good. I've tried subforms to no avail. All help welcome.

 

[KARL DEWEY]

I assume you are using a criteria of BETWEEN in your query for the data
range. Copy the between criteria and edit it after pasting in two field row
positions of the query in design view. This --- BETWEEN [Enter start] AND
[Enter end]
To this --
Start_Date: [Enter start]
And this --
End_Date: [Enter end]
The reason to copy, paste edit is to make absolutely sure it is the same as
criteria, otherwise it will prompt again.
Some folks say not to use prompts bu use a form with text boxes. The it
would be like this ---
Criteria --
BETWEEN [Forms]![YourFormName]![TextBoxStart] AND
[Forms]![YourFormName]![TextBoxEnd]

Start_Date: [Forms]![YourFormName]![TextBoxStart]

End_Date: [Forms]![YourFormName]![TextBoxEnd]

 

[Bibi]

Thank you so much for taking the time to help. I understood your comment
about the two fields . Thank you - I never knew that I could use the same
name. I always avoided doing that before - a pitfall when you're self
taught. The other selftaught pitfall is that I do not understand your
comment about the forms- I don't write code and just can't get anything to
work...and I really need to get something to work so that I can show the date
range on the final report or form - I can't get anything to work on a pivot
table which is the format of choice. Any insight will be greatly appreciated.
--
TIA
Bibi

I assume you are using a criteria of BETWEEN in your query for the data
range. Copy the between criteria and edit it after pasting in two field row
positions of the query in design view. This --- BETWEEN [Enter start] AND
[Enter end]
To this --
Start_Date: [Enter start]
And this --
End_Date: [Enter end]
The reason to copy, paste edit is to make absolutely sure it is the same as
criteria, otherwise it will prompt again.
Some folks say not to use prompts bu use a form with text boxes. The it
would be like this ---
Criteria --
BETWEEN [Forms]![YourFormName]![TextBoxStart] AND
[Forms]![YourFormName]![TextBoxEnd]

Start_Date: [Forms]![YourFormName]![TextBoxStart]

End_Date: [Forms]![YourFormName]![TextBoxEnd]

--
KARL DEWEY
Build a little - Test a little

I posted this in forms design and didn't have a response - I really need help.

I need to create a form or report in pivot table format for data from a
query based on a date range - I can do this BUT I am not able to get the
start and end dates to appear on the final form, leaving the manager
guessing.....not good. I've tried subforms to no avail. All help welcome.