Getting Organized

[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.

 

[Ken Snell]

"...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?

 

[LMB]

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

"...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>

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.

 

[Ken Snell]

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>

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

"...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>

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.

 

[LMB]

Thanks!

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>

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

"...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>

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.