Search results

I looked at it so long I couldn't see it. Thanks so much! k

Hello- I've tried everything I can think of to get this code to run. currrentdb.Execute "INSERT into MainRptDataASD (PlanName) VALUES ('Test')" I've tried ' "& test &" " too. Test and PlanName are both string fields. It works fine in the SQL app and inserts a record but I can't get it to...

Yes. That's not a problem as I outlined above. Even if you make them dates in the table you can just display any part of that date in the cbos.

You would need to store them as dates. This would fix the problem.

You would use mmm...for as many spaces as you want to display ie. mmm for Feb, Mar etc... If you are bringing the year and month together at another point this should work fine. Just ignore the date field in the month/date you are creating to display month only.

it doesn't matter what the year is for the display mask. Are you joining the month with the year from your other cbo?

You could still make them dates like 1/1/2005, 2/1/2005 but just masked them as months and leave the date off the view.

Can you make them actual dates so they will list in the right order and then choose the format to display in a different way ie. mmm yy for Feb 05.

Hello- I have place the following statement into field area of a query: Expr1: (SELECT MAX(DateAdd('yyyy',-1,DateSerial(Year([EDRMPeriod]),Month([EDRMPeriod])+1,1))) FROM EDRAppC GROUP BY EDRCHPlan) I ran this select statement in queryman and it returns the results I want. When I try to place...

I have the following statement entered in the query criteria section. SELECT MAX(EDRMPeriod) FROM EDRAppC WHERE EDRMPeriod Between DateAdd("yyyy",-1,DateSerial(Year(EDRMPeriod),Month(EDRMPeriod)+1,1)) AND DateSerial(Year(EDRMPeriod),Month(EDRMPeriod)+1,1) GROUP BY EDRCHPlan I am getting a...