UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Getting Query Blank On Office X64 Using Between Dateserial, Any Version    
 
   
Sweetu
post Jan 19 2020, 10:36 AM
Post#1



Posts: 115
Joined: 20-September 16



Hi fellas ,

I hope all are fine chilling ,

I wrote a query in MS access 365 64 bit to get the data of previous month and current month , it's working fine on office 365 and normal access 32bit but when i open the database on Normal Access 64bit while using the this below the whole access query appeared as blank in ms office 64bit , if I remove this date-serial query is working fine,

CODE
Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date())+1,0)
Go to the top of the page
 
theDBguy
post Jan 19 2020, 11:17 AM
Post#2


UA Moderator
Posts: 77,520
Joined: 19-June 07
From: SunnySandyEggo


Are you getting any error messages?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Jan 19 2020, 11:47 AM
Post#3


UA Admin
Posts: 36,778
Joined: 20-June 02
From: Newcastle, WA


Are all of these versions of Access linked to the same data?

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Sweetu
post Jan 19 2020, 01:33 PM
Post#4



Posts: 115
Joined: 20-September 16



@GroverParkGeorge , @theDBguy

Thanks for your concern

yes , linked to same tables , Error is type mismatch (or sometime no errors at all only blank query) when i open the Query in Office 64bit (normal/desktop version) than MS access not responding on my that machine & crashed , if I remove the between date serial from query everything working fine & opening normally

on my office 365 64bit there are no errors on this query ,
This post has been edited by Sweetu: Jan 19 2020, 01:34 PM
Go to the top of the page
 
Sweetu
post Jan 20 2020, 03:07 PM
Post#5



Posts: 115
Joined: 20-September 16



any suggestion please
Go to the top of the page
 
theDBguy
post Jan 20 2020, 03:14 PM
Post#6


UA Moderator
Posts: 77,520
Joined: 19-June 07
From: SunnySandyEggo


Do you see any missing references?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sweetu
post Jan 21 2020, 01:33 PM
Post#7



Posts: 115
Joined: 20-September 16



I checked but no references are missing
Go to the top of the page
 
GroverParkGeorge
post Jan 21 2020, 01:39 PM
Post#8


UA Admin
Posts: 36,778
Joined: 20-June 02
From: Newcastle, WA


Does your code compile?

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
theDBguy
post Jan 21 2020, 01:43 PM
Post#9


UA Moderator
Posts: 77,520
Joined: 19-June 07
From: SunnySandyEggo


Hi. Just as a test, to eliminate the data, try replacing the DateSerial() criteria with literal dates.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sweetu
post Jan 21 2020, 02:24 PM
Post#10



Posts: 115
Joined: 20-September 16



in reference table column dates are different , what should i replace , please suggest
Go to the top of the page
 
GroverParkGeorge
post Jan 21 2020, 02:29 PM
Post#11


UA Admin
Posts: 36,778
Joined: 20-June 02
From: Newcastle, WA


"...in reference table column dates are different..."

In what specific way(s) are the dates different? We can't see them, so we need you to explain.

Thank you.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
theDBguy
post Jan 21 2020, 04:41 PM
Post#12


UA Moderator
Posts: 77,520
Joined: 19-June 07
From: SunnySandyEggo


Hi. What I was referring to with my suggestion was to replace your criteria from something like:

Between DateSerial(blah...) And DateSerial(blah...)

to something like:

Between #1/1/2020# And #1/21/2020#

But make sure to use a pair of dates that make sense to you. For example, what dates were you expecting to get when you use DateSerial()?

Hope that make sense...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sweetu
post Feb 3 2020, 01:45 PM
Post#13



Posts: 115
Joined: 20-September 16



thank you for all of your advises & expert suggestions

I removed the dateserial & just updating the table with current & last month date values
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th February 2020 - 03:34 AM