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

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

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

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

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

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

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

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

Hi I have in my query 3 check boxes, which I want to make only one available to the user - thus making only one option available at a time. I can achieve this...

I have been though most of the thread associated with query append and dateadd to see if I can locate a criteria that will suit my needs. I am working on...

I have field KRITERIUM containing strings for example Biii(aii) or Biii(D1) an so on. I want to select all rows that contains uppercase letters anywhere in...

I am trying to create a list box to give the user the ability to select a specific data point to view actual and budget detail. See my SQL below. This query...

hi all, I know not much about sub queries. I need to learn it better. Can anyone recommend any KB Paper, template, book, or anything else where I can learn a...

I want to calc the end time of jobs that I store in a table. We only store the beginning time of each job but the end time would just be the start time of...

i have a access2003 qry "qryWages" which looks something like this paymentID Week 6 6a 1 1 £63.89 ...

Hi All, Does anyone know of a site where I can get a sample of interview Questions for Crystal Report Developer. thanks in advance Ismail -- Message posted...

Hi I am trying to get a report to run on a query that gets it's records from a table with Yes/No data types in it. When I preview the report or look at the...

Hi all, I need to make an update query but not too sure how to do it. I need to count the number of times an item is listed in table 1 and update a quatity...

Help. I'm writing a personnel tracking database. At this time, I have two tables. First table is "Main Table". It has everyone's unique barcode from...