A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Concatenate multiple records by QB
I have a table to enter contact information where each contact is assigned a random id no. That said it is possible to also associate a Family id no so you...
March 4th, 2010 03:14 PM
by Allen Browne Go to last post
3 259
challenging query by Pellissier
I have a table with a code field and a price field. I need to find records where the code field data is the same (I did a duplicate query) Now I need to make...
March 4th, 2010 01:58 PM
by John Spencer Go to last post
3 207
Comapring rows of a table to multple rows within the same table by Mozee
Hi, I have the following data which I have been tasked with identifying a primary case for each customer. Unfortunately the data contains duplicate records...
March 4th, 2010 03:33 AM
by PieterLinden via AccessMonster.com Go to last post
1 219
Choosing unlocked new record by rwtrader
I am trying in a multi-user environment to have each user able to add data to the next available, unlocked record. I am thinking this is a query, but not...
March 4th, 2010 12:31 AM
by rwtrader Go to last post
2 239
IIF Record = by John
I'm trying to update a query expression and not having much luck. The origional expression pulled a value from a Form and then based on that value summed the...
March 3rd, 2010 11:58 PM
by John W. Vinson Go to last post
5 248
Restarting Record Count in a Query by Bill B.
Hello, I have a query that returns these results for me: Badge No DepLastName DepFirstName 11111 Smith Mary 11111 Smith ...
March 3rd, 2010 11:39 PM
by KARL DEWEY Go to last post
2 254
Running average - subquery? by Maurice
Hi Guys, Been struggling a bit on this so a pointer would be great. Just a simple example would do.. tableA with two fields "Startdate" and "Amount" now i...
March 3rd, 2010 09:00 PM
by Maurice Go to last post
4 417
Schedule a Macro with Windows Task Manager by lindag
I am trying to do so, but it is not working. My .bat file: C:\Program Files\Microsoft Office\OFFICE11 E:\IT Dept\Access\database name.mdb /x Marco Name Is...
March 3rd, 2010 08:17 PM
by vanderghast Go to last post
2 212
SQL "NOT IN" doesn't function as expected (refresh) by Farkyss
Updating this question with a...
(Multi-page thread 1 2)
March 3rd, 2010 07:36 PM
by vanderghast Go to last post
14 386
changing totals as a date changes by pat67
Not sure if my subject makes sense so I will explain. I need to create a query that shows open orders for vendors for 2 dates. Previous and Current. When i run...
March 3rd, 2010 07:34 PM
by pat67 Go to last post
8 247
Duplicates by gil_wilkes
In a query how can I check for duplicates in 3 different fields. The duplicates could be in field 1 and field 2, field 1 and field 3 or field 2 and field 3...
March 3rd, 2010 05:22 PM
by gil_wilkes Go to last post
4 215
duplicates data across 3 fields by gil_wilkes
How can i find duplicate data across 3 fields. Thanks in advance.
March 3rd, 2010 05:20 PM
by gil_wilkes Go to last post
7 243
Unable to use filter in datasheet view or add criteria to query indesign view by HouBMan
Hello all, I have a question regarding a custom function. The query results can't be filtered nor can a criteria be used in the design window to...
March 3rd, 2010 04:50 PM
by John Spencer Go to last post
2 385
append queries records with multivalue fields by Dawie Theron
I need to append a number of tables. I make use of an APPEND QUERY and it works fine. BUT, for one part of my application, I need to work with tables which...
March 3rd, 2010 04:24 PM
by PieterLinden via AccessMonster.com Go to last post
4 607
Show One Record For Each Patient ID. by BMC
Hi I have a table that store data when a Patient visits a Medical Centre. I have setup a form to take information (Parameters) for a query to run and all...
March 3rd, 2010 03:57 PM
by KARL DEWEY Go to last post
3 279
QBE by Elaine J.
I have recently started using Access 2007. I like to arrange fields in a particular order when I create a query. I have noticed that if I create a query,...
March 3rd, 2010 01:34 PM
by Jerry Whittle Go to last post
3 245
Help please with nested iif by alecgreen
Hi I am trying to create a nested iif, for the following scenerio - but I am having difficulties if due date is less than today, show yesterdays date. if due...
March 3rd, 2010 10:55 AM
by alecgreen Go to last post
2 225
Very difficult query! by PayeDoc
Hello All I have spent most of today on this and can't get it right: I hope someone out there can help! I need a query that will give a person's retirement...
March 3rd, 2010 10:23 AM
by PayeDoc Go to last post
4 226
Disapearing Query Results! by AMohamadi
Hello Dear I have some Combo Box's on a form that extract data from queries When queries run,the results show to the user that is not necessary! Is it...
March 3rd, 2010 06:54 AM
by John W. Vinson Go to last post
9 261
Database shutdown after idle time by Stryder09
Is it possible to automatically shut down a database if a user has it open but it has been idle(not worked in) for say 10 minutes. I have 5 user groups in a...
March 3rd, 2010 02:43 AM
by Tom van Stiphout[_2_] Go to last post
1 219
Post New Thread


Display Options
Showing threads 1001 to 1020 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.