Access 2003, Windows XP Pro. SITUATION: Database has lots, which have sublots, which have items. Sublot key is a barcode number. I have a query that joins...

For the life of me, I can't find where to open any of my saved queries or reports in Office 2007. Can anyone help?

This isn't exactly a Microsoft Access question, but I didn't know where else to go. I am using Microsoft SQL Server Management Studio. The table and field...

I have a query that has multiple columns with dates. I need to be able to query one column against another column. Is that possile? Example: Column A has...

I am not having much luck with trying to write a query to find the last (most recent dates) 5 records for ALL names listed in the 'Customers' table. SELECT...

I can write a query that prompts one field for a specific value, but would like user to enter multiple criteria Example - Lot numbers range from 1 to...

I have no difficulty creating a query that sums the top 20 records. What I need, however, is how to sum the rest, that is, all the other records, excluding...

I have a table which contains a list of products soted by poduct name. Against each product there is a stock quantity, each Item may appear more than once. I...

I have a query that returns all records, except for nulls. I’m experimenting with this: SELECT * FROM Trades WHERE (((Trades.TDATE) Between !! And !!)...

My parameter in Criteria in a query is the following: Contact: IIf(Trim()="",(Trim(),(Trim() & ", " & Trim()))) I am intending it to give me: Surname,...

Thanks for any help. I have a query from a couple tables, and one of the field names in the table is 'IGP' and I have a field in the query that was IGP and...

I want to be able to enter 2 critieria from a prompt box when run query. Eg. AND ...can this be done? Thanks

Have never used Append Queries and therefore lack the knowledge of the same. I have a sample table "Students" with fields like: 1. ID (AutoNumber) 2. Name...

I am using MS Access to create this database and making a query that will show my score of the winning team and the name of the winning team. This is what my...

I want to query a table and only display the record with the latest date. When I add the Totals row to the query grid, the memo fields cut off at 255...

I have read thru many other threads to try and find a solution to my problem but to no avail. My issue: I have two tables that I am trying to link so that my...

I'm trying to scan a field in one of my tables and find a specific character and remove it. However, the character is a " so I'm having difficulty. The...

Hi, I have one table on Microsoft Access 2007 like...

I'm looking to create a query that will pull subform data into it. The subform (four of them) have data that gets manually entered. All the boxes in the...

here is the sql. can someone help me determine why the query isn't grouping by GoupNumber? The GroupName is the same for the GroupNumber. ID is unique. ...