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 Replies Reverse Sort Order Views
Error 3290 on CREATE TABLE query by Darizotas
Hello, Whenever I try to include the restriction WITH COMP to a field table in MS Access 2000, it raises a 3290 Error indicating an error syntax at CREATE...
November 1st, 2007 03:23 AM
by Howard in Brisbane Go to last post
9 125
Designing Query - Help Please ASAP by tmdrake
I have built a form with (3) combox's that display different selections. On that form I have a command button. I would like to built a query based on the...
November 7th, 2007 07:42 PM
by Ken Sheridan Go to last post
9 126
Finding Duplicates by Jason[_15_]
Hi all, I'm running Access 2007 and would like to know if this logic is correct for searching duplicates in two tables. I'm trying to find my renewal rate...
November 8th, 2007 02:48 AM
by Dale Fye Go to last post
9 87
Join Query by Esaw
I am trying to create a query that displays data from a combo box and autofill in a subform (I hope that makes sense) But when I set up the query it shows no...
November 19th, 2007 09:23 PM
by Michel Walsh Go to last post
9 145
SQL String by [email protected]
Hi. I am working on an Access database that someone else developed. I have the following code in the database. I need to modify the SQL string statement to...
December 11th, 2007 11:57 AM
by clk[_2_] Go to last post
9 129
Invalid Argument (error 30001) by pon
I am receiving a error " Invalid Argument" only when I run a Make Table Query . But the select query is working fine. I also get the error when I import...
November 28th, 2007 01:27 AM
by Jerry Whittle Go to last post
9 168
Make table query with calculated date fields by Harry
I have a make table query that calculates requirement dates based on a . All of the fields (80 of them) are set as Short Date in properties. But when the...
November 28th, 2007 02:10 PM
by Harry Go to last post
9 162
Sort in an IIf statement by Huber57
To all: I am using Access 2003. I have a IIf statement in a query that looks like this: Owner: (IIf(="Smith Properties","SP#" & (IIf(0,,"XX")),"SD")) The...
December 7th, 2007 09:03 PM
by Marshall Barton Go to last post
9 144
Using Code to build criteria by FBxiii
Hi. I have got a form where the user can select various options for a report. One option I want is for them to be able to select either All Customers or...
December 20th, 2007 05:55 PM
by FBxiii Go to last post
9 131
create one table from six queries by F0zziebear
I have an excel report which draws data from access. The excel table looks like this: Each project is reviewed by two people Reviewer Name | Reviewer1 |...
October 29th, 2007 08:40 PM
by mscertified Go to last post
9 104
Columns based on Date by jenniferspnc
Not sure if I've started this project the right way, so please jump in and offer suggestions. Basically we track monthly totals. I have columns for each...
October 26th, 2007 08:01 PM
by Wolfgang Kais[_2_] Go to last post
9 104
Moving data into a new table once selected from a form by vandy
Hi All, I have a scenario were I am managing an inventory database.Each item stored is based on a project. Once the project is over and if there are...
October 5th, 2007 02:33 PM
by Michel Walsh Go to last post
9 144
please help with a query by Alex
Select DISTINCT No_, , FROM Where .=18 AND .='SALES TERRITORY' --AND 0 AND IS NOT NULL UNION --** This part is not working giving empty...
October 5th, 2007 08:04 PM
by Alex Go to last post
9 185
VBA code in query for new field? by bluesky
Hi - I need to run a query for a mail merge and I need a field that will either return “her” or “him” depending on my “sex” field. My sex field...
October 11th, 2007 08:26 PM
by John Spencer Go to last post
9 133
Profiling Members - please read. by [email protected]
Hi. Simply put, we have a table of order transactions, 'tblOrderTrans' - it currently contains 6 months worth of data. This table is also linked with two...
October 9th, 2007 04:57 PM
by John Spencer Go to last post
9 167
Queries not retrieving the required data by Zeenabu66
My boss has asked me to create a query to find for example all songs by an artist in a CD Collection database. The query can only retrieve some songs for...
October 16th, 2007 11:34 PM
by Zeenabu66 Go to last post
9 175
Query condition by Robin
Hi All, I have two tables for managing our sales orders. One has the order header info such as customer name, account number, etc and the other stores the...
October 24th, 2007 12:14 PM
by Allen Browne Go to last post
9 128
Data Changing Issue by Karen
Hi I am running some queries using a form I created and for some strange reason some people are falling off and coming back to the report when I run the...
October 22nd, 2007 02:27 PM
by Karen Go to last post
9 132
Append Query Error by kalyhan
Hi Everyone! I am trying to run an append query, but it errors out at "Duplicate output destination 'EmployeeID'." I have checked (and re-checked), I see no...
October 26th, 2007 03:06 PM
by kalyhan Go to last post
9 140
Count Question by NeonSky via AccessMonster.com
Hello, Quick question. Is there any way to do a count referencing a field like below and outputting the number to another field, for...
December 21st, 2007 01:44 AM
by John Spencer Go to last post
9 133
Post New Thread


Display Options
Showing threads 2001 to 2020 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:10 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.