Search results for query: *

patricheck: You could add another JOIN using a "derived" table, but since you're new to this, it's easier to change your WHERE and use a subquery. It's easier to see what's happening. ALTER PROCEDURE dbo.FilmStatusQuery AS SELECT t.Date, t.Type, t.Status, t.Notes, c.FirstName, c.LastName...

The type of duplication you're looking for determines how the query needs to be written. Are you trying to list out the order dates for members who have placed multiple orders? This is not quite the same as listing out orders from members whose names are the same. In the first case, people...

Based on our description, it sounds like you are what is often termed a "business analyst". You map out the flow of data within a company and then determine how to make it flow easier and smoothly. Programming skills, while certainly helpful, are not always needed for this. Since you've been...

Because you've grouped by company, then county, Access is going to list the detail records in that order. If you're just trying to get the companies to list in order of their sums, you'd be better off calculating those sums before you assign the recordsource of the report. By that, I mean that...

In the VBA code for the section where these fields print (e.g. Detail_Format): (where PunchIn is the name of the field) Me.PunchIn.Visible = (NZ(Me.PunchIn,"")<> "") The NZ will force a "" value if that field is null. Then the visible property will be set based on that value. If it's not ""...

If you're going to use the link fields properties, you need to have reports that have fields bound to the data. The ControlSource property must be set to the name of the field or SQL statement which provides this data. Similarly, the RecordSource needs to be set either in the property window or...

Since the Group Header is printed before the Detail, placing the Sum in the header won't get you anywhere. The records you're trying to sum haven't been read yet, at the time the header is being printed. Access only sort the input. The output is based on the groupings but is still dependent on...

Sounds like, you have no records left to print, but you're getting an extra page. This can only happen if the detail section itself, or some section physically after it, couldn't fit on the same page with the last record. Access then forces another page to print anything remaining. Rather than...

Access repeats the detail section for each record, so you're always going to have 1 record in that section. Are you referring to the number of records which fit on the printed page?

This doesn't seem like a message from SQL Server as much as it does the VB program trying to interpret the error. If you're using ADO to connect to SQL, be sure to check the ADO errors collection and not the VB error object for proper text of the returned code.

Due to your Group By, you're getting a count of male students for every course returned in the subquery. You need to add a WHERE clause to the Update and link/repeat the fields in that clause to those in the subquery, so they're referencing the same course and gender. You'd be better off...

You're returning multiple values because all the employees Meal Breaks from every day at work are being included. Your subquery also need to include: AND B.EventDate = mytable.EventDate

Since all you're doing on the click of the more button is opening another form, why bother creating a separate function? You can open the form in the same line it takes to do the call, plus you'll actually be in the original form to pass the field, so you won't need all those references. You're...

Aggregate functions are intended for use in the HAVING clause, not the WHERE. Other than the aggregate functions, the key difference between the two is when they are applied. The WHERE conditions are applied for each row of original data, as they are read, before the selected fields are...

This is the wrong forum for this question. Please post in Access Queries and JetSQL. Also, your question is not clear. You don't explain what Under Price and Over Price are. Which price are you talking about?

I subclassed a window and displayed a MsgBox to warn the user when the X was used to close it, rather than the provided Close button. The problem is that the MsgBox only displays the first time this happens. Subsequent times the message seems to be captured and ignored, just no MsgBox. What do...

We were using similar code to change the bExecViewer registry key with Win XP and Access97. Now that we've upgraded to Adobe 6, it no longer does the trick. Version 6 uses a different printer name (Adobe PDF) and the settings are now part of the printer properties rather than just registry...

Version 6 uses &quot;Adobe PDF&quot; as the PDF printer. The settings can be changed by selecting that printer and changing it's properties (on the Ports tab), the way you would with any other printer. Keep in mind that this will apply to all uses of Acrobat, so if you don't want this setting...

Are you printing directly to the Adobe 6 printer, &quot;Adobe PDF&quot;? If you set the printer preferences by selecting the check boxes that appear on the left side (Display, Prompt for Filename, etc) they should set the options for that printer. If you print via the Distiller rather than...

The orientation values are stored in the PrtDevMode structure along with the report. When printing occurs, any settings from the report are merged with the regular system settings to determine how the report will print. If you've set a report to print in landscape, it should overwrite any...