|
|
Vlookup type function by
Snara
Hello - I am considering transferring our data recording system from an Excel
Spreadsheet to an Access database. I work in a school and one of the key
things...
|
|
2 |
220 |
|
|
|
|
4 |
154 |
|
|
Searching field for Text and Numbers by
Gus
Hello,
Thank you for your time.
I am trying to create a query that would let a user type any criteria such
as a letter(s) or number(s) and have the query...
|
|
1 |
141 |
|
|
Convert number to time by
Floyd Forbes
I have field with numbers like 28815. How do I convert this number to
8:00:15 AM time format.
Is there an easy way to convert numbers to time?
Floyd
|
|
1 |
133 |
|
|
Select query not allowing change by
mav51 via AccessMonster.com
Hi there,
I have a form that is generated by a simple Select query showing all records
where the field 'booPass' is true. I would like users to have the...
|
|
3 |
170 |
|
|
|
|
0 |
113 |
|
|
Equivalent of DROP TABLE IF EXIST? by
Mike Walsh[_2_]
I am fairly new to access but have used MySQL for a while. The problem I
currently trying to solve makes use of a temporary table via a SELECT INTO...
|
|
5 |
161 |
|
|
|
|
3 |
200 |
|
|
Update Query by
Greg
I am working on an auction database where each buyer has a buyer number. I
have a buyer receipt that prints. When I click on the Buyer Receipt button a...
|
July 19th, 2008 08:14 AM
by miss031
|
2 |
125 |
|
|
|
|
1 |
143 |
|
|
Query help needed by
dave
Access 2003
I have a field (Forman) in a table which is a lookup to another table. I an
storing the ID not the name.
When I use the field in a query for a...
|
July 19th, 2008 04:14 AM
by fredg
|
1 |
106 |
|
|
Error 3071 for dates after July 3 2008 by
Ary
I have several reports giving this error. The reports all require To and From
date parameters. They all work perfectly fine for any datae range provided
that...
( 1 2)
|
|
11 |
249 |
|
|
|
July 18th, 2008 11:49 PM
by John
|
4 |
116 |
|
|
Union Query by
broncojim
I am trying to combine the results of several different select queries. Two
of the select queries are listed below. The problem seems to be with the
...
|
|
3 |
118 |
|
|
Delete Related records by
stvlai
Hi
I have a Table that have 4 Fields : ID, Serial_No, Status, Model_No.
Contents of my Table
ID Serial_No Status Model_No
1 11 ...
|
|
2 |
124 |
|
|
Rank after Sort by
CJ
Hi Groupies:
I am creating a database for a golf tournament. After the Thursday and
Friday scores are input, I need to flight the players for Saturday.
I...
|
|
1 |
101 |
|
|
joining on dates by
joemeshuggah
is it possible to join on dates?
for example
inner join mytbl on
date() = mytbl.eff_dt and date() = nz(mytbl.exp_dt,date())
|
|
4 |
178 |
|
|
|
|
5 |
180 |
|
|
|
|
3 |
121 |
|
|
DateDiff function by
RL
I am trying to work out the number of days between two dates, EXCLUDING
WEEKENDS to monitor our order order turnaround time.
I am using the datediff funtion...
|
July 18th, 2008 04:43 PM
by RL
|
3 |
125 |