I am in the process of designing an access file to sort and analyze data from a survey. There is one survey question that has multiple answers (respondent can...

I am importing data from Excel to an Access table and some of the "timed" data is longer than 24 hours. I need to be able to calculate, or run a query based on...

I have a table where I want to match up product names with a .jpg picture of the product. All the .jpg product picture files are in a folder on my...

I have created a query and want to print the entire query window on 11x17 paper? I am trying to show the joins involved with this query so I can take this to...

I want to save 192 bit-values in 12 integers. How do I save this information in a field in a table? Can I save it in a text field – and how do I the extract...

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another...

i would like to have a number required in a field, but only when a specific text is present in another field of the same table using Access

Hi all, i have a netwok application that read tables in 3 different mdb files. Would it be a good idea for the network load to put all the table in one mdb...

hi can someone help me to round numbers up or down, so if a number is 9.3 it would go to 9.5 and if a number is 7.8 it will go to 8 any help would be greatly...

I want to create a combo box with, in order, Detached, Semi-detached, Bungalow, Flat, Other but the choices KEEP appearing alphabetically. I would be...

Im looking for the Input mask that allows for dates in 2000. Thanks

1. I have a one-to-many relationship. But everytime i go back to the relationship window Access automatically creates another relationship using the same table...

I have value to add two values from two tables and publish results to a third table. ie: (v1 in table A) + (v2 in table B) = (v3 in table C) Is there a...

Access XP - I am trying to change the data format in a table from Yes/No to text. Whenever I attempt to save the changes I receive an error code...

Hi: I have "inherited" a database that has the main table maxed at 256 field defined. Any suggestions on how to clean this mess up easily? Thanks Sandy K

I want to have a table with imperial heights stored (eg 5'10") but when I create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is there any...

Hi, i have a table where passwords are kept and i need a vaidation rule that means the password must have at least one letter and one number. Also woud it be...

Hello, I have a table populated by an append query. The append query appends those records from the source table whose 'model-Nr' field has changed. I want...

I have a table TBL_Tech that has its PK as the TechID. This is the FK for two other tables. I just found out that after a tech is terminated, the supervisor...