Search Result

I have a form that I'm trying to populate. This a summary form. I already have a details form which calculates and shows all the necessary data for a particular item. My problem is that in the summary form I want to show a particular value that I'm already showing in the details form. This value is computed by performing queries and then calculations using the query results. Below is an example of one of the queries.

...

I am trying to decode some set data (in codes) to a description. In Excel I would use a VLookup, but am struggling to write the expression in Access. I have built this into a column in a query, but Access is saying that the 'expression is too complex'. Any help on overcoming this would be greatly appreciated.

...

I am working on building a series of queries and reports based on a database so my associates can simply click on the reports and get important figures. I've run into a problem when it comes to aggregates based on a query with a subquery in it.

I'm used to using PHP and MYSQL to run queries and manage databases, so I'm new to Access syntax and limitations. I'm building these reports in Access 2010.

An example of the...

Hi All!

I have just received thousands of records which were supplied to me all on one excel sheet.

So I imported the entire spreadsheet into one table of Access and added an ID field set on Auto-number to give each record an ID number. The table has company name, address, some other info about the company, who the contact is (might be more than one), and what type of company they are (to us and could be more than one)....

Hello,

I am working on a web page that queries a microsoft access database for our library using wildcards, I have set up the queries using the CONTAINS expression, like so
...

I have a query that has two date fields. One date field is from the Request Table and it is called RequestDate - the date the employee requested training. The second date field is called ClassTaken from the Enrollment Table - and it is the day the employee took the training they requested. I am trying to create a report that asks the user to input one set of dates for the RequestDate field and a different set of dates for the ClassTaken date fields...

Hi,

I am running a few delete queries which r getting executed without any error. But the data in tables are not getting deleted. It is as if the queries were not run. I ran them through debugging but they are executing. Any ideas what is wrong?

thanks

I had an Access 2007 database with 75,000+ records and 60 fields in a table created from data imported from Excel spreadsheets. When a select query was run which counted the totals for each entry in the Manufacturer field, an error message - "Record is deleted" and the option to click on OK or HELP - was received. Of course clicking OK was really the only option and when this was done records, not a single record but several, were gone...

Ok, this is a tough one. I need to query “tblRawData” where “fldID” equals “fldLoop” in “tblLoop” and append the results into “tblResults”. If I were to do this exclusively in SQL, it would look something like this:

INSERT INTO tblResults ( FldID, SRCTNE, SRYRNE, SRSER2, SRFMLY )
SELECT FldID, SRCTNE, SRYRNE, SRSER2, SRFMLY
FROM tblRawData, tblLoop
where tblRawData.FldI D = tblLoop.fldLoop ;
Also, you can...

In an Access Database for field2, the data values could consist of the following:

---field1-------------field2-------
Widget 1-----112398764567
Widget 2-----987611236789
Widget 3-----112345678901
Widget 4-----543287652345

I need a query that will check every 4 characters in the string of field 2 and look for all instances of '1223' OR '9876' are found. So my results would be Widget 1, Widget...

Hi -

I have 2 tables in access currently - all rows have been a unique identifier value assigned.

I want to assign a number of rows from one table to one row in the other table

e.g. in table 1, there is information on a real estate property (1 property per row). each property has a number of comparable sales of properties which I would like to link to a specific property in table 1. All the properties...

Table 1
Part number, Data, Data1, Data2.....
(Part Numer in this table is duplicated multiple times)

Table 2
Part Number, Data 3......
(Part Number in this table is not duplicated)

I would like to create a new table

Table 3
Part Number, Data, Data1, Data2, Data3

I can do this in excel with a vlookup however would like to do this in access

...