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 / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Form Questions13 May 2008 15:50 GMT1
I have a problem that I hope can be fixed by one of two solutions.
On a Form, I have a "Keywords" field for labeling items being entered into a
database. Some items have over 10 keywords. Is there a way to create a
ComboBox that will show a list of possible keywords where many of ...
Query to Update Multiple Records Based on Current Record13 May 2008 15:37 GMT1
I am trying to figure out how to allow a user to update many other records
based on data that was just entered on the current record.
Here is the scenario...
We're tracking charges entered against patient accounts.  Each patient has a
Criteria13 May 2008 15:26 GMT3
i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa [Company Name] which meant
that you had to spell the name exactly as it is written is ther a way so that
i am able to enter just the first few letters ...
Syntax error in insertinto statement13 May 2008 13:48 GMT3
Hai,to every one
here is my question
I have designed the coding to collect the feedback report from the user,
which includes Name of the user, staffno and comments.But when I click on
Passing Function values to a Query13 May 2008 12:53 GMT6
Hi.  I think this may be impossible but I will ask anyway!
I have created a function that evaluates 2 values from fields in a query.  
The function passes a string back made up of 2 parts.  E.g. ABCDE - 4a
The ABCDE is a matched part of the 2 values and the 4a is how they were
Help with query13 May 2008 12:39 GMT2
I have the following:
SELECT [2-2-3-e Result Set].Communes, [2-2-3-e Result Set].[FY 07], [2-2-3-e
Result Set].[FY 08], (nz([FY 08])-nz([FY 07]))/(nz([FY 07])+nz([FY 08])) AS
Percentage
Conditionally Update field in table with data from another table13 May 2008 12:13 GMT2
I am trying to create an update query that when the AcctNo in G1Table = the
AcctNo in FacilityTable (which here it is the primary key), then I want the
County ID and the Region number from the FacilityTable to populate the
corresponding fields County_ID and RegionNo in the ...
Set up mask on parameter value13 May 2008 09:03 GMT3
I have a query when you run it then it will pop up a little screen asking to
enter begining date and ending date. I was wondering if I can set a mask on
the parameter value so that I do not have to remember what is the date
format. I was able to set the mask on the table but the ...
Delete Query wont work13 May 2008 04:41 GMT3
I have a table with some duplicate records I want to delete automatically.
I found this on line help lin
http://office.microsoft.com/en-us/access/HA010345581033.aspx?pid=CH010713951033#13
and tried to follow the instructions.  Worked OK until I got to the final
how to calculate the number of person13 May 2008 02:30 GMT5
I want to ask how to calculate the number of patient based on the
time.
Time of seeing doctor - Time of registration=waiting time
No of patient waiting less than 90 min.
Splitting Out a listing tables12 May 2008 22:22 GMT5
I am trying to work out how I can take a table of data that lists AddressID,
LetterNumber & LetterDate in that form to this way
AddressID  Letter1 Letter1Date AddressID  Letter2 Letter2Date AddressID
Letter3 Letter3Date
Avg query12 May 2008 21:07 GMT5
I think I must be doing something wrong.  I'm trying to get an average of 5
fields in a query using the following:
Total Average Age:
Avg([averageageClassI]+[averageageClassII]+[averageageClassII-a]+[averageageClassIII]+[averageageClassIV])
Rakamları yazıya çevirme access     2003 de12 May 2008 20:39 GMT1
Access 2003'de rakamlar nasıl yazıyaçevrilir bunla ilgili herhangi bir modül
gönderirseniz sevinirim. Ayrıca burda hiç türkçe soru ve cevap yok umarım
access'le ilgilenen gruplar burda yazışırlar. Türkçe gruplar çoğalır.
Delete Query One to Many12 May 2008 20:14 GMT1
I have 2 tables - partial order and backorder file1.  I want to remove all
order numbers on the partial order table from the backorder file1 table.  I
looked at the SQL view and this is what I have
DELETE Back_order_file1.*, [Partial Back order].[Order Number]
how do i?12 May 2008 17:39 GMT7
Questions on an access data base:
I have two tables in a data base
Employee daily ins/outs (time clock)
Employee master file
 
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.