Hi everyone, I have a textfield that I want to change (with a query) to "yymm". Format(;"yyyymm") is working, but not Format(;"yymm")

Bit of a strange one for you. I have a form which has a number of different tick boxes (unlinked to a recordset). Each tick box represents a field within a...

Due to the year changing I now have a crosstab query that returns a Null. When the query was built I did not account for the new year. I would like the...

I am trying to convert a non date string (20071231) to date format (12/31/2007) in access. This data is being imported from another system. I am able to...

I am trying to run a pretty simple select query in Access 2007, and I keep getting the error message "Reserved error (-1524); there is no message for this...

If there are 10 rows in the select query result, how can I have the query number each row from 1 to 10? Thanks in advance.

Hello, I have a table with 25 memo fields used sequentially for separate comments, i.e. if MemoFielD4 is in use then so are 1, 2, and 3. The Note field in...

Holiday greetings good people - please help with your expertise: I have a client search form which has an option group: 1. First Name, 2. Last Name & 3....

I am new to creating Access projects with SQL databases. I have created a View from two tables in my database. One of the tables contains a field that...

Hello, I'm trying to run a query on the opening and closing balances for several years. The factors I need a opening balance closing balance new reserves...

I've created two separate queries and called the first one AssignmentEndQuery. Now I need to combine them into one and place it inside my VB code, but am ...

Hello, How would I write a formula that uses information from a different line in the query? For example, I have 4 fields (a,b,c,tot): a b c ...

I am very new at access and trying to build my own. Can someone logg onto my PC and fix a few things and I will pay you? If not here is my question. I have...

Hi, I'm trying to do my first database and I want to compare 2 tables. Tbl 1: Invoice nmr Part nmr Value Price 1001 A 601 ...

I have table with data for last few years and opening is terribly slow. I want to display data for only one month, or if user want to view all data must...

Using Access2003. This db has a calendar popup form (thanks Allen Browne). The textbox for the date selected is named 'weekloaddate' and the default value is...

I have a simple query- dates on one table and Data (approx 20 columns) inc dates on another. I want to delete from the large table all data pertaining to the...

This may be very elementary, but i can't wrap my brain around it. I have tried to dummy it down as much as i can for myself, with plans of adapting it into...

I am creating a report that includes weight, blood pressure, etc. and have to show a different picture (or symbol) that indicates Fine, Could be better,...

I am attempting to append one table with another. I have several fields whose names are in the form of xxx - yyyy, aaaa - bb, etc. There is a space on...