Recent content by chris_jolly

How would I go about picking the specific record then? I wouldnt have to sort it, the last record is the most recent. If you could give me an idea how to grab a specific record or row, I could accomplish this task easily.

Hello, I have a link table where I am forming a union query from and would like to take a specific set of data. The table is a timestamp table and I would like to grab the most recent entry. So in theory, I want the max value for the timestamp. I writing this in sql to facilitate the union...

Columns, im sorry

Locking specific columns within a query Hey guys, I have a query on a form in which I want to lock the first two rows to prevent the user from manipulating the data. The user will input information in the third column. How would I go about this Thanks

Thanks NeilEg. I actually figured everything out. I needed to use a BETWEEN AND code in the criteria. For the report I altered the WHERECONDITION by dimming the start and end dates and calling those for the report. Thanks for your help

I figured out how to gather the parameters using a form. Now I need to make the report use the parameters that I have the user input into text boxes. The reports purpose is just to print out the data already entered to provide a way for the user to have a hard copy archive of the data...

Hey Guys, Im having trouble linking the forms to the query. I took your advice and created a form with two text boxes for the input of the dates so that I can store them for my report. However, I cannot get it to work with query. NeilEg when you specified the Forms!MyFormName!MyControlSource...

How would I link the unbound controls to fill the parameters??

to the top

I have a switchboard of sorts that has a command button to open the form that houses the query. The standard "Enter Parameter" pop up box is how I have the user choose a start date and end date

Thanks for the reply. Im not that good with SQL. This is my first database and I have self taught during the entire process. Do you have an example of what you mean about building the sql? Thanks

Hello All, I have a query that the user selects the date range (parameters). I am running a report based on the query and would like to pass the query parameters, which have already been entered, to the report. As of right now, the user must go through the date selection (parameters) again...

Regardless of how that formula is written, I need to figure out how to apply it to the field in the query. When I use the formula in the field it shows up as Expr 1, and the result from the formula is put into the bucket below it. I really do need some help here, is there anyone out that can...

Hey All, I have asked previous questions and searched extensively on this topic and I am still without a solution. Im trying to filter a range in a queries field. Here is the way my query is organized. All this data deals with forecasting for my company... Version - The current version of...

Thanks for the help guys. I just set up a one-to-many relationship and that accomplished what I needed.