Search results

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.

I checked most of the bullet items but need some help on a couple. Where do I find if my query has a transform clause? Can you also elaberate about the JOINs issues. Im not sure what the proper index would look like. Everything that is linked up to the query is a primary key, so I wouldnt...

Hey All, I have a form with 2 subforms, both of which are queries. I need one of them to allow for data input/editing. I had it working for a while but now it does not work. Is there a process that I can make one of the them allow for data input?? Is it because Im using a query? Thanks

Thanks Bob, it worked perfectly

Hey all, Im trying to hide/remove the navigation bar on my subforms. My access install didnt include any wizards so I just put in the corresponding table in the subform. So there is no seperate Form that I call in the subform, it is embedded. Is there way I can hide/remove the navigation bar...

Thanks for the response. Im not sure the max/date/time method will work. I need the subform to only display the last entry through the combo boxes. My database can have the same version # (one of the inputs) but have multiple clinkers (cement industry/another input). So I think the max will...