Help! Need a calculation

J

Jill

Hi,

I'm having trouble figuring out a calculation for an
invoice report in Access 2000.

Can anyone help?

What function or calculation would I need for this:

"effective date with current year to effective date the
next year minus a day"

Thanks for any help!
 
R

Ray at

I suggest posting to a forum that is related to what you're trying to do.
This group covers the Windows 2000 operating system.

Ray at work
 
P

Pegasus \(MVP\)

An MS Access or MS Office newsgroup would be a good
starting point for your question.
 
G

Guest

Sorry Ray, I didn't realized I posted twice in the same area. Thanks for your response! Do you have any suggestions as to where else I can post my question.

Jill
 
B

Bruce Chambers

Greetings --

Something like this should delineate the desired time frame:

[VariableDate] >= [EffectiveDate] AND [VariableDate] <=
([EffectiveDate]+364)

Bruce Chambers

--
Help us help you:



You can have peace. Or you can have freedom. Don't ever count on
having both at once. -- RAH
 

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

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Help! Invoice Calculation/Formula 1
Excel DateDif - why does 2007 seem different? 3
Help! Need Calculation 1
I need help with a Function 0
Help! Need an Invoice Calculation 1
Excel Vba to change displayed year automatically. 14
Calculation Madness 3

Top