Search results

That's what I thought but I can find record source anywhere in the properties. Oh well I'll just make a new form, thanks anyway.

How do I change the table to which the form data will be entered?

Also would this be better to do with dates or with pay periods? Does Access already have a function like this for dates?

The user needs to see what [Rate] was in a effect for a certain Pay Period (which is a two week period). A query will then pull the [PP] and [process#] and the corresponding [Rate]. This part I've done. The difficuly is that for a range of Pay Periods and a particular [Process #] the rate is...

Thanks, that sounds very helpful. Where exactly do you enter those codes into? Do I have to buld an event? The form inputs are put into a table. How should I enter it in for a table? I don't have to use the PP or Process# in any calculations. The Rate does have to be used in another query...

Yes this is what I want to do, but I was hoping it was a trivial thing to do. The given info for a PP range (say 2-20) has the same "process #" and "rate." I'm not much of a programmer, in fact this is my first time using Access. So please be somewhat verbose in your explanations. Thank You.

Thanks, but I want it so the user will input the info and the appropriate PP's will be filled in in the table. I, as the programmer, don't know the info, so I can't set a default.

I have a form with four inputs: Pay period Start, Pay Period End, Process #, Rate. I want the user to be able to just input PPStart and PPEnd and have the rest of the PP's inbetween fill in automatically with the same info (i.e. Process# and rate). Is there a way I can do this?

Thanks. This idea worked by changing the "Rate" field in the query to "Cost Rate: Rate." And then making the formula "X=Y*Cost Rate" Now I only have to change what table "Cost Rate" references instead of changing the formula each time. Thank You for your help RichMorrison.

Thanks for the reply, but I guess I didn't explain myself very well. I have two tables, TableA and TableB. They both have a field called "rate." I have a field in my query also called "rate" which references TableB's "rate." The only purpose right now of that field is to display the rate on...

I'm having a problem using a field ("rate") in a formula because the field is accessing another field from a table also called "rate". When I try to do say, X=Y*rate, it says "The specified field [rate] could refer to more than one table listed in the FROM clause of your SQL statement." Is...