- Queries

Thread preview

Thread	Last Post	Replies

Query TIME saved as TEXT to Sort PROPERLY (e.g. 1:36 PM to list after 10:00AM) ?	03 Jul 2006 00:06 GMT	4
I have a field in a table which stores TIME....but the field HAS to be TEXT, unfortunately The format can be Either 24hr (e.g. 10:00 , 12:35, 13:45, etc) or
Options Group to filter Query	02 Jul 2006 20:03 GMT	1
I had problems getting this going but it seems to be working now, here is my code Private Sub Frame24_AfterUpdate() Select Case Frame24
add value to results returned by a query	02 Jul 2006 16:37 GMT	2
Good morning, I have a very simple query that returns a lists of reports. I use this listing to populate a listbox. I would like to know how I can populate the listbox with the values of the query + the entry "DRM Report"?
#Error	02 Jul 2006 13:13 GMT	2
I am using Access 2003 I have a field called ProductName. The kinds of products available - appear in the following examples: AB1000
How to create a query that will evaluate multiple check boxes	01 Jul 2006 23:48 GMT	3
Lets say I have a table which holds a persons name and then up to five further Yes/No fields which describe the time of the day they might like to watch TV I have a form that has a check box for each of the times, so check
how to convert rows to column in Access	01 Jul 2006 18:10 GMT	1
I have one column with 200 rows and would like to convert it into 200 columns with one row. e.g. sample data is like: Column 1
Covariance Query	01 Jul 2006 15:34 GMT	3
I have multiple columns with data and like to calculate covariance (or correllation). I can use excel functions in Access but i couldnt figure out how can i create arrays to use this function.
Using a union of a left and right join for subreport	01 Jul 2006 13:39 GMT	1
I am using a union query for a recordsource for a subreport. The union is based on a left and right join. When I try to delete and add a record back to the table (in this case it is a record in the query from the left join) the queries are based on, the new record shows up but is ...
Pulling data that is null (front and back end)	01 Jul 2006 13:29 GMT	1
I am unsuccessful in pulling data using my queries, so I am hoping that you could help me. This is the situation: I've created 2 link tables. Data on these tables are coming from an
subquery	01 Jul 2006 13:19 GMT	2
hi, Lets say you have a query which says there are 1280 accounts that have a [DEL GROUP] of "A" for June 28. How do you write a revised query, or subquery that only counts those accounts that had a different [DEL GROUP] on
button action	01 Jul 2006 13:06 GMT	1
hi, I have the following behind a label's OnClick event: MsgBox "test" Dim sSQL As String
How to set default Recordset type	01 Jul 2006 13:02 GMT	1
When I design a new Access Query into my SQL Server database, the Recordset type of the Access defaults to "Dynaset". How can I change the default to "Snapshot"? Thank You
Can i use Select Distinct?	01 Jul 2006 12:25 GMT	10
Let's say I have the following table that contains historical data on file info: FileCode Name Version 01 Alpha 1
display results in columns	01 Jul 2006 12:21 GMT	1
hi, I have the following query: SELECT tbl_account_count_history.popenterdt, tbl_account_count_history.status, tbl_account_count_history.countofstatus AS
module coding in query	01 Jul 2006 12:19 GMT	1
I have a query of many clients and use a code to look at fields in a child table. Not every client in the query has a record in the child table. The code takes 5 fields from the child table and puts them in the form of AA, BB, CC. It does include the child fields that are false. ...