dynamictiger
Registered User.
- Local time
- Today, 10:34
- Joined
- Feb 3, 2002
- Messages
- 270
I don't understand why straight forward things in this specific database are being so problematic. The only explanation I can think of is I haven't worked in 2016 much, with most of the work I have done in earlier versions of Access.
I have a form with three unbound fields. One combo box for the client and two unbound text boxes for dates.
I have a query to return records belonging to the clients, with the intent of getting only the records between the dates.
SQL as below at time of testing as there is an issue:
The issue is with the data on the form in field txtDTto. No matter what I do with this the field on the query returns a blank.
On the form the dates I am inputting are 1/1/19 and 20/1/19 I have formatted to match the data stored in SQL for the first date in Expr2, however have removed the formatting in Expr3 to simply get anything returned after finding it is returning nothing at all.
I am certain this is a follicle challenge...As in MS Access attempting to remove the remaining follicles I have in frustration.
I really dont have any idea how to diagnose this isssue any further. I even created a query to simply return the two dates and the query returns blank fields regardless of how the form is populated?
I have a form with three unbound fields. One combo box for the client and two unbound text boxes for dates.
I have a query to return records belonging to the clients, with the intent of getting only the records between the dates.
SQL as below at time of testing as there is an issue:
Code:
SELECT TOP 100 dbo_WaterBody.WBName, dbo_WaterBodyLogs.LogTime,
dbo_ChemicalParameters.Parameter, dbo_ChemicalParameters.ShortCode,
dbo_WaterBodyLogs.Result, dbo_Clients.Clientid, Left([LogTime],10) AS Expr1,
Format([Forms]![Form1]![txtFro],"yyyy-mm-dd") AS Expr2,
[Forms]![Form1]![txtDtTo] AS Expr3
FROM (((dbo_WaterBody INNER JOIN dbo_WaterBodyLogs ON dbo_WaterBody.WaterBodyID =
dbo_WaterBodyLogs.WaterBodyID) INNER JOIN dbo_ChemicalParameters ON
dbo_WaterBodyLogs.ChemicalParameterID = dbo_ChemicalParameters.ChemicalParameterID)
INNER JOIN dbo_Site ON dbo_WaterBody.SiteID = dbo_Site.SiteID)
INNER JOIN dbo_Clients ON dbo_Site.Clientid = dbo_Clients.Clientid
WHERE (((dbo_Clients.Clientid)=[Forms]![Form1]![cboClient]));The issue is with the data on the form in field txtDTto. No matter what I do with this the field on the query returns a blank.
On the form the dates I am inputting are 1/1/19 and 20/1/19 I have formatted to match the data stored in SQL for the first date in Expr2, however have removed the formatting in Expr3 to simply get anything returned after finding it is returning nothing at all.
I am certain this is a follicle challenge...As in MS Access attempting to remove the remaining follicles I have in frustration.
I really dont have any idea how to diagnose this isssue any further. I even created a query to simply return the two dates and the query returns blank fields regardless of how the form is populated?
