Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Running a query on items selected from a list box.11 Oct 2007 03:45 GMT4
I am trying to create a query that will only show the values for names
selected in a list.
I have a form that has a list box that shows all of the team members. In the
database there is a table that contains all of the stat information for each
Use field for selection but NOT group by?11 Oct 2007 03:39 GMT1
I have a data table.  Right now there are four pertinent fields.  
PPE Date
Function
Task
Button Parameter Query11 Oct 2007 03:34 GMT1
I am a COMPLETE NOVICE struggling with designing a database... Have Mercy!
I need my user to be able to select from a drop down  list of queries from
which the user can then further choose a a single or combination of 7 regions
as the final criteria.
Balance Comparison Query11 Oct 2007 03:09 GMT2
I need some help with this query/report.  My query does a comparison between
records in current month and records in previous month.  It basically takes
active account numbers and balances for current month and compares it to
active accounts and balances from previous month.  I ...
#Error - possible Reference Library omission?11 Oct 2007 02:20 GMT1
I'm comparing MyGroup with the few in RtrnNotice
to identify who (in MyGroup) still needs to "return Notice"
I've tried the below several ways but if there is a match I'm fine (VarType 8)
when there isn't a match (that's who I'm looking for) I get #Error
Creating a Query in code.11 Oct 2007 01:35 GMT1
I am attempting to create a query using vb code.
I have the function created that correctly creates the sql text but I don't
know how to create a query using that sql text.
I have seen other examples of code to do this but they all use Dim db as
"Invalid scale" error during Crosstab10 Oct 2007 23:22 GMT2
I received the error "Invalid scale for decimal data type" while trying to
execute this crosstab query (created with crosstab wizard)
TRANSFORM Sum(INV_ages.Acres) AS SumOfAcres
SELECT INV_ages.period, Sum(INV_ages.Acres) AS [Total Of Acres]
Make Table Query10 Oct 2007 22:17 GMT1
I am currently using a Make Table query for the below - but I was hoping
there is an easier way.
I have to download a report from our Central office which is in another an
excel file. (wp.xls) I then put this data into Access to run reports, etc on
How to exclude certain records10 Oct 2007 20:43 GMT7
How can I create a query to exclude records containing certain words like the
word "accept".  If I have multiple fields containing this word "accept" and
"fail" how can I exclude all records with these words from each field?
I have 3000 records with 5 fields that have this word in ...
Grouped query - last function , how is working ?10 Oct 2007 20:19 GMT2
Please help ,
I have the next table with recording sequence
Id    date                   Info
a    2007.09.01.    a first
New column on redundant field10 Oct 2007 19:47 GMT2
This is oversimplified, but I need to export records from a 3 column table in
this format:
EmpName|WorkHours|WorkDate
DoeJohn|7.0|6/1/2007
Query question10 Oct 2007 17:05 GMT4
I have tried and tried to figure this out and have not.  If I have 10 fields
in a query (all numbers, not text) and I want an 11th field to return the
highest row value in that row (inother words, I have
159,134,190,167,122,189,201,182,174,140 as the values in one row) and I want ...
Update Query and record lock violations10 Oct 2007 17:04 GMT6
I have a local table constructed from two remote sqltables.  I add records
successfully via an append query in Access 2003.  I am attempting to modify
date records that have changed in the remote table to the local table (they
change occasionally in the sqltable) via update query ...
3 conditions in a select query thats populating a newly created fi10 Oct 2007 16:52 GMT2
I would like to build a query that populates the value of a datafield as
either "HIGH", "Med", or "low" depending on the value of a different numeric
field on the table being queried.  I'd like the medium-to-high threshold set
at 10 (lets just say), and the medium-to-low ...
Does an Update query do this?10 Oct 2007 16:13 GMT1
I have a proprietary database of customers that I need to specify
which time zone they are all in.
BACKGROUND:
I have a Company table, with their address in it, and I have an
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.