I'm not a programmer but have built a database for my business. Data is entered through the original at my office. I'm am still in the process of refining it...

I hae a query set up to sort all my data into nice little reports. The only problem is a month from now I don't want to have to print everything just to get...

I setup an address book a few weeks back using a contacts template. I'd like to setup a Greeting Card query but have no idea how to pull just those that I...

I have a form with about 40 buttons on it, and each one opens a report based on a query. What I am trying to do is code the buttons so that there is only...

I have a table: Run_point_List_ID 1 (Autonumber) Run_point_Venue_A Run_point_Venue_B Run_point_Venue_C Run_point_Venue_D How can I get the query to return...

I'm trying to convert a numeric field to a short date format. The current value looks like "20080115". I would like to change that to 01/15/2008. Any...

I am having a display issue with a form that I am using as a subform in datasheet view. When run alone everything works fine but as a subform it does not...

Hello, I have used this before to find out what is in LIst A that's not in LIST B. It is not working this time. SELECT ex_VehicleInventory.,...

The data to populate a combobox resides in a separate database. I need to use the sql returned by my function below to be the rowsource. Is this possible? ...

I have a query which utilises three other queries. There are occassions when i go into design view and I get the 'Can't represent the join expression'...

Can a Yes/No field display data in any format other than check/no check? Can it display Yes/No or -1/0? Thanks, Patrick

Hello, This wasn't answered the first time. A record can belong to one of three groups and each group has a total monetary value attached to it. How can I...

On our Sales Order Entry Form, I've built a comprehensive 'filter' based on concatenating strings into the WHERE of sql, which is then used as the...

Dears While we making a query by using query wizard' there is a option to get sum,min ,max,avg in summary option if the data is in number type. Any body can...

I asked a question a long time ago and received a response that involved retrieving the userid from a user's login to filter the results of a database. ...

In one database, I can type "ny" in the criteria for "state abbv" field and the query with return all records with "NY" in the field. I can't do this in a...

Hi i work since one week with access 2007. And i want to ascending my qeury's by name or description. How can i do that? I don't mean in the query but where...

I have three queries that produce the same three fields: SELECT A.ProductID, A.Description, A.Quantity FROM Query1 AS A SELECT B.ProductID, B.Description,...

I'm trying to save a query (select) as a table but there is no option to save as table.... just query, form, report or data acess page.