Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-19-2019, 06:10 AM   #16
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Unhappy Re: range period of time in a date query access

JHB : one more question plz !!!
when we can select during time of the Date, but the (Total group by SUM) didn't sum Qty of the same Product .
how could i do ?

kanxay is offline   Reply With Quote
Old 05-19-2019, 11:04 AM   #17
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

Please could you clarify what you mean?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
kanxay (05-19-2019)
Old 05-19-2019, 02:33 PM   #18
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Re: range period of time in a date query access

JHB . Can not group by sumQty for the same product
How to do?

kanxay is offline   Reply With Quote
Old 05-19-2019, 07:49 PM   #19
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

Run the query in the attached database, is that what you want?
If not, put the data from the query in a Excel sheet and show me which data to put together.
Attached Files
File Type: accdb Hospital Invoice 2019.accdb (844.0 KB, 6 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 05-21-2019, 03:49 AM   #20
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Re: range period of time in a date query access

Dear JHB when i run the Query it doesn't show the time , it just show the date
TheDate: DateValue([Date and time])
Attached Images
File Type: jpg Screenshot 2019-05-21 18.42.40.jpg (97.5 KB, 5 views)
kanxay is offline   Reply With Quote
Old 05-21-2019, 11:12 AM   #21
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

The data you show in the printscreen isn't the same as in the database, so I can't use it to anything.
Please help me to help you, do what I wrote in post 19:
...
If not, put the data from the query in a Excel sheet and show me which data to put together.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
kanxay (Yesterday)
Old 05-22-2019, 02:22 AM   #22
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Re: range period of time in a date query access

Dear JHB ! excuse me to interrupt you, i need both of date and time appear on the TheDate field
Attached Images
File Type: jpg Screenshot 2019-05-22 17.15.04.jpg (90.6 KB, 4 views)
Attached Files
File Type: accdb Hospital Invoice 2019 (1).accdb (1.02 MB, 4 views)

kanxay is offline   Reply With Quote
Old 05-22-2019, 08:36 PM   #23
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

In the attached Excel sheet could you please show me how you want the result.
Because in first database I return to you I had the date and time shown, but then you wrote in post 16 you want to get some total.
Attached Files
File Type: xls PutTogether.xls (17.5 KB, 2 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
kanxay (Yesterday)
Old Yesterday, 05:54 AM   #24
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Re: range period of time in a date query access

Dear JHB ! I saw your excel Data that show all data, the date even THE TIME that is correct.

but on my computer when I enter parameter value Start.....End Date and time , it just only show all data and the date but it doesn't show the time like your excel Data you sent me. even though I export to excel spread sheet
Attached Images
File Type: jpg 1.jpg (94.8 KB, 3 views)
File Type: jpg 2.jpg (90.6 KB, 4 views)
Attached Files
File Type: accdb help me please.accdb (972.0 KB, 3 views)
kanxay is offline   Reply With Quote
Old Yesterday, 06:25 PM   #25
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

It should do it now (again)!
Attached Files
File Type: accdb help me please.accdb (808.0 KB, 2 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
kanxay (Yesterday)
Old Yesterday, 07:18 PM   #26
kanxay
Newly Registered User
 
Join Date: May 2019
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
kanxay is on a distinguished road
Re: range period of time in a date query access

I am really thankful for your help Mr JHB.
The last question for me , it shows the date , time and quantity ....
But I want to collect or sum the Same product in the difference Time to be once for count
Attached Images
File Type: jpg IMG_20190524_101154.jpg (88.8 KB, 5 views)
kanxay is offline   Reply With Quote
Old Yesterday, 07:26 PM   #27
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: range period of time in a date query access

Okay - then show the final result you want!

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate percentages over a period of time in a microsoft access query wire_jp Queries 2 08-31-2016 03:00 PM
query with time calculation based on a date range sanych10 Queries 0 06-01-2011 05:14 AM
Date/time period criteria confusion dmc12 Queries 1 01-30-2008 04:40 PM
Repeating date entries for a given time period AdamO Queries 1 08-03-2005 06:15 AM
Date\Time period between last record in table and given Time interval AlLeX_Brd Queries 7 07-06-2005 11:38 AM




All times are GMT -8. The time now is 05:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World