Search results

In a query in a new field type Total: ([Adults]+[Under15s])*[Nights] Use this query as the record source for a new query. In the new query create an aggregate query to sum the total Field

while dancing with

jail and into

to do with

cross posted at: http://www.excelforum.com/access-tables-and-databases/968965-help-populating-foreign-key-field.html Please read this: http://www.excelguru.ca/content.php?184

In addition to Jack's reference, look at this link on how to normalize your data once you understand what it is all about. http://www.datawright.com.au/access_resources/normalizing_tables_with_repeating_fields_using_VBA.htm

back at the

I think that this link will help you to get your data normalized. http://www.datawright.com.au/access_resources/normalizing_tables_with_repeating_fields_using_VBA.htm

Sub totals find and replace Sort Data Validation

while her gorgeous

wrapped around a

This link should help you get started http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

means of earning

stripper with voluptuous

To maximize an Access form automatically, use the "Maximize" method of the DoCmd Object. Example, let's say I have a form called MainForm, on the "On Load" Event property of the form, I would use this sub procedure: Sub MainForm_Load() DoCmd.Maximize End Sub

I am a little confused by your query. If the date is in the Date Table and in the Mainstem table, why do you need to join the two tables since you are only trying to evaluate the Max of Crooked by Date? BTW: As a point of interest, the word DATE is a reserved word in Access and should not be...

If you have built the query in the QBE (the aggregate one that does not do what you want, based on the premise you explained in the first thread), in the upper left hand corner there is a drop down arrow. Click it. Select SQL and it will open the window that displays the SQL statement for the...

Poporacer: Read this on cross posting and why you may actually get less rather than more from doing so. http://www.excelguru.ca/content.php?184

Suggest you post your SQL statement for analysis

This may be helpful http://forums.aspfree.com/microsoft-access-help-18/access-vs-excel-349267.html