Search results

Sorry I should have said, do it in the query that the report is based on.

Group By SOP_ID

In your query criteria under Assigned To field put [Enter Assigned To], this will prompt you each time you run the report.

Set the Record Source of your form to the query (if you use the Forms wizard you can specify the source query or alternatively set the Record Source in the Form Properties to the query), and use the locked property to protect the other fields apart from the comments. See attached.

Using <=Date()+90 as your criteria will pick up those due in the next 90 days.

If you are using a form to update the table you can use Locked Property on the Data Tab of the text box to prevent edits being made to the fields that you dont want changing.

Youre welcome Keiths is better, just a point Keiths query will pick up all records with say a month of Jan, so when you get records covering 2 or more years you'll need to specify the year also. This can be done in the same way as keith showed you, creating a year column replacing "m" with "yy".

It's a security issue relating to XP SP2 I believe, the Environ function has been blocked as its deemed to be unsafe. I discovered this when the function worked on some PC's and not others, I couldn't find a solution to it. I did find an article on it somewhere, but can't lay my hands on it at...

A way would be to create a form where user enters a start date and end date in text boxes on the form. You would then reference this in your query using the following criteria under your date column Between [Forms]![NameofyourForm]![NameofDatefromfield] And...

>=Date() will do it.

Make your criteria: Like [Forms]![frmDescr]![txtDescr] & "*" Should do the trick

Sent you a PM

Hi Maria, My file is in Access 2000, are you using an earlier version? Although reading your posts again it didnt do exactly as you required anyway, but I know what you want now. I think you have your Section form bound to your table when you don't need to, thats why you're getting 57 records...

Hi Maria, It should work using [Forms]![Section]![Section]; assuming Section is form name and Section is combo name. I've attached a simple demo for you. Hope this helps Michael

Try the following as your Row Source for the combo, it should give you a list of sections that exist in your table SELECT DISTINCT [YourTable Name].[Section]From[YourTableName]ORDER BY [YourTable Name].[Section] Or you can create a list of sections and put them in the row source e.g...

Get the user to enter the dates in text boxes on a form and put the date criteria in your queries as Between [Forms]![NameofForm]![DateFromtextboxname] And [Forms]![NameofForm]![DateTotextboxname] This way they will only enter dates once.

Sorry not sure I can help it seems reasonable what you are doing. If you run this SQL in an select query does it select only those records you want to append, or does it also select records that have already exist in SD42_For_Export ? SELECT SD42_For_Import.Site_No...

Does SD42_For_Import hold only the data you want to add to the main table i.e are records you have already uploaded to the main table deleted from SD42_For_Import after they have been uploaded? If not you will have to add some criteria to pick only those records you want to append.

Sorry no, can you post your query design or SQL?

>>But when I want to import new data it deletes the old data out of the table and inserts new data. How can I adjust the query so that it "updates" the new data into the table instead of deleting and then adding?<< Use an append query, rather than a make table query which I'm guessing you are...