|
|
Query design help requested by
Victoria
hello to all
I'm fairly new at this! Here's my situation. qryA and qry B have identical
structures. The PKey used in both is EmplID.
I need to know how...
|
November 27th, 2009 03:24 PM
by Victoria
|
2 |
262 |
|
|
Not statement not working by
jerry001 via AccessMonster.com
I went through the forum but couldn't find an answer to that
ok
so I need a query that gives all records that don't have a set of values in a
field.
i.e....
|
|
2 |
254 |
|
|
Duplicate Returns. by
Andrew
Sometimes when I do a query, I get the record listed twice (or more) after
hitting Run. The records aren't duplicated in the table, so why am I getting
two...
|
|
3 |
234 |
|
|
Combo Box Not in List function by
Leo
I have a combo box that lists the option (limited to list) from a table
called tblALLRECCS which has only one field called RECS. How do I write a
code in Not...
|
|
1 |
180 |
|
|
|
|
1 |
169 |
|
|
Requerying Automatically by
DawnTreader
Hello All
I have a query like this:
SELECT
utblPartListPriceQuery.ID,
utblPartListPriceQuery.Partnumber,
dbo_PART.ID, dbo_PART.DESCRIPTION,
...
|
|
1 |
201 |
|
|
Merging queries by column in access by
Xmas
Hi, I have a series of queries which get data aggregated by year, e.g.
select year(date), min(var1), avg(var1), max(var1) from table where
(ridiculously...
|
|
1 |
193 |
|
|
Previous Dates by
Peter
Hi all, i am ashamed to admit that i can not figure this one out..
In one table i have the DateCreated field. In my query i want to display all
records...
|
November 26th, 2009 05:31 PM
by Peter
|
2 |
176 |
|
|
|
|
1 |
178 |
|
|
Joining tables by
IgorM[_2_]
Hi
I have two tables - one for debtors and one for creditors, both have the
same columns (name, number, NIP, value). I want to create a table (query)
that...
|
|
1 |
197 |
|
|
Query duplicated entries by
Jose Lopes
Hello everyone. Sorry for such a newbie doubt, but since my Access and SQL
experience is a bit “trial and error” I don’t even know what to search for...
|
|
1 |
197 |
|
|
Double Booking Query by
Andy Day
At present I am trying to make a database for room bookings at work. I'm at the point where I need the database to check for double bookings on the rooms.
I...
|
November 26th, 2009 01:36 PM
by Andy Day
|
3 |
173 |
|
|
Archive in query by
Frank Situmorang[_3_]
Hello,
If I have an Invoice Input Form based on query, which query is also based on
2 tables, supplier table and Invoice table. If I archived that an...
|
|
0 |
166 |
|
|
|
November 26th, 2009 05:04 AM
by 8l2255
|
4 |
223 |
|
|
Columns using month and year by
Sheri
I am trying to create a LAG report that gives what month/year (Jan 2006-Dec
2009) service was given (the rows) to month/year service (again Jan 2006-Dec...
|
|
1 |
168 |
|
|
|
|
1 |
181 |
|
|
|
|
1 |
208 |
|
|
Age calculation in Query by
Dave
Access 2003
I am trying to calculate the age of a person directly in the query.
Not sure it is possible but here is what I have tried that does not...
|
November 25th, 2009 11:14 PM
by JONEPONE
|
6 |
295 |
|
|
# in table by
instereo911 via AccessMonster.com
Hi,
I have a table w/ multiple values on one column seperated out by a ";#" sign.
Example:
State Number
;#Central;#COVA;# ...
|
|
1 |
174 |
|
|
Crystal Reports formula to Access by
lindag
Any suggestions on how to use this formula in Access?
if not(IsNull({MASTER.JMT_DATE})) then "Post Judgment"else
if (IsNull({MASTER.JMT_DATE})) and...
|
November 25th, 2009 09:09 PM
by lindag
|
2 |
155 |