|
|
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...
|
|
3 |
827 |
|
|
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...
|
|
3 |
845 |
|
|
|
|
1 |
814 |
|
|
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...
|
|
2 |
906 |
|
|
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...
|
|
5 |
779 |
|
|
|
|
2 |
775 |
|
|
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
|
4 |
928 |
|
|
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...
|
|
2 |
807 |
|
|
|
|
14 |
1,485 |
|
|
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
|
8 |
757 |
|
|
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...
|
|
4 |
731 |
|
|
|
|
7 |
791 |
|
|
|
|
2 |
927 |
|
|
|
|
4 |
1,242 |
|
|
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...
|
|
3 |
867 |
|
|
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,...
|
|
3 |
722 |
|
|
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...
|
|
2 |
704 |
|
|
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
|
4 |
689 |
|
|
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...
|
|
9 |
770 |
|
|
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...
|
|
1 |
695 |