I have a table which columns a product, units, exp date. I want to do a query that gives me two columns: inventory less than a year, inventory More than a...

I have a table with a field that has several values separated by a ; and a space (the values are entered into the table through a milti-select box). I know and...

Hi I have a programme that records all training records and need a rule that flags up when the expiry date is due e.g a few weeks before, any ideas on...

need to import Excel spreadsheet with text fields and return back to Excel numeric field without adjusting the table structure (user interface is only through...

Hello I need to update a filed in a table with values retrived from a calculation made on values from others queries. Here is the code: UPDATE DSPC_PATIENT SET...

Hello I have spent a day without solving my problem. Maybe someone can help. I have a query and the result from this query is to be used in other queries. A...

My thanks to Steve Clark for solution to my recent query on grouping by time interval on a memo field. After some work to adapt to my Tables/Query structures...

Hi, I used to use ADO methods to update certain tables. The problem is sometimes, it takes a second or two before the updates get committed to the database....

I have a table with parts and a class for each part. I would like to have an append query select next 5 classA parts, next 7 classC parts, etc. get from...

I have to have a number that denotes the week number (the number of weeks that have past this year) for example this week is the 44th week. then a number that...

Please can someone let me have some example code for querying an Access database via a VB script. I would like to be able to return a count of rows in a table...

I have a query to delete a tbl, an query to create a new table and a append query that I currently run manually. Is is possible to run these in sequential...

Please help! I have been trying to get the 2 tables to combine into one by a query. Here are sample of my table1 and table2. Table1 ITEM LOC1 LOC2 ...

I have a calculated field in a query say Qry1 based on a linked table say Tbl1: Month: Format(,"mmmm") & " " & Format(,"yyyy") whose output is like: September...

Can there ever be a difference between results produced by and those produced by not whenever they can be used in the same place in a query

i would like to be able to write a make table query which should build 10 different tables. i have tried to do this all in one make table query but it gives...

I have three queries that specify people who will receive a personalized fundraiser letter. Is there an easy way to ask a query (generated for those to receive...

I need to pull random records (non-inclusive membership numbers) from a query. What criteria do I need in the query so that I can run the query from a...

Please help with a query that will provide a list of delinquent entries. I have an “INDICATOR� table with a field named “Indicator#� and a...

Lemme know if I am going at this the wrong way! I have a field that I want a running sum created from. The query is sorted by descending. (A report will do...