Search results

I have a form based on a table. Upon saving the newly added records I also want to concatonate two fields on the form and add them to the table into an existing column "Fullname" The two boxes to be concatonated on the form are "Name" and "Lastname" (both bound) I then draged the...

Hi, I have a table (Tbl_All) which amoungst other columns has the feilds "OrderNumber" and "Pages" (pages contains the number of copies of that report I wish to print. So OrderNumber has a value of "A". Pages has a value of "5" I have created a report with a page break at...

I have some data I would like to go into a report e.g OrderNumber: 123456 QtyOrdered: 10000 We process orders in sets of 3000 so for the above data I would require 4 reports. 3 reports will be for 3000 and the remaining 1000 on the 4th report. So far I have tried with no success...

Hi all, I have a query that uses and ODBC connection to get data into an Access table. I also have a button that outputs that to a server location as a text file. What I need is everytime you hit the output to button it names the resulting text file sequentially. However the first part of the...

Ahhhh this is doing my nugget in!!! I have a simple table with 4 fields ID (unique number) DATE (date) CAPACITY (number of SKU we can hold) ORDERS (number of SKU on order) the data looks like this ID DATE CAPACITY ORDERS 1...

Hi Guys, How can I change the format of a table using a query? basically after the query runs the resulting table all needs to be in a text format even though the fields I am querying are in numeric?

Hi everyone!! I need some advice regarding the following query: This is a big database with many tables and queries etc. but for simplicity lets say i have database with 2 tables (table1 and table2) both contain invoice numbers. table2 contains one record while table1 contains many. Ok simple...