Search results

Is the report sorted by the ID field?

Assuming your 'Case Type' fields are called CaseID in both tables; SELECT GyneCytology1.*, GyneSurgical1.* FROM GyneCytology1 INNER JOIN GyneSurgical1 ON GyneCytology1.CaseID = GyneSurgical1.CaseID WHERE...

All of that *sounds* fine It really depends on what the 'other certain things' are! Best get started on the other questions ....

What are the combobox values for 'Column Count' & 'Column Widths' on your report? How do these values compare to the combox values on your form? Also, I thought that if you wanted to bind a combobox to the first field then you should set 'Bound Column' to 1 and not 0

Add a loop after the setfocus line that moves to the next record until Relationship = MainApplicant

If you're still looking for someone to do this for you then I'll put something together over the weekend.

The MSDN example is almost there If you don't want the slideshow to run, remove the line; ppPres.SlideShowSettings.Run If you want to save the presentation, add a line along the lines of; ppPres.SaveAs "c:\YourFileName.ppt", ppSaveAsPresentation

An alternative would be to add an invisible checkbox and use code to make it visible when you need it

I thought the records were held by a week-ending date so the query condition would be something like, [WeekEnding] between ([ReportDate]-15) AND [ReportDate] (This assumes that there is only one record per week and that the correct week ending date is entered)

DoCmd.ApplyFilter , "[Site Location] = 'Site A' OR [Site Location2] = 'Site A'"

What about having a query to return the 3 records and using columns on a report?

Sorry for misunderstanding your original post. I also don't really understand why you'd want to return such data

Are you looking for "SELECT DISTINCT ...."? The following will return a single record SELECT DISTINCT Table1.SBNO, Query1.[20] FROM Table1 LEFT JOIN Query1 ON Table1.SBNO = Query1.SBNO; Also, This doesn't happen for me, all 6 records are the same (A2k)

I'm guessing that x is not being incremented because it falls within an if statement (that is not returning true 18 times) Try moving x = x + 1 so that it is immediately above Loop (or certainly after End If) Do While x < 18 If rs!eno = Forms!TimesheetDetailsFrm!eno And rs!statusPM =...

Look at the 'Column Headings' setting in the 'query properties' of your crosstab query Only the field names entered here (seperated by a comma) will be displayed in your crosstab query e.g. "Qtr 1","Qtr 2","Qtr 3","Qtr 4"

In your query that produces the 'Player Count' data, change the alias of the 'Team Standing' table to TeamStandingAlias Then add the following expression to your query RunningTotalPlayerCount: (SELECT Count(Player) FROM [Team Standing] Where [GAME DATE] <= TeamStandingAlias.[game date] AND...

Not that I've looked very hard for it but it 'disappeared' in 2000

You had only added an unbound field to the report (and not named it PreviousDate - this was why you had an error) The footer also had to be added as had the code to set PreviousDate = ReadingDate The attached includes this (I've added the items in bold). Are the readings 'meter readings'? If...

Not being formally trained in Access, I thought I'd look up a definition for "me"; Therefore, Me.Date will reference the date field on your report (assuming yor date field name is 'Date') The PreviousDate field will initially have no data but will be set whenever the group footer is...

Add an unbound field in the detail section of your report called 'PreviousDate' Add a group footer for your date field (you don't have to display this footer) and add some code in the 'On Format' event of this along the lines of; Me.PreviousDate = Me.Date You'll then be able to add a...