Recent content by twistedsistem

I have a macro that runs to a sql database that requires a username and password. Is there a way i can set up a vb script to input this for the user automatically. If so can someone help me with that?

ok but i need that to be in my query so is there no way to take them out on the report?

my code does not show an input mask on the report fields. Now in the query i am using the nz code i do not know if that will make a difference on solving this problem will it?

When I run the query by itself i do not get the zeros. I am running calculations on these fields. But like i said when i run the query i do not see the zeros. any ideas on how i can fix this?

I have a report that is bringing in fields from a query and in the query the fields are blank but then the report is printing in the zeros. Does anyone know how to make it so that report just does not print anything in that spot instead of zeros?

Is there a way to get certain parts of the pivot table to not allow the drop down selections?

ok i have a query that runs and i am pulling pay periods and how many vacation hours someone has. now if you chose pay period 5 then that persons name is going to show up 5 times. so what i want to do is add up the hours for all five of those periods for each person and then create my totals...

Thank you rainman and that would work but the names are already in the field and they are not being asked what name to compare i just have a some names that are duplicated because they have multiple rows that they need to be in and so i am wanting it to add it up for the multiple rows they are in.

I am trying to write an expression that will compare names in a field to see if they are the same. then as long as the name is the same i need a field to add another field and then subtract yet another field but if there is nothing in the subtract field then i just want the answer of the two...

This may need to be moved to the query section instead of the form section but I figured I would start here. My co-worker and I have a database that has radial buttons in a form that go in assending order so if you click the first we have it setting a variable to 1 and if you click the second...