Recent content by Michael J Ross

Thanks! I'll give that a try.

Hi I have a report which I want to export to a txt file as it is to be used as a source file for upload into another system. I can't export directly from a query as the txt file needs to be in a format I can't get directly from a query. I have some problems with it, firstly some of my labels...

Hi Use Max on the date something like SELECT Tablename.Opportunityfield, Max(Tablename.Date) AS MaxOfDate FROM Tablename WHERE (((Tablename.Date) Between #8/1/2009# And #8/31/2009#)) GROUP BY Tablename.Opportunityfield;

How about this?, all in a single expression, shouldn't ask for parameters as long as you are using fields from a table or another query in the query. Total%: 0.4*([Field1]/[Field2])+(0.6*([Field3]/[field4]))

You need to join the tables using a left outer join, and under the criteria of student id in the grade level enter Is Null.

Great glad to help Edit just realised i gave you it the wrong way round, but glad you cracked it.

Yep thats right, update closing first. The code will be somrthing like below, replacing table1 with your table name and correct field names, copy it into the sql view of a blank query. UPDATE Table1 SET Table1.Closing = [Table1].[Opening];

You'd need to run two queries i think, the first to transfer the closing to opening and the second to set the other values to zero.

Sorry my fault, didnt copy code in, try this one. You need to type Paul or John in Text0 and tab. If you want to automatically pick up the user logged in the database, which looking at your original question you do, set the control source of the text0 to =CurrentUser. Access 2000 isnt a...

Hi See the attached it should give you some idea, look at the after update event of Text0 on the form and the On click event of the command button. Also see the criteria in Query3

Thanks Bob, that did the trick. :)

Hi Been away from access for a while, I'm trying to run the following code When i do i get the Run-time error 13 Type Mismatch error, when I click debug it takes me to Set MyRS = MyDB.OpenRecordset("Table1") Anyone got any ideas on what the mismatch is? Thanks in advance for any input

Great glad to help.

Use a form to enter the dates on and reference the form in each of the queries. Add 2 text boxes to a form and in your queries set the criteria (substituting with actual form name and text box names) to: Between [Forms]![Nameoftheformyoucreated]![Nameoftextboxfromdate] And...

If you go into the design view of your query, under the date field you are querying enter the between [Forms]![Rapportdatoområde]![Startdato] AND [Forms]![Rapportdatoområde]![Slutdato] on the Criteria line which is located under Show in the query grid.