Hi I am bit new to access. Suppose I want to choose Five Nos from the following table mytable n1 14 18 23 34 38 35

I created a query from one table (it's actually linked to a view in a SQL server called vw_Agent_Stats_new) regarding stats for a customer service rep in a...

How can I implement the following so that a message box apperars if ProjectClosed=-1 SELECT tblA.Project#, tblA.ProjectClosed FROM tblA IF...

In Access 2003, this worked even though "Medal_Assign_Collections" is a query (not a table). Any other way to run this Make Table Query using the results of...

Is it possible for me to group all my data files together in a subfolder like structure such that I can run an append query on the subfolder and have all the...

Hi: For the below qry. for every new month/period I have to go in the Design mode and add the new fileds to be appended to the correspeonding ones; for...

I want to write a query to show 3 rows record in 1 row eg: Emp# Name Amount 002 ABC 2,000 002 ABC 3,000 002 ABC 5,000 I want to print...

I have two related tables: VendorFundedHrs EmployeeVendorAssignment The key to the VendorFundedHrs (ProjectCode) is a longish alphanumeric string which I...

Is it possible to rank the following data set and return different rank values when the cost is the same. Any suggestions would be helpful I can't fiqure...

I have the following SQL statement for an update query: UPDATE tbl_TEPRecords SET tbl_TEPRecords. = True, tbl_TEPRecords. = True WHERE...

I need to combine totals in the report footer with information from a sub report. The totals from the sub report show in the deatil. I need to reference...

Hi, I have a query that looks up about 10 fields from a child table and then 7 fields from 7 related parent tables. I have a subform based on this query...

I have fields with names and dates due for various licences. I want the query to print out a specific name and licences due before January 2009. If I put the...

I have two tables. Table A has a field that lists a 3 digit code. Table B has a field that may contain somewhere in it's value one of these 3 digit codes....

I have a combo box drop-down list in a form, with custom date ranges (manually keyed in to a table), e.g., Jan 1-3, Jan 4-10, Jan 11-18. When the user...

Hi, So this is my code: SELECT (EVENTTIME\10000)+1 AS TimeInterval, Round(Count(ID)/3,0) AS Workloads FROM table GROUP BY (EVENTTIME\10000); This produces...

Greetings! I have a table of 17K records and need to export all the records in increments of 5K. How can I tell my query to only display 1-5000, or...

Hi, Could someone please tell me how I would make an append query based on user entry into a subform. I can create an append query from the combo boxes on...

Hello I am trying to run a query that has 1911 odd rows but only a few rows have the criteria i'm looking for. there are 5 columns and only 6 or 10 rows have...

Ok, I've been thinking about how to do this for sometime and I've gotten close, but nothing seems to be working correctly in the end. I'm sure this is an...