Expressions with Different Variable

[antmorano]

I am trying to create a macro or expression for a database that is a
little confusing.

In my database I have a column with a date of hire. There are three
different rows with three different initials for Legal, Pension, and
Health & Welfare.

I need to create some type of an expression or something that allows
me to say- If you add 4 months to the Date of Hire- then there should
be a payment for that fourth month. I.E. D.O.H is 4/1/2006- payments
should commence 8/1/2006.

I have this for two other conditions, but I can figure those out after
I figure this one out. Any input would be greatly appreciated.

This is basically to create or own internal audit of stores.

-Anthony Morano
Pension Intern

 

[Jeff Boyce]

OK, I'll admit I'm confused, too.

Are you saying that each "record" takes up three rows in your table? If so,
that sounds more like a spreadsheet than a relational database.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[antmorano]

Sorry, I must have thought it was clear...lol... yes each record can
take up three rows in my table. At times it may only take up two rows
or even one. Do you think that it would be easier to do this in
Excel?

 

[Jeff Boyce]

I really don't have a very clear picture of what "this" is, so I have no way
to suggest one tool over another.

I can tell you, though, that Access treats each row in a table as a separate
record. As far as I know, there is no such thing in a relational database
design as a "multi-row" record.

If you explain more about what data you have to start with, and what you
want to be able to do with it, the newsgroup readers may be able to offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[antmorano]

Jeff- I appreciate you responding, but I was able to figure out what
I needed to do. I just had to split up the queries into separate
categories.

-Anthony Morano
Pension Intern