Search results for query: *

Hi all, I used to remember how to do this but for some reason I havn't a clue now. I know its possible to type, for instance the 1st three letters of the field you have set the criteria on, and it pulls all the records that include those 3 letters in any part of the word / phrase. for...

I have a main table (AllContactsInLists) and have used the following code to show me all duplicates that occur within this table. In (SELECT [Address] FROM [AllContactsInLists] As Tmp GROUP BY [Address] HAVING Count(*)>1 ) Some of the duplicates contacts have many duplicates. What I would like...

I am using 2 tables in my query and having the above message come up every time I try to populate one of the fields thru the query. Have tried all sorts of possibilities, no index's, no primary keys etc etc but am getting nowhere. When I use a query from either one of the tables on there own I...

I have a table/query with one of the fields [ResearchListID] having numerous values. In my report I am grouping by this field. Can anyone tell me the easiest way to count the different groups...not what is in each group.... 194 194 194 196 196 196 I would like my count to say '2' and not...

Hi all, I am trying to count the number of records in my subform which relate to the main form. I have so far =DCount("[SAMPLE_ID]","sample_table") This works to an extent that it counts all the records within my sample_table. What I'd really like is it to count the...

Hi all, This will probably be easy to fix but is causing me a bit of grief at present. I have a main input form for enquiries which includes a subform for all the types of different requirements to be printed out on a report. The problem is, that if for example I have 4 requirements then my...

Hello, I have an IIf statement in one of my reports which seems to work fine. I would like to instead of the fields listing across the page horizontally, jump to a new line after each record is diplayed. =IIf(IsNull([Customer add 1]),[Customer add 5] & " " & [Customer add...

I have a query with one of the criteria as below. < [number of units ??] I would like to offer the user the opoortunity to just hit return and all the records to be produced, but as it stands if the user hits return the query thinks of it as a zero and only produces records with a zero in it...

I would like to run a criteria in my query that works sort of like the one below, but I would like to bring up all the records less than the number of units I type into the query rather than every record which contains the typed figure. Like &quot;*&quot; & [number of units ??] & &quot;*&quot...

I have a very simple query from a customer tble. I have one check box in my table, and I would like to give the users the option to see the records that are either checked or not. I know how to make the query either show the checked boxes or not, but how do I give the option to the user ...

I have a strange problem. There are a number of Access databases on our network. They all wor perfectly well with WIN98. We now have 6 pc's running WIN2K. 4 of them have been updated with service pack 2, the 2 older ones havn't yet. There is one database which the 4 newer ones can't open...

I have a strange problem. There are a number of Access databases on our network. They all wor perfectly well with WIN98. We now have 6 pc's running WIN2K. 4 of them have been updated with service pack 2, the 2 older ones havn't yet. There is one database which the 4 newer ones can't open...

I have a bizzare problem. We have a WIN2000 server with both WIN2000 and WIN98 clients linked. There is no problem whatso ever with the clients connecting to the shared directory's and folders, but connecting the WIN98 clients to the internet is a different story. Once a client has logged on...

Hi all, I have a simple query that has about 6 fields from 2 tables. Basically the problem (well its not so much a problem, more an annoyance!) is that when the query is run, every single field from both tables is displayed (about 40 fields!). Any ideas / solutions ?? Thanks James

Is there a complete opposite to the Dateadd function?? I want my query to show the last 13 weeks activity as of the date specified by the user. Any help would be appreciated Cheers

I have a report with 2 subreports. The problem I am having is with the 1st subreport. If, for example I have 6 records in my subreport, it is only showing the 1st 5 ! It is always leaving off the last record ! any ideas ??

Hi, I have a excel speadsheet, which has 14 worksheets (named wk1 - wk13 and 1 named MAST). In sheets wk1 - wk13 there are certain cells which are filled in by the user with numerical figures. These cells are constant through each worksheet. i.e wk1!b9, wk2!b9, wk3!b9 etc. etc. In my MASTER...

I have two tables. 1) Main table and 2) Returns table. Now apart from the obvious ordernumberid (which is in both tables), I have a check box field in both tables called works_order_completed? Is there any way once this checkbox has been ticked in my returns table that it can be updated and...

I have an stock report based on the in's and out's of packaged stock. Without using check boxes, is there a script or a way of not showing the out of stock items in my report? Therefore when the stock figure gets to zero that certain report is left off of my report but any report with an...

Right here goes. I have a table where amongst other fields, there is a job number text box (RST number) and a Specification combo box (with a row source (spec/ref)). When I enter an official order I give it a new &quot;RST&quot; number and choose the specification (from my pre-defined options...