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 04:14 PM
by Allen Browne Go to last post
3 310
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 02:58 PM
by John Spencer Go to last post
3 283
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 04:33 AM
by PieterLinden via AccessMonster.com Go to last post
1 272
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 01:31 AM
by rwtrader Go to last post
2 296
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 4th, 2010 12:58 AM
by John W. Vinson Go to last post
5 304
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 4th, 2010 12:39 AM
by KARL DEWEY Go to last post
2 305
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 10:00 PM
by Maurice Go to last post
4 466
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 09:17 PM
by vanderghast Go to last post
2 266
SQL "NOT IN" doesn't function as expected (refresh) by Farkyss
Updating this question with a...
(Multi-page thread 1 2)
March 3rd, 2010 08:36 PM
by vanderghast Go to last post
14 557
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 08:34 PM
by pat67 Go to last post
8 301
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 06:22 PM
by gil_wilkes Go to last post
4 276
duplicates data across 3 fields by gil_wilkes
How can i find duplicate data across 3 fields. Thanks in advance.
March 3rd, 2010 06:20 PM
by gil_wilkes Go to last post
7 308
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 05:50 PM
by John Spencer Go to last post
2 489
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 05:24 PM
by PieterLinden via AccessMonster.com Go to last post
4 733
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 04:57 PM
by KARL DEWEY Go to last post
3 328
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 02:34 PM
by Jerry Whittle Go to last post
3 297
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 11:55 AM
by alecgreen Go to last post
2 276
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 11:23 AM
by PayeDoc Go to last post
4 268
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 07:54 AM
by John W. Vinson Go to last post
9 349
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 03:43 AM
by Tom van Stiphout[_2_] Go to last post
1 255
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 02:50 AM.

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