Recent content by fixious123

Right now I have a query pulling dates that expire within 30 days and works fine. How do I continue to pull that and include all dates that are expired also? Thank you

Works perfect...

Coming up with Syntax error. Any ideas on where the problem is? The dateadd line is coming up red.

Checkbox This is what I have and its coming up with a compile error Private Sub Check649_Click() If Check649 = True Then Me.HepA = "Series Complete" Else: Me.HepA = Format(DateAdd("m", 6, [Hepatitis A Taken]), dd mmm yy End If End Sub

Thanks Worked like a charm, thanks for the inputs. Only thing is I had to make it bound so it would change betwen records and change the box from a date to text so the date isn't what I want. It shows i.e. 7/23/2003 instead of 23 Jul 03 like I would like.

This should be fairly easy, just not for me. I have a text box on a form that uses DateAdd calculation. I want the textbox to say Series Complete if Checkbox is checked or True and if not continue to use the DateAdd Calculation. This is what I have so far but its off... Any help appreciated...

Dates? Where does this function go?

Expire I want to do this but with a shot record (immunization) database. I don't quite understand this last post but am willing to learn. Don't exactly know where to start, tried this above but didn't work out right. Could someone lend a helping hand and go into a lil more detail. Thanks

Yes two date fields. Thank you for responding

Expired or Current If I want to say that this box will show expired if not within one year of date entered or else it will show current how would that look like. This is obiviously incomplete or way off bat. Thanks =IIf([Hepatitis A Taken]<DateAdd("yyyy",1,[Hepatitis A Taken]),"Current"))...

? about Max Can I still use this when I have two different date fields out of numerous people but I want the most recent date out of those two fields. I.E. I have M16 AFQC and M16 TRQC. I need the latest date out of these two fields. Thanks and I know you've tried to help me, just can't...

Ok making progress but I want to send the most recent date from those two fields to one text box on a report. Is this possible?

Im preety new and didn't understand what you wrote. Could you break it down for me? THanks

Where does this go? Where ExpireDate Between Date() and Date() + 30 Also in my query does all of the duedates have to be lined up. Not exactly sure on how to set all that up. Thanks again

I've tried to piddle around with Top values but to no avail. Any help is greatly appreciated..Thanks