Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Ulsterman2
- Content: Threads
- Order by date
-
Make Table Query Problem
The following query makes a table called "tbl Invoices". The query prompts for the values for "From", "To" and "Threshold". The problem is that when the table is created, the field type for these 3 fields is set as "Binary", which means I can't do any calculations in subsequent queries using...- Ulsterman2
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Top n records
I have the following query which selects the top 25 records based on the "Random" field. SELECT TOP 25 [qry Invoices].ID, [qry Invoices].Period, [qry Invoices].Gross, [qry Invoices].Random FROM [qry Invoices] ORDER BY [qry Invoices].Random; The problem is that I do not always want the top...- Ulsterman2
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Fill field
I have a table with approx 20000 records. I have added a new field to the table and want to make the value in that field for all 20000 records =1. I'm a relative newbie to Access and the above sounds simple but I can't find the necessary command. Any advice would be greatly appreciated. Thanks- Ulsterman2
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Differences between values in queries
Hi I'm looking to find the diffence between sequential records in a query, and show that difference as a field in the query. e.g. Shift Total to date Total for shift 1 1000 1000 2 1500 500 3 2100 600 6 5000 3900 The field I require is...- Ulsterman2
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
