New question for Klatuu or anyone - adding in querries

[Guest]

I gave up working on my date issue since I have been busy with other things
and haven't been able to spend much time on this. I seperated my date field
into 2 fields, one for month and one for year. This is going to cause
problems later on, since I work for a school and our school year goes from
Sept to June. I will deal with it later.

Klatuu - Thanks for helping me with it, I just can't get it. I will return
to that issue later when I have more time.

New question -
I'm doing a querry and I am trying to add fields. I have created this
HS: [9th]+[10th]+[11th]+[12th]
My problem is that when our High School started back in 1989, we did not
have all 4 grades, so my querry won't respond to the years that don't have
input in all 4 fields. I am only getting a total when there is a number
input in all four fields.

Help! I am still trying to beat a deadline.

 

[fredg]

I gave up working on my date issue since I have been busy with other things
and haven't been able to spend much time on this. I seperated my date field
into 2 fields, one for month and one for year. This is going to cause
problems later on, since I work for a school and our school year goes from
Sept to June. I will deal with it later.

Klatuu - Thanks for helping me with it, I just can't get it. I will return
to that issue later when I have more time.

New question -
I'm doing a querry and I am trying to add fields. I have created this
HS: [9th]+[10th]+[11th]+[12th]
My problem is that when our High School started back in 1989, we did not
have all 4 grades, so my querry won't respond to the years that don't have
input in all 4 fields. I am only getting a total when there is a number
input in all four fields.

Help! I am still trying to beat a deadline.

HS: Nz([9th])+Nz([10th)+Nz([11th])+Nz([12th])

Look up the Nz function in VBA help.

 

[Guest]

Awesome - finally something that worked on the first try.

Thanks for your time.

I gave up working on my date issue since I have been busy with other things
and haven't been able to spend much time on this. I seperated my date field
into 2 fields, one for month and one for year. This is going to cause
problems later on, since I work for a school and our school year goes from
Sept to June. I will deal with it later.

Klatuu - Thanks for helping me with it, I just can't get it. I will return
to that issue later when I have more time.

New question -
I'm doing a querry and I am trying to add fields. I have created this
HS: [9th]+[10th]+[11th]+[12th]
My problem is that when our High School started back in 1989, we did not
have all 4 grades, so my querry won't respond to the years that don't have
input in all 4 fields. I am only getting a total when there is a number
input in all four fields.

Help! I am still trying to beat a deadline.

HS: Nz([9th])+Nz([10th)+Nz([11th])+Nz([12th])

Look up the Nz function in VBA help.