Hello,
I have couple of problems with my Queries for my Database.
1. Enter Value Parameter comes up everytime I go to Datasheet View
2. Today Date comes up in my Datasheet view. If I hide it The formula doesnt work
I dont want my database to ask me about enter parameter and today's date shouldn't comes up in datasheet view and my formula works correctly. Please see SQL for my db. Please help. I have attached screen shot in the attachment,, Thanks
SELECT DateDiff("d",[Date_Open],[Today]) AS [Total Days], AUNPRDF_AAA802.AAAGE AS Age, AUNPRDF_AAA802.AAWKSP AS Workshop, AUNPRDF_AAA802.AAORD AS [Job Number], AUNPRDF_AAA802.AASWKT AS WorkType, AUNPRDF_AAA802.AANAME AS [Customer Name], AUNPRDF_AAA802.AANME AS [Service Admin], AUNPRDF_AAA802.AASDE1 AS Complaint, AUNPRDF_AAA802.AASDE2 AS Cause, AUNPRDF_AAA802.AASDE3 AS Correction, Sum(AUNPRDF_AAA802.AATOT) AS Total, CDate(Right([AAODTE],2) & "/" & Mid([AAODTE],5,2) & "/" & Left([AAODTE],4)) AS Date_Open, Date() AS Today, AUNPRDF_AAA802.AARTYP
FROM AUNPRDF_AAA802
GROUP BY DateDiff("d",[Date_Open],[Today]), AUNPRDF_AAA802.AAAGE, AUNPRDF_AAA802.AAWKSP, AUNPRDF_AAA802.AAORD, AUNPRDF_AAA802.AASWKT, AUNPRDF_AAA802.AANAME, AUNPRDF_AAA802.AANME, AUNPRDF_AAA802.AASDE1, AUNPRDF_AAA802.AASDE2, AUNPRDF_AAA802.AASDE3, CDate(Right([AAODTE],2) & "/" & Mid([AAODTE],5,2) & "/" & Left([AAODTE],4)), Date(), AUNPRDF_AAA802.AARTYP
HAVING (((AUNPRDF_AAA802.AARTYP)="1"));
Thanks, Lucky