G
Guest
I have a company database with stock trades done by our consultants. I need
to be able to pull out Monthly reports based on when trades are done with
user interaction. I know how to do basic criteria expressions for parameter
queries, but I'm afraid this one is a little beyond my current knowledge
base. I have two date fields that I need to work with [ProcessDate] and
[SettleDate]. The following statement (although probably not in the proper
format) will do the job for me: "Where [ProcessDate] <02/01/2005 And
[SettleDate] is Between 01/01/2005 And 01/31/2005 OR [ProcessDate] is
Between 01/01/2005 And 01/31/2005 And [SettleDate]<02/01/2005" This would
ideally give me the records I need for my reports. My problems are the
following: The actual dates need to be user input. The dates could be any
month. I used January and February only as an example above. Dates would be
great if just "January" or "August" or "March" could be entered to represent
the full month range of days. Additionally, I'm not sure where I would enter
the finished statement. Would it have to be a SQL syntax? Would I have to
setup another table to represent the months somehow? Any help would be most
appreciated.
Semperfi1967
to be able to pull out Monthly reports based on when trades are done with
user interaction. I know how to do basic criteria expressions for parameter
queries, but I'm afraid this one is a little beyond my current knowledge
base. I have two date fields that I need to work with [ProcessDate] and
[SettleDate]. The following statement (although probably not in the proper
format) will do the job for me: "Where [ProcessDate] <02/01/2005 And
[SettleDate] is Between 01/01/2005 And 01/31/2005 OR [ProcessDate] is
Between 01/01/2005 And 01/31/2005 And [SettleDate]<02/01/2005" This would
ideally give me the records I need for my reports. My problems are the
following: The actual dates need to be user input. The dates could be any
month. I used January and February only as an example above. Dates would be
great if just "January" or "August" or "March" could be entered to represent
the full month range of days. Additionally, I'm not sure where I would enter
the finished statement. Would it have to be a SQL syntax? Would I have to
setup another table to represent the months somehow? Any help would be most
appreciated.
Semperfi1967