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 / July 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Criteria in my Query06 Jul 2007 15:30 GMT2
I'm sure this is a very easy question to answer but I am new to access so
sorry. I have a list of report names and for my query I want the user to
enter the report name but not have to enter the entire name. For example, if
the reports name  is "access database report" I want the ...
Using a dropdown box in a query06 Jul 2007 15:16 GMT8
I have a list of report names that are in a combo box. I would like to use
this combo box so that I can run a query off it. As in, everyone has say 10
reports so I want them to be able to click the "print report" button and a
drop down box will come up so they can choose their ...
Group same type of field from 3 different queries06 Jul 2007 12:57 GMT3
Can anyone help me with this?
I have 3 different queries each summing up a value for a given month.
Past sales, present sales, future sales, these only have two fields Month
and value.
Coverting Text File to Table06 Jul 2007 12:50 GMT7
I need to create a table showing part number data for items we manufacture.
Unfortunately this is only available in a printed (i.e. on paper) format.
So far I have done the following:
1) Printed to a text file
Generate Range of Dates using Access VBA06 Jul 2007 12:24 GMT3
In Excel 2003 if you put a Date in a cell, you can drag that value
down through the lower cells; and with each cell you pass the date is
incremented by one.  I know that I could then import this data into an
Access database.
Updating06 Jul 2007 10:56 GMT2
hiiiiii suppose i have two fields ( item , price)in a table and i want to
have a querry over that table if the the [item] have apple so i must have 20
in [price] and so on
i really need to solve that problem
add a record in an autolookup query06 Jul 2007 09:33 GMT1
I have a form based on an autolookup query. When I add my vendor number in a
field on the form, Access retrieves all the relevant data for that vendor and
lets me edit it. However, if the vendor does not exist, when I try creating a
new record for that new Vendor, it does not let ...
Updating Fields06 Jul 2007 03:23 GMT5
I have two field in a table and I would like to update one field with data
from another field; both field is in the same table. See the before and after
example below.
             Before
Query to join records according to "hierarchy"06 Jul 2007 02:53 GMT2
My table is something like this:
Fields: Name;   Group
          John;       1-1
          Carl;        1-1
Can I parameter query multiple fields in the same table?05 Jul 2007 21:30 GMT2
I am setting up a database for our search company that is filled with
information on our clients.  I need to be able to track the
organizations to which our clients are applying.  This could be
multiple organizations at one time.
i need simple process if there is any05 Jul 2007 21:26 GMT2
yeah u right that is a good one in Order Subform of the Northwind database
but i am not that much good in Coding .. i need somthing simple like we have
in Ms Excel like Vlookup function that we used or nested if function.
thanks
Viewing database entries when setting parameters05 Jul 2007 21:22 GMT3
I am new to ACCESS and apologize for the naivette of my question.
I am trying to set up a query that will show only entries that contain the
chearacters "CV" in a certain column. In SQL view, I have entred the
following:
usin  expressions in queries.05 Jul 2007 21:00 GMT5
Expression's within queries?????
--------------------------------------------------------------------------------
Hi People
My sales manager has asked me to implement a system where the database will
How do I make just one entry?05 Jul 2007 20:43 GMT2
I have an update query that I run interactively.  I want it to append just one (1) record to my
'RunHistory' table.  ( A table of when I ran this series of queries, who the user was, how many
records read, etc. )  When I've used VB in a module, I've never had any problem.  But this ...
Update query to populate new field with specific ID05 Jul 2007 18:42 GMT1
I have a table with AcctNo, SecurityName, otherfields.
I need to update this table with a new field that would indicate for each
AcctNo row the number of SecurityName. for example:
ACCTNO   NEWFIELD  SECURITYNAME
 
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.