Search results

To get a percentage, you need to get a total. In this case you are going to need to get all those on the date(after date) none expired or whatever and not filter on the pcs. But you will need to count the pcs. Twice. Once to get the total. Once to get the pcs=no. Probably will need a sub query...

Use a combination of both (depending if you need to connecto to other mdbs). User/groups in the work group file to stop people connecting to and changing data in your tables. (You only need two users tho and two groups in a addition to the standard ones - one for developers and one for users)...

You can set a subforms details/references? Didn't think it was possible...

Would it be easier to open a recordset object, loop through getting the values you want to an array, then either using multiple updates or another loop with a recordset to update those values accordingly in the other table? (ADO or DAO) As to the code you have, you'd need to redim to a load...

Have the actual date field as the filter with the users input... eg "...Where datefield = #" & <dateselected> & "# ..." Or use the function Month around the date field, somewhat like the above example. Read the help files on the Month function. Vince

Ah I see Ok, so you need to store: FlightDay - number(number 1-7 - Sunday as 1 or monday as one and keep to that as the start of the week) FlightNumber - text DepFlightTime - date/time (just use the time section) DepFlightCityID - number ArrFlightTime - date/time (just use the time section)...

Or write a decent bit of Vba Code

Count function along with aggregated data in sql statements (to get counts) Also, have a look at either: - custom sql statement to put report data into a temp reporting table - base the report on this temp table - Pointing the report dates periods to the form the users use - Grouping function on...

Calculated field on the source query. eg Select [table1].[field] & " " & [table2].[field] as CombRef ... Vince

If you use Docmd.openform "formname" Check the help file on the openform part. There is a arguments section where you can pass a string of variables (such as the Employee ID or the Profile ID) which you can use, or just bind the form back to the other form. You may want to consider disabling...

tblflights FlightID - auto - pk AirlineID - number FlightNo - text - 10 DepFlightDate - date ArrFlightDate - date MaxWeightKilos - number ...other fields... This is only one option and may not be good as something else, depends on how you are searching and how to get the flights info into the...

Seems to work fine - no records for the other three, so the drop lists aren't filled. What exactly is not working?

Check the Access query 'Crosstab'. I think you have enough fields to run it... may be, otherwise its the method posted above :)

Is correct... Your second table then has the following fields: CopyID - auto - pk FilmID - number FilmCopyNumber - number IsHired - y/n AdditionanlNotes - memo/text You then link the top table to this table via the filmID. Ergo - a relationship. Vince

tblCars CarID - auto - pk Manufacturer - text - 50 (make) Model - text - 50 mpg - number - double tblCities CityID - auto - PK CityName - text - 50 DistanceMiles - number - double I would calc the cost... But if you need a look up table tblCosts TravelCostID - auto - pk CarID - number CityID -...

Y/N - Yes / No field usually is actually stored as True/False your where clauses will filter those records returned by what you put in. So it depends what you want to return. YY YN NY NN You'd need to put two sub queries, one for each column. But, note that the combined total may not be the...

Do you mean as you create the top record from one form a set number of linked records are created? Use VBA code as you save the top form. I guess since you are posting this you've used a bound form. This may complicate matters slightly, but you should be able to still use code to create the...

The 'Replace' function may help you...

What tables do you hold and the sorts of values associated in them? (test data) I think you need to calculate the P8 (and any other joined ones) first then add the joined results to the list of outputs that aren't joined and heaven't been reported. Example: LineOutput ID - Line Identifier -...

Don't think so... What situation would there be for doing such a switch? You could open static and still use the connection to execute an Insert Into... or Update... Again, not sure how this would affect the recordset. Vince