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
Desperate for help by [email protected]
Here is what I am trying to do: I have two controls on a "subform" (a combobox and a textbox). I have the row source of the combo set to the value of a query...
February 16th, 2007 06:10 PM
by Dale Fye Go to last post
1 185
Last Date when two tables involved by gmore
Hi! I am trying to get the last date on the table SIR which is linked to the table SIR_D. Table SIR ----------- SIR_ID (primary key) ENTERED_DATE Table...
February 16th, 2007 05:34 PM
by Jason Lepack Go to last post
7 158
Query last 7 days by [email protected]
HELP!!! Using Access 2000, I have a field titled "Open (date)", I am trying to create a query that gives me only records that have been opened in the last 7...
February 16th, 2007 05:20 PM
by KARL DEWEY Go to last post
3 188
summing a query by Stever
Experimenting with summing in a query. Have a 2 simple tables with part number and qty as fields ie table 1 part1.....qty1 tablw 2 part...
February 16th, 2007 04:42 PM
by KARL DEWEY Go to last post
3 224
Allen Brown please - Crosstab by mhmaid
I am trying to use the example you shown here http://allenbrowne.com/ser-67.html but unfortunatly the columns are coming without value. any help please. I...
February 16th, 2007 03:26 PM
by mhmaid Go to last post
5 338
Count IF Query by richardwo
Hello, I have a query with two fields, Patient Name and FollowUp. FollowUp is a "Yes/No" field and I would like to show a list of patients with the number of...
February 16th, 2007 02:56 PM
by richardwo Go to last post
7 250
In MSAccess einen Timestamp aus einer UUID herauslesen by Chaote
Ich habe eine Tabelle welche die Keys alls UUID hat, nun will ich diese in die richtige reienfolge sortieren. Aus diesem Grund muss ich aus der UUID den...
February 16th, 2007 02:17 PM
by Chaote Go to last post
0 164
Reterving of top 5th value from the table by [email protected]
Table - employee_1 E_ID E_Name Salary 1 Pavan Kumar 5000 2 Ashok 2000 3 Gangadhar 4000 4 Riyaz 2000 5 Kalyan 1000 6 Param ...
February 16th, 2007 01:56 PM
by John Spencer Go to last post
1 237
Exchaning a field with data from another by Jess
Here's my problem, I am an accountant, that is part of the problem I know. I have a client who has data that comes out his software that has names associated...
February 16th, 2007 01:46 PM
by stumac Go to last post
1 147
Query error by Doc Rock
I just started getting a query error when I run the following query. It states the expression is typed incorrectly or is too complex to be evaluated. The...
February 16th, 2007 01:30 PM
by John Spencer Go to last post
1 264
Find duplicate records in multiple tables. by jones6
Hi, Can anyone point me in the right direction to solving this? I have a Table which is a parent table with and Primary key ID and data. I can find duplicate...
February 16th, 2007 08:23 AM
by John Nurick Go to last post
1 161
Crosstab almost perfect by Blair
This is my sql My crosstab has a total across the top, the total decreases as the count goes up in the column rows. I would like a sub total at the bottom...
February 16th, 2007 05:05 AM
by Blair Go to last post
0 145
cannot open file 'AptCashier.mdb' using access 97 by [email protected]
Hi, Don't if this is the right place to post problem here, but anyway, pls help. I cannot open the mdb file with below error, pls help Error...
February 16th, 2007 03:43 AM
by [email protected] Go to last post
0 263
Link AutoNumber to Text Field by mattc66 via AccessMonster.com
Hi All, I have 2 tables that I need to link the AutoNumber to a Text Field in another table. Is this possible? If so, how do I do it? Matt --
February 16th, 2007 01:57 AM
by Rick Brandt Go to last post
4 190
Running Total / Concatinate question by Daesthai
I'm trying to get a running total for hours worked that are divided by project/by date. I have the following fields: Project ID number (saved as text) Date...
February 16th, 2007 01:39 AM
by John Spencer Go to last post
3 165
compariing and listing certain dates by lee
I am using Access 2003 and I have a database that lists vision date, hearing date and consent date on individuals. I would like to develop a query that will...
February 16th, 2007 01:20 AM
by John Spencer Go to last post
4 136
Duplicate Query by quest1914
My apologies, I should have stated that I did attempt the query wizard. I went to Queries, New, Find Duplicate Query Wizard, and it produces a dialogue box...
February 16th, 2007 12:57 AM
by KARL DEWEY Go to last post
1 147
Reports due date by Ldydi525
Hello I created a database to generate grants received. I would like to know how to tracks with reports are due. The reports due dates varies per item such...
February 16th, 2007 12:03 AM
by Smartin Go to last post
3 190
wild cards by Stever
how come wild cards "*" don't work in a linked table query? say I put in as a input request, B* does not return all the part numbers starting with B. That...
February 15th, 2007 11:48 PM
by Stever Go to last post
1 146
Field alias by Dave
Is there a way that I can query fields in table from a table containing a list of the field names? Thank you Dave
February 15th, 2007 11:41 PM
by Duane Hookom Go to last post
1 156
Post New Thread


Display Options
Showing threads 20081 to 20100 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 10:25 AM.


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