Updating this question with a...

I am trying to do so, but it is not working. My .bat file: C:\Program Files\Microsoft Office\OFFICE11 E:\IT Dept\Access\database name.mdb /x Marco Name Is...

Hi Guys, Been struggling a bit on this so a pointer would be great. Just a simple example would do.. tableA with two fields "Startdate" and "Amount" now i...

Hello, I have a query that returns these results for me: Badge No DepLastName DepFirstName 11111 Smith Mary 11111 Smith ...

I'm trying to update a query expression and not having much luck. The origional expression pulled a value from a Form and then based on that value summed the...

I am trying in a multi-user environment to have each user able to add data to the next available, unlocked record. I am thinking this is a query, but not...

Hi, I have the following data which I have been tasked with identifying a primary case for each customer. Unfortunately the data contains duplicate records...

I have a table with a code field and a price field. I need to find records where the code field data is the same (I did a duplicate query) Now I need to make...

I have a table to enter contact information where each contact is assigned a random id no. That said it is possible to also associate a Family id no so you...

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

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

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

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

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

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 want to be able to enter 2 critieria from a prompt box when run query. Eg. AND ...can this be done? Thanks

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

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