Hi Everybody - I have a quick question. I have a field in a query that gives me the previous day using: Issue Date: Date()-1 The issue date is always supposed...

I'm using a "settings" table to capture text strings to use as criteria for queries. So, after selecting an option in a combobox, i have a script that will...

Hi, I have an access DB 2003 where I need to concatenate 3 columns, then update the output to a new column in the table but am struggling to achieve this. For...

Hi all I have a crosstab query, that does what it should. However, I would like to amend it slightly, so that if a the count for a column is not null, replce...

Hi, I am trying to query my data and I want to exclude a whole bunch of values. However when I use not between x and y, it still includes it. I am using MS...

Here's what the data might look like: ID M MStatus Appl ApplStatus Art ArtStatus Appr ApprStatus -- --- -------------- ----- --------------...

I have an update query that joins three tables, A, P & S. S & P are linked with an inner join, P & A with an outer join from P to A. Each join is on three...

I have a dataset that includes a field called Pymnt Days...data in the field represents the number of days that transpire between date of service and payment...

Sorry but I’m new using Access I have a crosstab query (from the table name Paddle) with Diss Unit as Row Heading and Position as Column Heading. The data...

I am struggling with running a query where the field is both a date and a time. i.e. 01/25/2010 3:40 pm. When running the query, it doesn't see anything. ...

Hi, I am trying to take the date of hire for a list of employees. For emample, I need the hire date of 3/3/1990 to populate the 6 mos eval due this year and...

Hi everyone - I am hoping someone can help me out with a problem that I am having. I have a table that contains customer account information, basically what...

Hi, I have data in the following format -- (Sorted by ID and EncoutnerDate) ID EncounterDt NEWVAR-see below 1 1/1/2009 0 1 1/15/2009 14 1 ...

Hello, Ive got a database where staff login just using their name, and the login button has a macro assigned as follows Condition : Not IsNull() Action :...

Ok. Here's the deal. I have a form that i input my data through - customer name, arrival time, departure time etc. - times are entered as short time 24hr...

I have a table that has 5 fields There are many RT numbers can I show which route that has the most LOC_NO for each zip and company number? SELECT...

Hi all, Pls help here.. I have an access file consists of 2 tables x1 , x2. x1 fields are name, place. x2 fields are name, desg, salary, mobile_no. Forms...

Hi, I am trying to work out how to calculate the number of records in a related table for each record in the primary table, and record those results in a...

Hi, How do you declare variables in an Access 2007 SELECT statement? I want to do something like: Dim PCLine as Integer SET PCLine = 0 SELECT IIf(Col1 = 1,...

Hi Guys. Me again. I am busy with a stock control database. I have several tables, the ones that I am having a problem with are as follows: tbl_Stock - Stock...