| Thread | Last Post | Replies |
|
| Criteria in my Query | 06 Jul 2007 15:30 GMT | 2 |
I'm sure this is a very easy question to answer but I am new to access so sorry. I have a list of report names and for my query I want the user to enter the report name but not have to enter the entire name. For example, if the reports name is "access database report" I want the ...
|
| Using a dropdown box in a query | 06 Jul 2007 15:16 GMT | 8 |
I have a list of report names that are in a combo box. I would like to use this combo box so that I can run a query off it. As in, everyone has say 10 reports so I want them to be able to click the "print report" button and a drop down box will come up so they can choose their ...
|
| Group same type of field from 3 different queries | 06 Jul 2007 12:57 GMT | 3 |
Can anyone help me with this? I have 3 different queries each summing up a value for a given month. Past sales, present sales, future sales, these only have two fields Month and value.
|
| Coverting Text File to Table | 06 Jul 2007 12:50 GMT | 7 |
I need to create a table showing part number data for items we manufacture. Unfortunately this is only available in a printed (i.e. on paper) format. So far I have done the following: 1) Printed to a text file
|
| Generate Range of Dates using Access VBA | 06 Jul 2007 12:24 GMT | 3 |
In Excel 2003 if you put a Date in a cell, you can drag that value down through the lower cells; and with each cell you pass the date is incremented by one. I know that I could then import this data into an Access database.
|
| Updating | 06 Jul 2007 10:56 GMT | 2 |
hiiiiii suppose i have two fields ( item , price)in a table and i want to have a querry over that table if the the [item] have apple so i must have 20 in [price] and so on i really need to solve that problem
|
| add a record in an autolookup query | 06 Jul 2007 09:33 GMT | 1 |
I have a form based on an autolookup query. When I add my vendor number in a field on the form, Access retrieves all the relevant data for that vendor and lets me edit it. However, if the vendor does not exist, when I try creating a new record for that new Vendor, it does not let ...
|
| Updating Fields | 06 Jul 2007 03:23 GMT | 5 |
I have two field in a table and I would like to update one field with data from another field; both field is in the same table. See the before and after example below. Before
|
| Query to join records according to "hierarchy" | 06 Jul 2007 02:53 GMT | 2 |
My table is something like this: Fields: Name; Group John; 1-1 Carl; 1-1
|
| Can I parameter query multiple fields in the same table? | 05 Jul 2007 21:30 GMT | 2 |
I am setting up a database for our search company that is filled with information on our clients. I need to be able to track the organizations to which our clients are applying. This could be multiple organizations at one time.
|
| i need simple process if there is any | 05 Jul 2007 21:26 GMT | 2 |
yeah u right that is a good one in Order Subform of the Northwind database but i am not that much good in Coding .. i need somthing simple like we have in Ms Excel like Vlookup function that we used or nested if function. thanks
|
| Viewing database entries when setting parameters | 05 Jul 2007 21:22 GMT | 3 |
I am new to ACCESS and apologize for the naivette of my question. I am trying to set up a query that will show only entries that contain the chearacters "CV" in a certain column. In SQL view, I have entred the following:
|
| usin expressions in queries. | 05 Jul 2007 21:00 GMT | 5 |
Expression's within queries????? -------------------------------------------------------------------------------- Hi People My sales manager has asked me to implement a system where the database will
|
| How do I make just one entry? | 05 Jul 2007 20:43 GMT | 2 |
I have an update query that I run interactively. I want it to append just one (1) record to my 'RunHistory' table. ( A table of when I ran this series of queries, who the user was, how many records read, etc. ) When I've used VB in a module, I've never had any problem. But this ...
|
| Update query to populate new field with specific ID | 05 Jul 2007 18:42 GMT | 1 |
I have a table with AcctNo, SecurityName, otherfields. I need to update this table with a new field that would indicate for each AcctNo row the number of SecurityName. for example: ACCTNO NEWFIELD SECURITYNAME
|