range period of time in a date query access (1 Viewer)

JHB

Have been here a while
Local time
Today, 06:59
Joined
Jun 17, 2012
Messages
7,732
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.
 

kanxay

Registered User.
Local time
Yesterday, 22:59
Joined
May 18, 2019
Messages
37
Dear JHB ! excuse me to interrupt you, i need both of date and time appear on the TheDate field
 

Attachments

  • Hospital Invoice 2019 (1).accdb
    1 MB · Views: 116
  • Screenshot 2019-05-22 17.15.04.jpg
    Screenshot 2019-05-22 17.15.04.jpg
    90.6 KB · Views: 110

JHB

Have been here a while
Local time
Today, 06:59
Joined
Jun 17, 2012
Messages
7,732
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.
 

Attachments

  • PutTogether.xls
    17.5 KB · Views: 106

kanxay

Registered User.
Local time
Yesterday, 22:59
Joined
May 18, 2019
Messages
37
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
 

Attachments

  • 1.jpg
    1.jpg
    94.8 KB · Views: 115
  • 2.jpg
    2.jpg
    90.6 KB · Views: 120
  • help me please.accdb
    972 KB · Views: 125

JHB

Have been here a while
Local time
Today, 06:59
Joined
Jun 17, 2012
Messages
7,732
It should do it now (again)!
 

Attachments

  • help me please.accdb
    808 KB · Views: 113

kanxay

Registered User.
Local time
Yesterday, 22:59
Joined
May 18, 2019
Messages
37
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
 

Attachments

  • IMG_20190524_101154.jpg
    IMG_20190524_101154.jpg
    88.8 KB · Views: 95

JHB

Have been here a while
Local time
Today, 06:59
Joined
Jun 17, 2012
Messages
7,732
Okay - then show the final result you want!
 

kanxay

Registered User.
Local time
Yesterday, 22:59
Joined
May 18, 2019
Messages
37
:confused::banghead::eek: respectful and thanks advance Mr JHB
 

kanxay

Registered User.
Local time
Yesterday, 22:59
Joined
May 18, 2019
Messages
37
Dear JHB ! I am very Thank you , I already get the results match to the date and time all. Thanks again sir ! And everyone !!!
 

Users who are viewing this thread

Top Bottom