I have my option in the table just for easier configuration, but I get too complex SQL message for a number field with 1 or 0 criteria. MyStatus field in...

I have a query that has a calculation based on fields in the query. Now, I don't know how to code or program so I basically use whatever is established in...

I fiinally got the concatenate to work and LOVE it. But want to see if there is a way to format it a different way. I am using: Division:...

Hi All, This criteria should return all record if the parameter is null or the user just press enter. But it's not working please help. IIf( Is Null,"Is...

I have loaded survey results from an on-going bilingual survey and need to combine the results of the English and Spanish questions before running a crosstab...

I have a table with a list of products, the amount of inventory I want for Ea product and what the products order amount is. How do I round the Inventory I...

Hi everybody - I have a problem that I am hoping someone may be able to help me out with. I have a form in my database with 5 different combo boxes. I got...

Hi all. I have a form that filters for certain criteria. I have code to run a filtered report, however I am unable to export directly to Excel. When I try, the...

Hi, When I use inner join, or just a normal join, sometimes Access didn't allow me to delete the records. Sometimes it allows me to delete, sometiems it...

I am using Access 2000. When I click the control on my Switchboard Menu To Go to my Customer's Info Form, the top of the form is missing. I am using forms...

I am trying to put 3 or more data bases. For example:- one item sells today but tomorrow does not sell but I need that item # with "Value 0" How can I print...

I have an imported table of address data which also has an indicator field ( INDO). INDO is either blank (Null) or set to Y. I wish to select address data...

lost once more ... i get the above error (can not open anymore databases) when i try to open a form containing 30 subforms ("subquestion" about this in the...

I am trying to do crosstab query that with a unique PO# count, but unsuccessulf. How do i run this query to count the PO# and group by customer? Right now...

Hi all, I'm trying to select records from a table using the Between function. For example Between #7/1/09# and #7/31/09# The problem I'm having is the Date...

I have an accdb file with the table Accomodations First 3 columns in the table are Property Name: Address: City I can see that Column under Property name...

I recently updated from Access 2000 to Access 2007 In the past I have been able to make a form with start date and end date text boxes and then put a...

Hi I have a query that lists records from three tables. The query lists all patient visits to a doctor’s office. Each record has a diagnosis code (i.e....

I have this query(A) which works fine, however, whenever I make any modification (e.g. change an alias) to another query used in query(A) the syntax of...

how do i to eliminate the pictire of my pc