Getting Organized


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

Advertisements

K

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?
 
L

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

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

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>

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

Advertisements

L

LMB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top