Search results

Does the query when run by itself display all the appropriate records?

Look at using the DSum function. But it might work better if you use the table name where the data is versus the query. I haven't tried using a DSum on a Query, but maybe? http://www.techonthenet.com/access/functions/domain/dsum.php

You will probably have to add the table that contains the employee number to your query grid. This is because the bound field in your combo box is what is recorded in the table that you are searching. Link the two tables. Set your criteria in the bound field.

Memo fields in Access can hold about 18,000 characters. Excel cells can only hold 255 characters. This may be your issue.

Why cannot you just run a query for the latest on the fly evaluation. Tables that have calculations tied to them need to be continuously updated when there is a change. What happens if the table is not updated and someone searches it for latest data. It is out of date. I would urge you to...

Timmy, firstly an update query would change data in your table. Is that what you want to do or just extract information for reporting/analysis? You are getting a parameter request because Access cannot find the fields you have referenced in your query. Double check the names of your fields...

What type of watch do you wear? Do your kids know how to tell time? http://www.gocomics.com/the-born-loser/2013/01/13 Is cursive writing a lost art?

Spears with poisonous

beautiful blonde amazons

Welcome to the forum. I am sure that your areas of expertise will be useful here. :)

Here is a concept that I have used on several occasions. http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html

A former college roommate of mine writes a newsletter on techonology and this month after attending CES, here are his comments. Scroll down a page or so and see what he says about the future of Television. http://www.ishindler.com/newsletters/2013/2013_01_Perspective_On_CES.htm

Jon; perhaps you could set up an opt out in the User CP section for those not wanting it (ie. those not having a wide screen) Alan

Not sure if the top 5 consisted of $ or count of units. Based upon the information you have provided, here is a SQL for both $ and count. BTW: The term DATE is a reserved term and should not be used. It would be better to use something like sDate or Date1 or some variation. SELECT TOP 5...

Provide us with the table names and the fields for each table. I believe that this is a case of joining the tables on key fields and running an aggregate query.

Try this: UPDATE Flights SET Flights.FTime = DateAdd("h",1,[FTime]) WHERE (((Flights.Flight)="KL723") AND ((Flights.FDate)>#5/13/2013#));

Brian; Those are the search engines, ie. Google, Ask, Yahoo, Bing, etc. reaching their tentacles out into the forum searching for keywords that someone has launched in their search environment. How that works specifically, I cannot answer. Perhaps one of the Admins has a better understanding...

to avoid db bloat, you may be wiser to link the picture to your db rather than insert (embed) it in your db file.

Why don't you post your SQL statement and lets see if we can get you on the right track.

Been watching those old cowboy movies again, Col?