Recent content by lman

I have a report that will be used to display different data but in the same format. I have successfully created a report that will dynamically change the controls (field names, data sources, etc) based on the fields brought in by various crosstab queries. I wanted to go one step further and...

What the error is telling you is you can't have any statements between your SELECT CASE and CASE "Call Center" statements. so the following lines of code are invalid Select Case [Forms]![frmAgentSummaryExport]![cboDepartment] strSQL = "qryAgentSummary_Crosstab.[Agent Name]...

first guess is that platoon is not a field in the personaldata table, if it IS a field then check your spelling of the field, might be a typo.

So are you saying if there is only 1 record returned from the query then it is the customers first order? You could probably do a sub select statment within this statment that counts the number of ordernumbers for the customer and if it = 1 then its the customers first order. I am not an...

I'm still not clear about what you are asking, If these are both transaction tables then I would suggest re-designing your tables because you shouldn't need 2 seperate tables just because the way the price is calculated is different. From what i gather the price is either calculate by weight...

Are these tables intended to be a list of actual transactions or simply look up tables used to calculate amounts to be used elsewhere? Just so everyone can a better understand of what you are needing...thanks

Well that didn't work but i did find a solution, i noticed if you just put an * in the criteria access modifies it to Like "*" so i changed it to like [oper] & "*" and it works perfectly... thanks for your help!

Thanks i'll give it a try...i did try something similar but i forgot to put the #'s in..i'll let you know how i make out...

I'm sure the answer to this is simple, but i can't see the wood for the trees. I have several fields in an access query that i am passing parameters values to through VBA. I use the following statement in the criteria field of the query to check if the value passed is null IIf([oper] Is...