Getting Organized

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

I'm trying to get my access stuff organized. Here are some scripts I have
on a notepad sheet. Are these only for use in queries or do they work in
reports too?

Thanks,
Linda

Between [Enter Start Date] And [Enter End Date]

BirthDate:CVDate(IIf(IsNull([dttBirthday]),
Null,DateSerial(2000,Month([dttBirthday]),Day([dttBirthday]))))


Between [Beginning Date] And [Ending Date]
User will be prompted for date between date of user choosing

Between #11/01/2000# And #11/30/2000#
Will give information between developers critera


Criteria: >=DateAdd("d",-84,Date())
This would get all OnCallDate records that are less than 84 days old.
 
"...work in reports..." means what? If you use these criteria expressions in
a query and that query is the recordsource of a report, then yes they'd work
in a report.

But is that what you're asking?
 
Heck...I don't know what I am asking. Yes, I think that's what I am asking.
<g> Well, are there times that these scripts can be entered into a textbox
on a report? I am making folders in My Documents Folder under
Access..............Table, Queries, Forms, Reports and putting documents,
links, and things that pertain to those categories. I am trying to figure
out where I should put these and I have others scattered around my computer.
I'm trying to get organized so I can find "my stuff"

Thanks, Ken.

Linda

Ken Snell said:
"...work in reports..." means what? If you use these criteria expressions in
a query and that query is the recordsource of a report, then yes they'd work
in a report.

But is that what you're asking?

--

Ken Snell
<MS ACCESS MVP>

LMB said:
Hi Guys,

I'm trying to get my access stuff organized. Here are some scripts I have
on a notepad sheet. Are these only for use in queries or do they work in
reports too?

Thanks,
Linda

Between [Enter Start Date] And [Enter End Date]

BirthDate:CVDate(IIf(IsNull([dttBirthday]),
Null,DateSerial(2000,Month([dttBirthday]),Day([dttBirthday]))))


Between [Beginning Date] And [Ending Date]
User will be prompted for date between date of user choosing

Between #11/01/2000# And #11/30/2000#
Will give information between developers critera


Criteria: >=DateAdd("d",-84,Date())
This would get all OnCallDate records that are less than 84 days old.
Click to expand...
Click to expand...
 
None of the examples that you've shown would be used as the ControlSource of
a textbox on a report. They would be used potentially as validations, as
query criteria, as "If .. Then" comparisons, etc.

But, what you've posted as a group looks mostly as stuff for queries.

--

Ken Snell
<MS ACCESS MVP>

LMB said:
Heck...I don't know what I am asking. Yes, I think that's what I am asking.
<g> Well, are there times that these scripts can be entered into a textbox
on a report? I am making folders in My Documents Folder under
Access..............Table, Queries, Forms, Reports and putting documents,
links, and things that pertain to those categories. I am trying to figure
out where I should put these and I have others scattered around my computer.
I'm trying to get organized so I can find "my stuff"

Thanks, Ken.

Linda

Ken Snell said:
"...work in reports..." means what? If you use these criteria
Click to expand...
expressions
in
a query and that query is the recordsource of a report, then yes they'd work
in a report.

But is that what you're asking?

--

Ken Snell
<MS ACCESS MVP>

LMB said:
Hi Guys,

I'm trying to get my access stuff organized. Here are some scripts I have
on a notepad sheet. Are these only for use in queries or do they work in
reports too?

Thanks,
Linda

Between [Enter Start Date] And [Enter End Date]

BirthDate:CVDate(IIf(IsNull([dttBirthday]),
Null,DateSerial(2000,Month([dttBirthday]),Day([dttBirthday]))))


Between [Beginning Date] And [Ending Date]
User will be prompted for date between date of user choosing

Between #11/01/2000# And #11/30/2000#
Will give information between developers critera


Criteria: >=DateAdd("d",-84,Date())
This would get all OnCallDate records that are less than 84 days old.
Click to expand...
Click to expand...
Click to expand...
 
Thanks!


Ken Snell said:
None of the examples that you've shown would be used as the ControlSource of
a textbox on a report. They would be used potentially as validations, as
query criteria, as "If .. Then" comparisons, etc.

But, what you've posted as a group looks mostly as stuff for queries.

--

Ken Snell
<MS ACCESS MVP>

LMB said:
Heck...I don't know what I am asking. Yes, I think that's what I am asking.
<g> Well, are there times that these scripts can be entered into a textbox
on a report? I am making folders in My Documents Folder under
Access..............Table, Queries, Forms, Reports and putting documents,
links, and things that pertain to those categories. I am trying to figure
out where I should put these and I have others scattered around my computer.
I'm trying to get organized so I can find "my stuff"

Thanks, Ken.

Linda

Ken Snell said:
"...work in reports..." means what? If you use these criteria
Click to expand...
expressions
in
a query and that query is the recordsource of a report, then yes
Click to expand...
they'd
work
in a report.

But is that what you're asking?

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

I'm trying to get my access stuff organized. Here are some scripts
Click to expand...
I
have
on a notepad sheet. Are these only for use in queries or do they
Click to expand...
work
in
reports too?

Thanks,
Linda

Between [Enter Start Date] And [Enter End Date]

BirthDate:CVDate(IIf(IsNull([dttBirthday]),
Null,DateSerial(2000,Month([dttBirthday]),Day([dttBirthday]))))


Between [Beginning Date] And [Ending Date]
User will be prompted for date between date of user choosing

Between #11/01/2000# And #11/30/2000#
Will give information between developers critera


Criteria: >=DateAdd("d",-84,Date())
This would get all OnCallDate records that are less than 84 days old.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top