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...

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,...

I'd like to extract data from a string variable. The data mostly looks like this: '456 585 8975 / MSKI 105'. An added complication is that the second part of...

Hello. I have the following problem. I have a master list of tags with their description and other information. Two of these information fields is 'Loop' and...

Hello, At the beginning forgive me at the bad English. I am a beginner in Access. I'm working on a database that deals with records warehouse. To simplify...

I have a table in the below format- For example Customer A and Dzip 678 is being served from ozip 099 twice and 011 once ozip dzip customer 099 678 ...

Ocity Dcity equipmt carrier price note chicago Atlanta c dash 1210 most current chicago Atlanta c dash ...

Ocity Dcity equipmt carrier price note chicago Atlanta c dash 1210 most current chicago Atlanta c dash 2310 chicago atlanta d...

While I've created MDE files before, I've never used the Runtime for Access. I was wondering if the runtime limits you to only running existing queries, or...

Ok, being new to Access 2007 I am floundering on how to solve this: I have a "Patient" table wich contains: ID Referral Source Status Start Date I want to...

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...

How do I make it so when a query is opened a dialog pops up asking for an input or Parameter??

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...

I'm trying to create a query using a table of user information and two separate queries with totaled hours over a period of time. Each separate query has a...

This formula will give me the previous month (which is March 2010) and will also include 01 April 2010 data. Between DateSerial(Year(Date()),Month(Date()),1)...

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...

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

I am currently creating my second database using Access 2003. The first, while still leaving me with a few headaches, did not seem to give me the same...

Hi I am trying to write a crosstab query in Access that will give me the totals by week for each person. My data contains a list a people with dates and...

I want to do a percentile rank on a set of data (Basically I would like to reproduce in Access the percentrank formula from Excel) Also, is there a way to do...