Queries

Remove “www.” from a text string result in Access ExpressionBuild
I have an expression with which I am determining whether or not there is a value for certain fields, then using either a Null string result, one of the field values, or finally, the resulting value which gives me a website address. The problem is that my result needs to have the "www." portion removed from this... 19 Apr 2010 10:32

Serach option
Hi All, I have 1000 records in access table. one field has some records like ... AECH, AUCH, BACH ESCH, DECH, DKCH GBCH, FRCH, EUCH HKCH, HRCH, ISCH ............................................. I need to run a query where above field contains "AE" or "EU" or "HR" I tried like "*AE" or Like "*EU" But ... 19 Apr 2010 07:25

With Function
I hate to cut and paste anything into a module or procedures without understanding a little about how it works. I came across the following code that I could really use. It makes the label blink and using If/End If statements I could use it to flash warnings and 'expired' dates. With Label74 ... 19 Apr 2010 08:27

How do I combine text fields in Access
Hi, I have a small database that keeps track of my mileage. Every trip is recorded in one table with date, start odometer, end odometer and a short description. When I run the query that consolidate it into daily figures, the total miles is calculated, NP - However I can not seem to combine the short into one ... 17 Apr 2010 13:01

Grouping reports and subreports
I am trying to generate a report that is built on four separate reports based on two tables. I would like to run the report so it groups everything into one report based on Class Names. Report 1: class name, professor, exam time, room Report 2: same as above plus four other unique fields Report 3: same as above... 16 Apr 2010 15:07

Trying to update a field
Hello all, I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the total cost of change orders (I totalled these as a sum in another query). ... 22 Apr 2010 14:31

Trying to update multiple fields in the same record (same tabl
Thank you for the quick reply. That worked. "Daryl S" wrote: Eric - I expect that for each year's file, each student will only have one of the three columns filled in (e.g. a student in 9th grade in 2008 would only have Comp_9 in the Comp 2008 table, only Comp_10 in the 2009 table, and Comp_11 i... 16 Apr 2010 12:52

Decimals
Hello, I am making a query for an output file. I have an amount on my input table and then i want to query it out to look a particular way. What i have build in the query looks like below: Amount: Right("000000000" & [Input File]![Award Payment],9) The award payment field is the amount. Only proble... 17 Apr 2010 09:41

Multiple <> query criteria
I am trying to create a query to say I want everything from a table but not the following multiple reference numbers e.g. <>4000 <>3568 <>5869 <>1023 <>4759 If I do just 1 not criteria it works, as soon as i try to put more in it does not work. I have tried putting each one in on a seperate row and tried ... 16 Apr 2010 08:22

Get run time from date time stamps
I need to get run time in minutes from between a series of date/time stamps. I have no clue of how to do this.. any help would be greatly appreciated ... 16 Apr 2010 12:52