Search results for query: *

Hi there, Below is code I have in an On Current Event item. I want it to run 2 SQL statements - one to see if they have an expired license and one to see if they have expired insurance. I can run it fine with just one of the statements, but it doesn't like when I have 2 statements. Am I...

Does anyone have an experience with using hand held devices (PDA or such) writing to an Access database? If yes, any recommendations on software. This is what it will be used for. Project Managers go to a site to close it out - the contractor doesn't get paid until all items are accounted for...

Hello, Is there an uncomplicated way to share a database across users? I have used synchronization in the past and it's been a disaster. Is there a way to set this up without too much effort? Eventually they'd like 10-15 people using the database (most of them as read only) - but there are 2...

What is the protocol for converting text to a number. For survey purposes I have 1,2,3,4,5,N/A - so if it's a # - I convert it from text to the number and if it's N/A I make it null (for averaging) - but I'm not sure how to make the text format a number..... Anyone know this offhand?? :) Lisa

I'm using the below statement to see if a record exists, and if it does - to mark it with an x. The first problem is that it's not marking it with an x - but Null or -1. I can work with this - all I want it to do is distinguish between the two. The real problem is that I hardcoded this report...

Hello, I want to mark an X under the month if a project occurs during that given month. For example - say I have 3 vendors and 8 projects Start Dt End Dt Vendor A 01/01/03 05/04/03 Vendor A 02/03/03 02/04/03 Vendor A 04/01/03 12/01/03 Vendor B 01/05/03...

I am trying to figure out a workload report. If there are 3 projects: A: from 12/31/02 - 05/01/03 B: from 02/01/03 - 02/09/03 C: from 02/01/03 - 09/10/03 I want to show a workload report that shows each month and then indicates if that project is occuring within that month. How would I...

I have a query (SQL below) that ranks the surveys of projects against one another. What I want to do is write the query so that it ranks Bill's Development 4 projects (1, 2, 3 or 4) then it ranks Resource Systems Projects (1 or 2), etc..... What it's doing, however, is ranking all of the...

Is there a way - while in a query to refresh a table to display all the available fields? The "table" is actually a query I am using as a table in another query. I modified the first query to add a field for quarter and then went in to the new table and it doesn't show query in the...

Hello, I have several surveys - and they have between 10 and 15 questions each. On some of the surveys - only one question is applicable. Right now I count an N/A as if it were a yes, but if the vendor does bad on the only question that is applicable, it will still give them a high rating...

Hello - I have a chart in a report. I've changed the query - updated the chart and I have specified I want a # with 3 decimal points (sometimes it is that close in rankings). The darned report gives me 3 post decimal numbers for every number but one. This one wants to be 57.906667. The...

Is it safe to say that if one would want a very fancy -presentation style - report - with charts/graphs - that Access is not necessarily the place to go? The charts are very ugly (can't come up with another word). I have a report that looks heinous. I've added 2 subreports - one of which is...

Has anyone succeeded in using Lebans rotate text code? I've tried and tried and tried and it won't work. Is there another alternative - or a more user friendly one? I think it's great code - don't get me wrong - but set it up as I'm supposed to and it does nothing. What happens is that I...

Why is this statement wrong? :( Expr1: IIf([Score]>=55,&quot;AT&quot;,&quot;&quot;) Or ([Score] Between 40 And 54,&quot;OT&quot;,&quot;&quot;) Or ([Score]<40,&quot;BT&quot;,&quot;&quot;) I'm trying - in one column - to determine if a score is Above Target, On Target or Below Target. I...

Hello, I have a query that ranks records and I'd like it to say BEST for the highest and WORST for the lowest. If I had a set # of vendors - I could always say that the Rank of 1 = BEST and the Rank of - let's say - 12 was the WORST - but one quarter I may have 12 and the next quarter I may...

I have a customer who wants to what they call &quot;normalize&quot; data - i.e. - if a vendor has 100 projects - they are more likely to fail so they scale the average survey score to reflect that. To do this I have to create like 4 queries (so far). What he did in Excel was take the Score...

Below is a copy of 2 different statements - that - if combined - would do exactly what I want. The first one will look at the Project Manager and create an email (but with no attachment). The second one will take the document I want - put it in the SNP format like I want - but not populate the...

Mind burp. I have a report where I want to hard code that the query returns only data from the current year.....I have created a date part statement and then I'm sure I have to put something in criteria equivalent to the Now() statement... How do I do this? I feel like an idiot for not...

Hello, I have a table where I enter bid information - per square foot. Sometimes the difference between a winning bid and a losing bid is 2 cents. For example, a winning bid may be $17.02 per square foot and the losing bid is $17.04 per square foot. When I enter this information into access...

Hello, I sometimes like to take my work home with me and send the MDB file to my home account via email. Now the database is 15MB and it zips to almost 4 MB which is too large for my mail programs to accept. Is there a better way to compress the database even further? My biggest table has...