I had a query that worked what it did was join two tables so that I con enter data. However now I had to add more information to the report this caused me...

Hello, I created a Query in and Access database to delete a record. However I need to return something if the record was found or not. How can I do this? My...

Is it just me or does everyone find having to resize query windows and objects within for every single new query you write annoying? Does anyone know a...

I have a list of stores that we represent that I want to run a query against a table that list any store that has orderd from this company. The query I want...

I have a backend database that is password protected. I want to backup to a table in this database using the maketable query. But when running the following...

Good morning, I have user security on a workflow database with a manager and five subordinates. The manager is the only one with Admins privileges. He is...

Hi. Does CREATE VIEW work in MS Access ? I have to modify query using DDL SQL. Thanks for any help.

I've read through the many many threads already here on this subject but can't seem to translate what I see in those answers into solving my query - I realize...

I have a query that is a number field. All the data currently shows the number 1 in each field. I want to covert the number 1 to the number 85 to use in my...

I have a table that has fields T1 to T10 corresponting to fields DEC1 to DEC10 and I would like to search the fields in DEC1 to DEC10 , based on a criteria...

Hi, I'm trying to design a sort of search panel where the user types in the first few letters of a customer's name into a textbox, clicks a command button,...

I have a large table, with many instances of data. Each record has an identifier field and a date field. I want to find the first occurence of the record...

Seen an unanswered post the other day and was interested in what the solution may be. The question was or simular to: If you wanted to sort by colors VS....

Like "*"&&"*" where Record ID is entered by a user how I can make sure what they enter is seen as a string so that a user does not have a problem...

SELECT SUM(Binding_physical_damage + binding_damaging_repairs + binding_chemical_damage + binding_biological_damage + binding_brittle_paper) as...

Hi I have a query in access. I have 1 table in my query and 14 fields in my table. I am using all 14 fields in my query and have sorted the first 13 fields in...

I'm trying to combine this data: SELECT tbl_PullData.FiscalYear, tbl_PullData.Period, tbl_PullData.Store, tbl_Stores., tbl_PullData.Date, tbl_PullData.,...

Like "*"&&"*" where Record ID is entered by a user how I can make sure what they enter is seen as a string so that a user does not have a problem...

I have a many-to-many relationship set up (with a linking table with two one- many relationships), where both "many" sides include a UserID that references a...

Hello all; I have created a search query. I want to put in search criteria that would filter the data. All I want to do is have the software look for two...